Projects

Mindfire has deep experience developing FileMaker desktop/server/web software applications. We describe some of these FileMaker database development project experiences below, and will be glad to share our expertise in detail with you.

You would also find these pages interesting:
   FileMaker development services
   FileMaker/PHP/Lasso web development

To discuss about our services and how we could work together, please contact us on sales@mindfiresolutions.com or call 1-248-686-1424.

  • B2B FileMaker plug-in
  • Application for Law Firms
  • Application for Cap Business
  • Application for Garment Business
  • Migration (FM6 to FM8)
  • Patient & Resource Scheduling
  • Event Management System
  • Client Server Application in Filemaker 8.5 for Printing Industry
  • Fire Safety Certification Management
  • Contract Generation
  • Publish Manager
  • Client Server Application for a member of the Estate
  • Client Server Office Management application in Filemaker 8.5
  • Radiology report creation and archival system
  • Application for Pathlogy Lab
  • EMR software migration from FileMakerP6 to FileMakerP8
  • Business Management System
  • Television Show Builder
  • Migration from FMP7 to FMP9 and MSQL Sync
  • Dermatology Management
  • Contact Management System
  • Yearbook Publication Management System
  • Micro Biotest
  • Data Collection Application
  • Project Management System
  • Disease Information Search
  • Contact Management Database
  • Media Enterprise System
  • Request Fulfilment System for Television
  • Chocolate Recipe Builder System
  • Building Sales Application
  • Recruiter System
  • Purchase Order Management System
  • FM Data extraction
  • Patient's Medical Information Recording Device
  • Contact Data Profiling Application
  • Application for labor coach
  • Email Campaign System
  • Order Management System
  • Magazine Subscribers
  • FileMaker Pro 11 Database Tool
  • Bakery Distribution
  • Crate Management Software
  • ERP - A FileMaker Solution
  • Report Optimization
  • FileMakerGo Project Management System
  • Event Management
  • Task Management System
  • FileMaker App for Garment Business
  • Patient Relationship Management (PRM) with Psychologist
  • Gynecology, Infertility EMR
  • Event Management Database
  • Point Of Sale Software
  • Work Order Management Database
  • Camp Management System
  • FileMaker - CRM/ERP System
  • Vehicle maintenance and overhaul contracts tracking system
  • CRM database solution migration to Filemaker Pro 10
  • FileMaker - Octink and Rep
  • FileMaker - AIMS Eco System & AIMS Default System
  • Job Tracking System
  • FileMaker CRM
  • Furniture iPad application
  • FileMaker Go App for Food Joints
  • Event Management, Reservation and Selling system
  • Document Management System
  • Medical diagnosis tracking System
  • Wholesale Mangement System for Furniture Companies
  • SportsManagement System
  • Event Management System for a Fashion World
  • Application For Apartment Booking
  • Recording forms and fillings from website in Filemaker
  • Track monster job visitors
  • Cookbook Software
  • Internal Trace Mobile System
  • School Admission Data Management System
  • Project Management Database
  • Project and Task Management System
  • Application For Employment
  • System for Relief and Welfare Department
  • POS system for Jewelry Retail store
  • Task Tracker System
  • Inventory Management for a Furniture Business
  • Email Moving Application
  • Contacts Database
  • Project Management Application
  • Home Inspection Application
  • Flooring Management Application
  • Leads and Task Management
  • Work Allocation Management System
  • Learning Application
  • Ticket Management System
  • Real Estate MIS
  • Insurance Compensation Management
  • Project Management System
  • Real Estate Project


B2B FileMaker plug-in

Client:
Distributor-Dealer system and Inventory software provider
Industry:
Furnishing
Technologies:
C++, wxWidgets, FileMaker SDK, FileMaker scripting

We developed a FileMaker plug-in which provides Electronic Data Interchange (EDI) facilities to the dealer/reseller software system extensively used in the industry. It provides facility for connecting to the FTP sites of various vendors that the dealer trades with, downloading and uploading electronic documents in the form of ANSI X12 transaction sets. Custom processing of the electronic documents is implemented for translation to and from the Dealers software system.


Application for Law Firms

Client:
Lawyer Firm
Industry:
Legal Services
Technologies:
FileMaker Pro 8.5 Advanced, Plug-ins (Troi Menu control, Troi File Control, Ozium Portal Filter)

It's a powerful, configurable, predictive knowledge management system specifically designed for law firms, government lawyer offices and individual practitioners that captures and outputs the written and spoken words needed to represent any party in any jurisdiction in any area of law. It's the knowledge management system for the lawyer that uses the data captured in other cases to predict what the lawyer wants to do in the current case. The work of expressing the process of lawyering took place in one brain without the need for translation and communication between different parties trained in different disciplines.


Application for Cap Business

Client:
Software solutions provider
Industry:
Textile - Apparel Clothing
Technologies:
FileMaker Pro 8.5 Advanced

This system contains the entire business process of a cap company.
Product Mgt: Varieties of cap styles available in the stores and different add-ons for the cap style are maintained in this module.
Contact Mgt: Detailed information of clients, customers, vendors, company staff, manufacturers, etc. are maintained in this module.
Sales Mgt: Cap quotations for the customers can be created in this module and then placed as an order to the cap company.
Inventory Mgt: After selling the caps, all the inventory details (such as cap availability, cost, etc.) for the particular cap is maintained in this module.
Production Mgt: This module contains all the steps to be followed during the production of a cap/order.
Payment: Payment for the order can be done via credit cards, cash, checks, etc.


Application for Garment Business

Client:
Software solutions provider
Industry:
Textile - Apparel Clothing
Technologies:
FileMaker Pro 8 Advanced

This business system contains the entire business process of a Garment company having products of multiple stores.
Technologies: FileMaker
Product Mgt: Garments such as shirts, caps, etc. available in different stores and all the add-ons specifics for the above products are maintained in this module.
Contact Mgt: All the clients, customers, vendors, company staff, manufacturers, etc. detail information are maintained in this module.
Sales Mgt: Quotations for the customers can be created in this module and then placed as an order to the specific company. 
Inventory Mgt: After selling the garments the entire products purchase and availability details (such as product sold, availability, cost, etc.) are maintained in the inventory.


Migration (FM6 to FM8)

Client:
Estate and trust software provider
Industry:
Software Product and Services
Technologies:
FileMaker Developer 6, FileMaker Pro 8 Advanced, MetaDataMagic

This is an "Estates and Trusts Administration" software. We worked on migrating the application from FileMaker Pro 6 to FileMaker Pro 8. We used a migration tool MetaDataMagic to extract all Pre-Conversion and Post-Conversion issues related to FileMaker Pro 6 files and resolved them.


Patient & Resource Scheduling

Client:
Dermatology group
Industry:
Healthcare
Technologies:
FileMaker Pro 8.5 Advanced, Plug-ins (Dacons Menu control, Dacons mail.it, S4HU_EventScript)

This application has multiple functionalities such as; calendar for scheduling, new appointment creation, change status of appointments, appointment cancellation, rescheduling, adding patients to the recall list, adding appointments to the wait list, reschedule appointments directly from recall list and wait list, resource scheduling, edit resource schedule on daily as well as monthly basis, reports generation, sending reports to email and ftp etc.


Event Management System

Client:
Software solutions provider
Industry:
Service provider for trade shows and events
Technologies:
FileMaker Pro 8.5 Advanced

This is an Event Marketing & Services business system which will organize different shows with its selected items either by promoter, exhibitor or Broker.  1. Product Mgt: Different items used in shows and decoration items such as table, chair, wastebasket etc. available in stores are maintained in this module.  2. Contact Mgt: All the customers, clients, exhibitor, promoter, brokers etc. detail information is maintained in this module.  3. Event Mgt: It mainly categorizes the events by company selected by the customers. In this module customer's show items have been loaded/unloaded on trucks of the route, and maintained in Inventory after return.  4. Invoicing: Once a show is organized and routed, its invoice is created with all details of the show items that were selected for organizing that particular event.


Client Server Application in Filemaker 8.5 for Printing Industry

Client:
Specialized in Printing , Publishing , Travel and manufacturing Software in Filemaker 
Industry:
Software product for  print business
Technologies:
Filemaker 8.5

We developed functionality and features for a new version of the software. Features included file upload, multilevel reporting, separation of data and Interface file for security.


Fire Safety Certification Management

Client:
Client Server application in Filemaker Specialized in Public Relation Solutions
Industry:
Software product for  print business 
Technologies:
FileMaker

The Solution is developed in Filemaker 8.5. We added features like Dashboard Interface, validate certification requests of the user, functionality to validate exam requests of the user, notify the user about the reasons of rejection of his request for the exam and certification, search functionality,  audit log for all login, navigation  though the system, Custom menu for different user with different access. 


Contract Generation

Client:
A client server solution in Filemaker specialized in developing solutions that are compliant with government regulations such as HIPAA compliance, or campaign fundraising compliance
Industry:
Public Relations
Technologies:
Filemaker 8.5.

This application specializes in tracking contracts, or prospective contracts, and then outputs different types of reports. It manages information about the contractors and contractees and their organizations. We developed features, to generate different contracts for different clients; to electronically send contracts to clients; custom menus to allow the user to use interface specific features, keep track of presentations, their locations and clients; keep track of clients and their organizations; separate data and interface files for security purpose etc.


Publish Manager

Client:
A client server solution in Filemaker Specialized in Publishing and Printing  Software
Industry:
Publishing Industry
Technologies:
Filemaker 8.5 & IndesignCS2

Migrated the system from Filemaker 6 to filmmaker 8 and added new features to the migrated version of the application. We changed the Architecture, cleaned up the DB, removed the Table which were not required and consolidated the tables. Existing 64 Files were reduced to 1 file. We also implemented and integrated the management, advertising/subscription sales, distribution, production and editorial for magazine and newspaper publishing. It boasts full CRM with extensive reporting capability. We created a template in IndesignCS 2 to dynamically display classified advertisements, by importing an xml file generated by the FileMaker application. This xml file was generated through a script and contained all the data about classified ads like Section, Subsection, Display Image, Notes etc. To ensure that valid xml data is imported a DTD file was created.


Client Server Application for a member of the Estate

Client:
Specializes in Printing, Publishing, Travel and Manufacturing Software in Filemaker & nbsp;
Industry:
RealEstate
Technologies:
FileMaker 8.5

The earlier version of the application was in FileMaker 6 and had 16 FileMaker files. We developed the software in FileMaker 8.5 and with one FileMaker file. Developed features were to; manage security guard shifts, book tennis court for the members of the apartment, manage visitors' car parking, file updated feature, multilevel in reporting and all the features in FileMaker 6.


Client Server Office Management application in Filemaker 8.5

Client:
Product Company specialized in office solution
Industry:
Public Relations
Technologies:
Filemaker 8.5

The application is an integrated office solution consisting  of several modules like Address, People, Correspondence, Project, Article, Order, Delivery note, Expenditure etc. The application was in Filemaker 6  and we migrated it to filemaker 8.5 and resolved all the issues produced during migration. The migration issues were analysed by MetaDataMagic (A product of New Millennium Communications Inc.).


Radiology report creation and archival system

Client:
Diagnostic  Radiology
Industry:
HealthCare
Technologies:
Filemaker 7, Dragon

The client server system we developed is a user-friendly, secure, radiology report creation and archival system that can be accessed by authorized users. The main features are Secure, Encryption of data at every step, Secure transmission of data, Retrieval of data only by authorized users, Complies with HIPAA standards (Health Insurance Portability and Accountability Act, a U.S. Law), enables radiologist to make his own reports using his own dictation codes in oral or written form, Providers' offices can do periodic searches of their  reports, e.g., twice daily, to make sure they have the reports on their patients that have been recently imaged. It can accommodate an unlimited number of institutions (imaging centers, referring providers, radiologists, institutions with prior studies, etc.)


Application for Pathlogy Lab

Client:
Pathlab
Industry:
HealthCare
Technologies:
Filemaker 8, Dragon

We developed the client server application for pathological lab. The major features include barcode technology to be used to scan the paperwork allowing the case to show up in the system instead of entering the case number manually, etc. Searchable database that has the ability to search all fields, including free text. Statistical analysis of the clients, and also of the various antibodies, probes, etc. Faxing reports. The ability to incorporate a digital image in the case report, with a figure legend. Reagent and equipment purchasing and ordering log. Calling a client regarding a case from within the case (using plugin).


EMR software migration from FileMakerP6 to FileMakerP8

Client:
Heathcare Firm
Industry:
HealthCare
Technologies:
Filemaker 6, Filemaker 8, MetaDatamagic , Filemaker plugins ( Secure FM)

We migrated an Electronic Medical Record software from FileMaker 6 to FileMaker 8 and also consolidated the scripts. We used MetaDataMagic tool to generate the pre and post conversion issues and resolved them.


Business Management System

Client:
Software Solution Provider
Industry:
Software Product and Services
Technologies:
FileMaker 6, FileMaker 7, FileMaker 8, FileMaker 8.5, FileMaker 9,Plugins ( Mailit)

The application is a fully integrated multi-user database.  It helps to automate your business processes. We were involved in fixing bugs in FileMakerP6 and migrating the application from FileMakerP6 to FileMakerP7. In the migration process we used MetaDataMagic and FMrobot to generate pre and post conversion issues .  In phase 2 of Migration, our goal was to consolidate the migrated FileMakerP7 database application into a stable FileMaker 8 database application, retaining all similar functionality in 10 files (initially there were 64 files), consolidate the script and minimize the number of scripts and also integrate the new features of FMP8 e.g. tabbed layout, tool tips.  In phase 3 we added new features to the system and  customized the system for Industries like healthcare , International Printing, Concrete  and Tiles, Leather and Tack etc.


Television Show Builder

Client:
Software Development Company
Industry:
Media
Technologies:
FileMaker Pro 9.0 Advanced, FileMaker Server 9.0 Advanced, Oracle 10i, SQL Server 2005

This system is based on building shows before they are aired live on television. It is used by the Live Television Shopping Network which runs live shows 24 hours a day, every day.  Initially the show is scheduled to air live on Television on a particular date and time. The show items, hosts and guests are decided by the planner. Once the show is planned for a date and time, it is sent to the run up system, where Supervising Producers and Associate Producers are assigned to the show to produce it. The producers do the modifications to the running sequence of the show segments. They also verify and add the required supports (B-Roll, Graphics, Audio, Stills, active/passive elements, etc.) for the show.  Once all the necessary digital/support items are gathered, the show is hand over to a Live Show Producer. The show runs live on television after reviewed by the Live Producer.


Migration from FMP7 to FMP9 and MSQL Sync

Client:
Tourism Company
Industry:
Tourism
Technologies:
FileMaker Pro 9 , ODBC , MySql

This project is to manage the clients, contract & booking of advisements in the travel directory published by the Tourism Company every year. We migrated the application from FileMaker Pro 7 to FileMaker Pro 9 by reducing the no. of layouts by using tabs and we also grouped scripts and used script parameters wherever applicable. We also minimized the use of global fields by introducing global variables and added a new functionality to sync with MYSQL by using the shadow tables of MYSQL ODBC 


Dermatology Management

Client:
Dermatology group
Industry:
Healthcare
Technologies:
FileMaker 9 Advanced, Plug-ins (Dacons Menu control, S4HU_EventScript, Troi File, e-sign)

The application was developed for Dermatology practice/clinic. It has been equipped with managing patient, insurance, patient visit, physicians and practices.  The application has a utility which allows the users to drag and drop dots to the images of the body part to record diagnosis and procedure during patient visit. It manages documents, instructions, letters, with the ability of e-signature. Other functionalities such has, mechanism to import scanned documents to the application, management of photographs are implemented with-in the application.  Application provides all information (date by date) related to patient and their visits are documented in PDF format (know as patient chart).

Moreover, the application has a functionality of interoffice email messaging in which the users can send and receive messages within the application environment. The application also has a functionality of transferring the requisitions (specimens report) to the FTP folder from where it can be picked up by the labs for processing and diagnosis.

The different PDF reports related to patients and their visits are stored in a centralized FTP folder thus making the application lightweight and the use of Internet Information Services (IIS) makes the viewing of the above PDF reports faster from within the application.

The application has auto-update functionality which automatically loads the different plug-ins required for the operation on the client machines from the server while starting the application.


Contact Management System

Client:
Software Solutions Provider
Industry:
Non-Profit Organization
Technologies:
FileMaker Pro 9 Advanced

This is a multi-file Contact Management System developed using FileMaker Pro 9 Advanced - an application with data separation model concept used.  This system has been designed to store personal contacts and contact information, person's employment details, managing the company details in which the person works. It has the ability to group people and companies into different groups/communities. It has a module to track people and companies who have given pledge to donate and/or actual donations to the non-profit companies/organizations. It also stores events that are set up to generate money and donations for different projects, it also tracks attendee information for each event. Education module is maintained to store school, teachers, students, grants requested by teachers and scholarships applied by students. This CRM system has the feature of creating email and letter templates that can be reused and also tracks people that receive the letters and emails.


Yearbook Publication Management System

Client:
Software Solutions Provider
Industry:
Book Publications
Technologies:
FileMaker Pro 9 Advanced

This is a multi-file Yearbook Publication Management System developed using FileMaker Pro 9 Advanced with data separation model concept used. This system has been developed to be used by the publishers to manage books publishing each year. It has a repository for customers to order for the published books and the publication distribution list.


Micro Biotest

Client:
Software Solutions Provider
Industry:
Education
Technologies:
FileMaker Pro 9 Advanced

This is a multi file application with data separation model concept used. This system provides solution to the organization doing numerous studies for various sponsors (companies). System tracks information about each study on the materials maintained in the inventory, including the sponsor and the person from the sponsor who did the study, and also tracks the bunch of logging and test information used in the study.


Data Collection Application

Client:
Software Solutions Provider
Industry:
Museum
Technologies:
FileMaker Pro 9 Advanced

The Data Collection Application system was developed using FileMaker Pro 9 Advanced. It  collects demographic information for contacts of the institution. The system tracks contacts, newsletters, newsletters sent or to be sent, contact interests, and more. The system is designed for certain information to be made available through a website, including the possibility of allowing contacts to log into a website to update their own information.  The system stores contacts information, managing the company details in which the person works. This system has a feature of creating email and letter templates that can be reused and also tracks the people that receive the letters and emails. The system can groups people for a specific mailing type or interest type and can send letters/emails to only those group of people and admin can view the report to whom the letter/email has been send with its company name.  This is a multi file application with data separation model concept used.


Project Management System

Client:
Software Solutions Provider
Industry:
Software ISV
Technologies:
FileMaker Pro 9 Advanced

This is a Project Management System on FileMaker Pro Advanced. It uses multiple files and a data separation model concept. This system holds projects and its invoice items detail, staffs and labors working in the project and user information for that project. It has the ability to send email to all the staffs included in a project or to an individual staff. This system has been designed to store contacts information, person's employment details and to manage the company and project details in which the person works.


Disease Information Search

Industry:
HealthCare
Technologies:
FileMaker Pro 9

Disease Information Search, is a compilation of information on an existing Filemaker database on genetics and diseases. The tool provides different categories of information which it stores and maintains.

The different categories of information include:-
•People- This has all informaiton related to people in the database; people's address, organisations, events details.
•Organisation- This segment has information related to organisation; organisation's address, member list of organisation, events in which the orgnisation partcipated.
•Events- Events are very broad. This category was created so that anything that involves direct interaction with organisation members can be linked to a username.  This can be something as clear as a meeting or something more abstract like a web poll, or being registered to receive the weekly bulletin. Events have information on event details, Event activities, speakers.
•Event Activities- Activities are essentially events within events. For eg-ATCG Meeting. This meeting is made up of several activities: Content Workshop – Religion & Genetics, Quality Presentation, and Usability Presentations.
•Event Speakers- Speakers register with topics within each activity. .
•Conferences- Conferences are made up of Events. It is a just like an event, though here there are many events.
•Sponorships- Sponors are just details about Sponors who invest in events.
•Legislators- Legislatore have all contact and activity information related to United States congressmen (representatives and senators). Each Congressman (member of congress) will have his own record with associated addresses, staffers, committees, policy activities and legislative actions.


Contact Management Database

Industry:
Media
Technologies:
FileMaker Pro Version 7

This is a system developed in FileMaker Pro Version 7 that stores contact information of the members associated with the music shows to be performed. It stores detail account and contact information of the advertisers, artists, audiences, board members, contributors, grant makers, show presenters, sponsors, vendors and volunteers associated with a show. The system has the functionality of storing other contact names who are related to a member. It has the ability to allow a user to search by multiple contact/member names on individual accounts. For example user will be able to search for spouses or domestic partners individually, regardless of whether or not they share the same last name. The system has functionality to export the searched contacts to external file formats.


Media Enterprise System

Client:
Software Development Company
Industry:
Media
Technologies:
FileMaker Pro 10 Advanced, FileMaker Server 10 Advanced

This software is an enterprise level Project Management System designed to manage and streamline the day-to-day operations for Creative, Production and On-Air departments for Television and Radio Networks. It keeps the entire Promo Department informed, from Production Assistants to Producers and from Management to Accounting. It assists the whole staff in performing a variety of tasks and functions that keeps the production flow efficient.

The system manages all aspects of on-air programming such as adding promotional items, script management, adding music tracks to the promos, production planning, budget estimation, tape library management, music library management, session scheduling. It allows user to build premiere and episodes to air weekly or in day's interval for a show. It has user dashboard implemented which gives an overview of all the projects planning, approval of items, on-air planning, project management and project tools or documents used in the project. It has the server side emailing, reporting and printing features implemented. The software runs in real-time, supporting upto 250 simultaneous users across the company's WAN or LAN keeping the entire production team up-to-date in all aspects of production.


Request Fulfilment System for Television

Client:
Software Development Company
Industry:
Media
Technologies:
FileMaker Pro 9 Advanced, FileMaker Server 9 Advanced

This system is developed in FileMaker for television show production house. This system is cross platform compatible and developed to be used by both FileMaker Pro and IWP users. During the show building process there are requirements for supporting assets such as graphics, videos, animation, stills, for the show which the producer makes a request to the production house or creative department to build the asset for them.

This system keeps track of the tactics or requests made by different departments such as production, advance services, marketing, programming departments, etc. It provides a request or tactic form to the requesting departments to make a new request to other fulfilling departments. The system then redirects the requests to their respective fulfilling department managers. The managers can then assign staffs or resources to the tactic, who are going to work on the request and fulfill the requirements of the requesting department. The system has a communication portal built within it that will allow the resources and the fulfillment managers communicate with each other by sending messages and attachments on a particular tactic during the processing period which helps them. The system has user dashboard feature implemented in it which shows the lists of jobs assigned to the current user. It has an audio and visual alert on the user's dashboard if there is any new message for the user and also for a new message which comes in to user's dashboard. The resources can send message to requesting person asking for some other required detail to fulfill the request and vice versa. Once the resources finish their job, the system will automatically indicate the requesting persons or fulfilling managers that their request has been fulfilled and ask for their approval. It has the graphical chart feature implemented that draws the bar chart for the manager on the work progress of all the staffs and the staffs can see a graphical chart of their assigned tactics and their progress. The system has a section which allows Admin to manage the system configuration. It has a Contact Management module which stores all the contact details of the employees of the company. This system has the user's login via active directory groups. It has the report generation and printing the reports feature implemented for both FileMaker Pro and IWP users.


Chocolate Recipe Builder System

Client:
Software Development Company
Industry:
Media
Technologies:
FileMaker Pro 9 Advanced

This system is designed to be used by chocolate factory for keeping the track of  chocolate making processes. The system has cross platform usability, fonts, graphics and formats. It is designed to be used in touch screen monitors to entered extract data on a desktop workstation during the chocolate recipe building process. It is a relational database developed in FileMaker that keep track of the processes/steps followed during the building of different types of chocolate recipes with different flavors and tastes. The system uniquely identifies the beans and track how they are used.

Different Modules implemented in this application are as follows:

Inventory: This module allows new Batch entries in the inventory for different types of beans and inventory. It keeps track of relevant bean data, GPA Coordinate with Google map integration and the process control with several cut tests. It has the search functionality which allows the search for a particular batch or batches based on the user entered criteria. It has the printing functionality built which allows the users to print the inventory detail and to label printing features with barcode, the bar which is printed on each label for a batch.

LAB: This module consists of sub modules or processes which keep track of the Roasting, Liquor, Refining, Conching processes. The system keeps track of the moisture measurement, roasting temperature, and baking time, machine ID of the machine used in each roasting cycles, liquor processes, the ratio of all the ingredients added during refining process and tracks the temperature and humidity parameters and time taken by the conching processes. This system allows the lab users to maintain a checklist ofr all the above processes which the bean has under gone and print the checklists. It has the printing capability to print the Batch Processes, summary of Batch Process based on process data and characteristics of the process output.

RECIPE: This section allows building new chocolate recipes out of different ratios of samples. A new recipe can also be derived from other base recipes. It keeps track the formula of the recipes with a detailed path of origin to all beans and all measurements and specific information of all other ingredients used in a recipe.

TASTE: This is a section where the panel tasters can give ratings and comments on the prepared chocolate samples. They can fill up a feedback form on the mouth feel, experience, odor, color, appearance, smell, aspect, flavor, etc. on a chocolate sample or recipe.

CONTACTS: This is a contact management module developed in this system which stores all the organization, vendor, and company staff contact detail information.

ADMIN: This section allows administrator to add new users to the system and assign them to different roles. All the modules in this system are restricted to be accessed by users with specific roles. It has a dashboard which shows all the beans from the inventory with their Inventory status, lab stages, recipes and the taste stages added by tasters. It also shows a summary of complete path of processes a sample has followed. Also has a printing option to print labels for a sample.


Building Sales Application

Client:
Contact Data Management Service Provider
Industry:
Small/Medium Industries
Technologies:
FIleMaker Pro 10 Advanced, FileMaker Server 10 Advanced

The ALLSALES application use to manage the company, contact, projects and employee. The application is mainly developed to streamline the process, and get rid of spreadsheet usage. The application consists of following modules.

Employee Management Module : Accessible by only Super-users/admin - It stores all the employees information with the following functionalities – Employee Addition/Search, Show All and Record Navigation.

Company Management Module : Accessible by only super-users/admin - It is the master database to store the master list of companies and has the following functionalities – Add/Upload New Company, Merge Duplicate Companies, Show All, Export Companies

Contact Management Module: Accessible by only super-users/admin - It is the master database to store the master list of contacts and has following functionalities: Import Contacts, New Contact, Manage Duplicate Contacts, Show All, Export Contacts, Record Navigation

Project Tracking Module : Accessible by users having following roles: super-user/admin, manager, requestor, caller and QA. This section of the system holds each client requests as a project and track tasks related to staffs.

Super-user : The super-user can create a new project for the request made by a client by clicking the "New Project" link from the top header section on the Project Detail/List views.

The user can then import the Companies/Contacts list from an excel file given by the client for the project by clicking on an "Import Companies" or "Import Contacts" link from the top header section.

Once the project is created then the super-user will assign the project to the manager.

Following reports are available for the super admin: Caller Report, Manager & QA Team Report, Productivity Report

Manager:Once the project is assigned to the manager, it will be visible to his dashboard.Manager then can enter project related information, add researcher, caller, QA and assign tasks to them. A new functionality called Auto Assign Tasks', which enables the manager to auto-assign the tasks to caller / researchers

Researcher : When the task gets assigned to researcher, it will be visible under the project they are assigned to. Researcher will start working on the tasks, which will have a list of company assigned to them along with the target. Researcher will do web-search for contact information related to list of company assigned to them and enter into the system.

Caller : When the task gets assigned to caller, it will be visible under the project they are assigned to. Caller will start the verification process for the contacts they are assigned to. Caller will then mark the contact verified or error.

QA:When the task gets assigned to QA, it will be visible under the project they are assigned to. QA will each and every contact contacts they are assigned to. Caller will then mark the contact Approved or error.

Admin Settings / Configuration Module : Company Info: This tab is used to edit the company's information.

Employees: This tab is used to show all active employees

Custom value lists: This tab is used to edit the custom value lists used in the system.

Export: This tab has the functionalities to allow Super-user to Export Contacts by Project, Export Companies by Project, Export All Contacts, Export All Companies.

We have worked on enhancement of this project and added new functionalities such as:

1. A new user role "HR Manager" is introduced to the Salebuild application who will review the performance report.

2. The contacts will undergo Project Manager's approval once verified by caller. A portal has been developed to keep track of the contact rejection history. The rejected contacts will be reassigned to the Caller.

3. The contact will be locked for a resource once it moves to next stage of verification.

4. Different search options are provided to the users to find duplicate contacts or companies from the database by matching words or patterns and by phonetics.

5. Dynamic portal sorting has been implemented to sort the lists according to the users.

6. Integrated an email verification tool to verify contact email address.


Recruiter System

Client:
On-line classifieds company
Industry:
HR Recruitment
Technologies:
FileMaker Pro Advanced 9

This is a contact management system developed in FileMaker Pro Advanced 9 that stores the companies, its related contacts, contact history, job orders, applicants and their detail information. We worked on the "Applicants" module to develop a feature that allows to assign candidates to different work locations with certain designations. The location and position assignment process has some validation rules to follow. For example not more than four applicants can be assigned to a particular location with a particular position. It has the flexibility of adding new other locations and positions under certain categories to the existing lists.

The system also has a cross tabular grid report to view the location and position allocation chart or applicant inventory chart based on the user selected position categories. The chart tool has pagination implemented on it. User can move back and forth between the chart pages by using next, previous arrows. This also has option to allow user to directly navigate to first and last pages of the chart views.


Purchase Order Management System

Client:
A Leading Logistics Company
Industry:
Logistics
Technologies:
FileMaker Pro Advanced 9/10

This is a system developed in FileMaker Pro Advanced 9/10 that keeps track of the Stores and their Purchase Orders from different Vendors. This system comprises of 3 main modules such as: Items, Vendors and Stores. The Items section stores all the items used in the system along with their detail information. There are options to add/edit/delete items from the system. The items are supplied by vendors which are maintained in Vendors section of the system. All the vendor information and their contact details are maintained in the system. The system has the functionality to add multiple vendors/suppliers for an Item and vice versa. The system has a module that keeps track of the Stores and the list of items purchased by the stores. The users can purchase/order new items for their stores using this system. The system allows the users to view the items and their prices available for different vendors and order the item from a vendor of their choice. The system has built in printing and reporting features that allows the store users to print their order reports sub summarized by the item category and order status or by vendors and send them to their franchise.


FM Data extraction

Client:
Publishing
Industry:
Publishing
Technologies:
FileMaker Pro 10 Advanced

This software is used by a publishing company which publishes and distributes magazines and books. This software allows the customers to subscribe the magazines and distributes the number of copies of the magazines to them. Customers can place their order for new subscription or renewal of magazines and do the payments in the system. The software also keeps track of yearly subscriptions and subscription offers that are valid for a time period.


Patient's Medical Information Recording Device

Client:
Medical Devices Provider Company
Industry:
Healthcare
Technologies:
FileMaker Pro Advanced 10, Platforms: MAC and Windows

This is a cross platform runtime solution developed using FileMaker Pro 10 Advanced for both MAC and PC users. This software is developed for a marketing company that provides portable devices to record medical information (both current and past records) of an individual. The software has AutoRun feature built in for Windows version so that it will auto open the product, once the USB is plugged in to the Windows system. This product is purchased and used by individuals to maintain their medical records. The software allows to record patient personal information, emergency contact information, patient's medical history and past surgeries, medical conditions, alergies checks (if the patient has any) and immunization checks and also records medical insurance details. It has the ability to allow user to save the medical forms as PDF and take printout of the forms and send them to this company to get a quick medical advices.


Contact Data Profiling Application

Client:
Contact Data Management Service Provider
Industry:
SME
Technologies:
FileMaker Pro 10 Advanced, FileMaker Server 10 Advanced

This application is used by the sales team of a research company to discover contacts for a list of companies requested by their clients and do the contact data profiling by doing a survey with asking the contacts some pre-defined questions and answer choices set by the project managers. The application is mainly developed to streamline the process, and get rid of spreadsheet usage. The application defines the work flow of profiling process for different users based on their roles/privileges. It allows the super user to create new project for the client requests and upload a list of companies or a list of contacts with companies to the project that are provided by the client. Then the project is send to a research team by assigning a manager of the project. The manager assigns the companies to callers by creating multiple tasks and also defines a set of profiling questions and their answer choices which are to be asked by the callers while their verification process. The caller then verifies one contact per company based on the answers given by contacts and sends the verified contacts and their detail information to the manager for his approval. The manager then passes those searched contacts to the QA team to get their final approval on the contacts. Once the QA approves the contacts, the contacts will be uploaded to a master database. It also allows the managers to create a new project for contact discovery process from a profiling project and vice versa. The system has reporting capabilities to allow the higher level authorities to view the performance reports of researchers, callers, manager and QA team report and productivity report.


Application for labor coach

Client:
Software solution supporting labor coach business
Industry:
Healthcare
Technologies:
FileMaker Pro Advanced 10, Platforms: MAC OS X and Windows

This is a database tool developed to be used by the hospitals specifically for birth and postpartum doulas. This system is developed using FileMaker Pro 11 Advanced which runs on both Mac OSX and the Windows platforms.



The system comprises of several modules like: Calendar, Jobs, Clients, Resources, Service Lists and a Preference module. In Calendar module the user can view the events i.e meetings, appointments, client due dates, baby's birthday, etc. on specific dates in a monthly, weekly and daily calendar. The user can add new events to the calendar dates as well. It provides option to manage the holiday lists in the system and color code the holiday's in the calendar views with a user specified color. The user can categories the calendar events and define color codes for each categories in the user preferences so that in the calendar views the events with same category will be color coded as defined in the preference.



In Clients module the user can add/update client information in the hospital record. They can generate dynamic client list report based on user specified find criteria. User can add multiple find criteria and can dynamically change the columns in the client list according to their requirement.



The Jobs module keeps track of how much time spend with clients, the user can keep track of the work hours, birth data, immediate postpartum, postpartum charting etc. User can view the invoice reports by job number and the payments received for the job in this module. It has option to find jobs by job number and client name.



It has a section to manage the vendor and /or resource information. It has a section that allows the user to add goods or services to offer the clients. Once entered, invoices can be created with these items in the invoices module. In Invoices module, invoices can be created for clients by adding the invoice details and line items.


Email Campaign System

Client:
Tourism Service
Industry:
Tourism
Technologies:
FileMaker Pro Advanced 10, FileMaker Server Advanced 10

This system has been developed in FileMaker for a travel agency to allow them to create email templates which are to be used for their campaigning by sending a series of HTML formatted emails to a list of customers in the mailing list inviting them to look at or book travel offers. The system has an ability to allow users of this software to create and save several email templates with HTML formatted text as body content in the database. User can add dynamic tags to the email body which will be evaluated at the runtime when the email will be send to the customers. The user can also save one or more attachments to the email templates. This system has an admin panel where the user can set up the SMTP server information for outgoing emails.



It has a "Contact Management" module where the user can manage its customers list in the database. It provides the ability to search for a list of customers in the mailing list based on user entered search criteria and choose an email template from the available list of templates and send them to the customers filtered list. The system has a section where user can schedule/setup the follow up e-mails to be sent out to the customers after a certain period of days if they have not responded to the first/original email. It has an automation process to frequently send the follow up e-mails to the customers at the defined interval.


Order Management System

Industry:
Data Collection
Technologies:
FileMaker Pro 10, FileMaker Server Advanced 10, 360 Works SuperContainer, 360 Works ScriptMaster, 360 Works Email plug-in

This software is developed to be used as an Order Management System. The application is developed in FileMaker technology and 3rd party plug-ins are integrated with the solution to accomplish certain tasks inorder to meet the business requirement.



This system keeps track of the orders that comes in to the company from its clients and manages the order processing steps. It includes the processes starting from order import, vendor assignment, order documents received from vendors, examining the order documents and approval/disapproval of orders, send final order documents to data entry staffs, send final order pdfs to clients after completion by data entry staff.



The system is accessed by 4 different type of users such as: Admin, Manager, QA and Data Entry staff.



i)User Management Module: The system has a section where the Admin can manage the user privileges.



ii)Vendor Management Module: The system has a vendor management section where the inhouse/external vendors along with their fees and turn-around time for different states and counties are stored. The administrator can set the default vendor for a state or county or state & county.



iii)Order Management Module: The order management system is divided into 6 segments.



Import Order Process: The system provides functionality to allow the managers to import the list of orders from an excel sheet received from their clients into the order management solution.



Vendor Assignment Process: Once the orders are imported to the system the manager can assign the orders to their inhouse staffs to work on those orders or can also send out the orders to external vendors or contractors to fulfill the orders for their clients. The vendor assignment process allows the managers to see the vendor fees and turn-time available for a state/county and select a vendor to assign him to a group of selected orders at a time. The manager can assign the orders to the default vendors of their state/county. It provides the flexibility of re-assigning inhouse orders to the external vendors if they are not fulfilled by inhouse staffs. The system has automated email send functionality built-in to send email alerts to the vendors as soon as they are assigned to new orders.



Document Receiving Process: The vendors work on the orders and email the order related documents back to the manager. As automated server side script has been developed in this system which runs at a certain frequency reads the emails received from the vendors from a specified mailbox and downloads the attachments to the FileMaker application and attach them to the appropriate orders. The documents received from vendors are physically stored in a server path using 360 SuperContainer plug-in and a reference to those documents are maintained in the FileMaker application. The user can also manually upload documents to the FileMaker application and attach them to an order.



Examine Process: In this section it allows the quality analyst to open and view the vendor documents (PDF) in a viewer window inside FileMaker application. The QA person can download the PDF from FileMaker application to local filesystem,  highlight the pdf and upload the updated pdf as a new version to the FileMaker application for the order. The system allows QA to approve an order and send the order with finalized documents to data entry staffs or reject an order and send an email to vendor asking him for new documents.



Data Entry Process: In this process system allows the data entry staff to open and view the PDF finalized by QA in a viewer panel inside the application and fill up different types of order forms.



Client Delivery Process: Once the data entry job is finished the system allows the manager to print all the order forms in a single PDF and email the PDF with order forms and all the vendor documents to the clients directly from the application. The system provides a window to the manager to compose the email for the client.



Admin Settings: There is a section in the application where the admin can configure the SMTP server for outgoing emails, configure the mailbox from where the incoming vendor emails can be read. The admin can design email templates for all the types of emails that are send out from the application. In this section all the external tools settings are also done.


Magazine Subscribers

Client:
Publishing
Industry:
Publishing
Technologies:
FileMaker Pro 10 Advanced

This software is used by a publishing company that publishes and distributes magazines. This software is used to subscribe customers to the magazines and distributes number of copies of the magazines to them. It is used to manage the existing and new customers and their subscription details. It keeps track of the orders placed by the customers for new subscription or renewal of magazines and the payments done by the customers. The software also keeps track of yearly subscriptions and subscription offers that are valid for a time period. It has export records functionality implemented in the system to allow users to export sub set of records from database to an excel format file by using several filters. Mindfire has developed a "User Management" module in the system that offers an admin ability to manage (add/edit/delete) user accounts with their privileges in the system. Mindfire has developed a "Mail Merge" module in the system that offers the ability to the users of this system to compose several letter and form templates with dynamic tag insertion to the letter content. The users can choose a letter template and take printouts of the same letter for multiple customers or subscribers at a time. In the letter printouts the dynamic tags used in the letters are replaced with the actual values with context of each customers to whom the letter will be sent to. Advanced search options are provided in the system to filter the dynamic list of subscribers based on different search criteria. Mindfire has developed a web solution of the database using FileMaker IWP that allows the subscribers to access their own subscription data online.


FileMaker Pro 11 Database Tool

Client:
Neurogenetics Laboratory
Industry:
Healthcare
Technologies:
FileMaker Pro Advanced 10/11, FileMaker Server 11, Platforms: MAC OS X and Windows

This is a database tool developed to be used by a Neurogenetics Laboratory to maintain their patient records. Previously the client was using excel spreadsheets to maintain the patient data which was difficult to manage and keep track of all the patient history records. Mindfire developed a database solution using FileMaker Pro 11 Advanced for the client which provided them a multi user accessibility with all the functionalities that they were able to do in excel.

This system has been developed using FileMaker Pro 11 Advanced which runs on both Mac OSX and the Windows platforms. It is a multi-user system with a UI designed much similar to a spreadsheet. It has the feature built in to allow users to import data from an excel file to the FileMaker application along with the rows and columns background and foreground formatting. It allows the user to insert a new row at any position of the list, edit the row data directly on the same list view and user can delete a row from any positions without affecting the other existing rows. All these above functionality works similar to excel. The user has the ability to re-arrange the row orders by moving a row directly above/below any specified row without affecting the order of existing rows. It provides the functionality to change the background color of row(s) and column(s) by choosing a color from a color picker. The user can also set conditional formatting on the columns to automatically change the background color and font style of the cell based on a user defined criteria. The system also has the ability to generate barcode for the rows based on the user customized formula set for the rows. It also allows users to export selected rows data from the FileMaker application to excel format file.

360 Works ScriptMaster plug-in has been integrated with FileMaker application to provide the ability to choose colors from a java driven color picker tool and generate the barcode.


Bakery Distribution

Client:
Software Solutions Provider
Industry:
Small and Medium Industries
Technologies:
Filemaker Pro Advanced 11

The application is a fully integrated multi-user database. It helps to automate a Bakery business processes.

We created an unique worksheet for each day of the week for each customer account and automated the process. There are Standard customers whose orders are generally the same for each day of the week; any variation in their order for a given day is called or faxed to the Client. Otherwise, there's a set order for the Standard customer. About 75% of Client's customers are Special Order customers. Orders from each individual Special Order customer and changes from Standard customers are entered into the application as they come in, by an employee who goes into the application, pulls up that customer's individual worksheet for that particular day and enters the order. The application then generates and prints out a group of reports' in a date range format that literally are: The orders that will be placed with each one of Client's suppliers, a report for each of the nine route drivers telling them exactly what products they'll be picking up from each supplier that day and invoices for each driver that will be delivered to each customer with their order.

The application is able to generate any report that Client's management needs. The System currently provides them with a Weekly Vendor Report that tells what they are going to be billed by there vendors – before they bill them. They also generate a Collection Totals Report that tells them how much is due in receivables by customer, by delivery route, by any date range or any other way they want to sort the data. Each driver is given a Daily Collection Sheet Report that tells the driver what amount is due from any given customer owes in addition to the invoice due for that day; some customers are delivered to on a COD basis. The Daily Sales Report/Profit Margin Report gives them a look at the percentages by any date range they choose, by customer or by route. They get a Bagel report to tell them how many Bagels are needed on any day. They get a Production Report to be sent to the Vendor for productions of the products as per the ship-date entered.


Crate Management Software

Client:
Software Service Provider
Industry:
Crates
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11

This application manages crate design, quote, production and delivery. We have worked on some of the sections to enhance the functionalities, such as common graphics storage and comment repository, data import/export, reports, presentation, multi-lingual feature and help menu.


ERP - A FileMaker Solution

Client:
Retailer
Industry:
Retail
Technologies:
FileMaker Pro Advanced 9/10/11, FileMaker Server 11

This is a database system developed using FileMaker technology which runs on both Mac OSX and the Windows platforms. This software consists of several different modules. It has a Customer Relationship Management module, products and inventory management, sales order management, job tracking and task management module, invoicing and payment modules. It also has a system preferences section where admin user can manage the different settings for the application. The system also provides multi lingual feature, the user can choose their language preference (English/French) in the system. The system has seedcode calendar (daily, weekly and monthly) views implemented in it to add/edit/view appointment schedules. The calendar module also has the ability to create recurring events. The system also has the serverside script ability to integrate the FileMaker application data with PHP iCal website. It also has a server side script ability to import and export the invoice and payment data to an external Accounting module. The system has the diffrente kinds reporting functionality built in with the ability to print and export report data to external file format.


Report Optimization

Client:
Software Service Provider
Industry:
Advisory Services
Technologies:
FileMaker Pro Advanced 10/11, FileMaker Server 11

This is an existing database solution developed in FileMaker Pro 11 Advanced on which Mindfire's FileMaker team worked on optimizing different types of reports used in the database. The system has the ability to run several kinds of reports on the data present in the database. Mainly the data shown in the reports are summary results grouped by different fields. Which was taking a very long time to load the entire report screen resulting a severe performance issue. Mindfire has optimized all the reports effectively to speed up the performance up to 96% to 98%. We have also enhanced the reporting tool in the system to allow users to generate yearly summarized reports for different modules.

  We have also done a database migration job for the same client. We have merged a multi-file FileMaker database system to a single database system in FileMaker Pro 11 Advanced with following proper FileMaker coding conventions and Anchor Buoy system for the relationship graph.


FileMakerGo Project Management System

Client:
Software Service Provider
Industry:
Small/Medium Industries
Technologies:
FMGO, FileMaker Pro 11 Advanced

Designed a product to run in FileMakerGo in iPhone for client's existing product in FileMakerPro. We have designed all GUI and rebuild all functionalities to work well in iPhone. Now the solutions font looks good in iPhone and screen fits to iPhone. Here the products presentation style is different than its previous FileMakerPro application but functionalities are same in FMGo iPhone application.


Event Management

Client:
Software Service Provider
Industry:
Small/Medium Industries
Technologies:
FileMaker Pro 11 Advanced

Implemented repeat events functionality in the existing system by daily/weekly/monthly/yearly. It will duplicate the event and create repeat events based on the daily/weekly/monthly/yearly.

In daily repetition user has to give the no. of days interval and stop on date or stop after some repeat repetition.

In weekly repetition user has to choose weekdays and interval of week with stop on date or stop after some repetition.

In monthly repetition user has to choose month names and interval with stop on date or stop after some repetition.

In yearly repetition user has to choose the month names and interval between years with stop on date or stop after some repetition.


Task Management System

Client:
Software Service Provider
Industry:
Small/Medium Industries
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server11

Integrated SeedCodeCalendar to Client's existing system to show the tasks in calendar grid by its task date. Modified all table occurrences of SeedCodeCalendar's Event table to Client's Task table. Modified the filter options in calendar grid. Modified all Contact, Projects detail in Calendar to show related contact and projects for that task. Implemented Zulu Calender in this application so that we can manipulate FileMaker calendar records from iCal.


FileMaker App for Garment Business

Client:
Garment Showrooms
Industry:
Garment
Technologies:
FileMaker 11 Pro Advanced, FileMaker Server 11

This is a single file database solution developed in FileMaker 11 Pro Advanced. The system is used to keep track of the items in the inventory for several different garment stores or showrooms. The system manages different showrooms, the items or garments available for several different brands at the showrooms, the showroom items that are lend out by the clients, when the items are returned to the showrooms, creating invoices for the clients, etc.

The system allows the user to manage the relationship between Client, Showroom, Brands and Items. It provides the user to add/edit/delete the lendouts to the clients, add the delivery cost for the lendout items and also update the showroom inventory when the items are returned to the showroom. In this system the user can add expenses to the clients for different brand and currency. The system also allows to create new invoice to the client for all the unprocessed delivery costs and expenses added to the client. The system has the ability to keep track of different types of clients such as a client can be media, contact person, freelance, vip and incrowd. The client's lendout and invoice history are also recorded in the system which can be viewed later. The system has the admin ability to manage all the value lists used in the system, countries, types of currencies and their exchange rate, showrooms, items under brands, printing the labels, manage users of the system, etc.

The system has a built in admin ability to create/edit the e-mail templates to be send as reminder e-mails to the overdue lendouts on the showrooms.

There is a module developed in the system which give the user ability to do Media Analysis. In this section the user can register the press clippings that they get from the different magazines or on the web. The clips can be any type of image format files, pdf or small .mov files. While importing the clips to the database the system also pulls the information regarding the media from the media base.


Patient Relationship Management (PRM) with Psychologist

Client:
Healthcare
Industry:
Healthcare
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server11

This system is developed to be used as a Patient Relationship Management (PRM) dealing with a psychology call-center that works exclusively with a military population. Using PRM software applications, psychologist can move beyond treating episodes of illness to enabling proactive care by establishing productive, long-term relationships with patients. Psychologist will fill all patient general info with reason for calling with symptoms. Then Psychologist will study the case, to find what are the diagnosis and problematic for the phenomenon and starts treatment for that patient and patient can call the Psychologist no. of times, here psychologist will find the unique patient based on the unique phone no. Psychologist and his chief can view patient reports by weekly/monthly/random date selection, then the system will show reports in chart formats, so it will be easy for Psychologist or his Chief to find no. of Patients for different reaction, priority, diagnosis, problematic, phone call made by one patient for how many times etc.


Gynecology, Infertility EMR

Client:
Healthcare Service
Industry:
Healthcare
Technologies:
Filemaker 11, MySQL, PHP

The application mainly caters the need of a gynecology practice helping patients deal with infertility and other gynecology related problems. It creates and coordinates ART (Assisted Reproductive Techniques) treatment calendars, prescriptions for patients with infertility complications. The system monitors the day-by-day progress of the patients undergoing reproductive treatment using cycle sheets and digital progress notes. Doctors constantly monitor the proceedings throughout the embryo retrieval to embryo transfer process. The system offers flexibility is maintaining and managing office and patient documents of a gynecology practice. Additional features include managing and maintaining the laboratory operations, online registration of patients and their treatment details to SART (US Govt. central database) etc. An iPhone and iPad version of the application has been developed to help doctors monitor their practice operations while outside office.


Event Management Database

Client:
Software Service Provider
Industry:
Event Management
Technologies:
FileMaker 11 Pro Advanced, FileMaker Server 11

This is an Event Management database application developed for a small event organizer company ruled by a famous French magician. The database application is developed in FileMaker Pro 11 Adv.

The system is used to manage events before the contract is signed until invoices are recovered and real margin is measured. 

The system keeps track of all the events along with their estimated budget details and the real costs of the event and the margin. It also keeps track of the artist; technicians and suppliers associated with the event and also track their rate, budgeted cost and actual cost. The system also manages the detail information of all the contacts and suppliers and also tracks all the actions and activities such as e-mails, fax, telephone calls, etc. done with the event personnel. All the documents related to events, contacts, and companies or attached to any actions are tracked in the database and ties to respective records. 

The system provides a user dashboard ability to get an overview of the events and the upcoming actions to be done by the user.


Point Of Sale Software

Client:
Serial Entrepreneur
Industry:

Technologies:
FileMaker Pro 10 Advanced, FileMaker Server 10 Advanced, Platforms: MAC OS X and Windows

This system is developed to be used as a point of sale software in the beauty parlors by their customers, professional, store supervisors and the store owners. This system is developed using FileMaker Pro 10 Advanced providing client server architecture. The system is developed to be opened in Kiosk mode with touch screen interface. The application is both MAC OS X and the Windows compatible. 

The system provides high security to the data accessing depending on the access privilege of the users of this system. It is accessed by 5 different user roles such as: customers, professionals, store managers, store supervisors, store owners and administrator. It provides a highly secured login interface for the user to restrict user to log in to their store only and access the functionalities based on their privileges. The admin has the ability to add new owners with their detail information and register new stores for the owners in the database. Each store is assigned to a supervisor and the owner can add new staffs and managers to his stores. As the application is used by several different stores, it has the ability to auto login to the current store when the application is opened in a store. When the customers come in to the store they can sign in themselves by punching in their name and phone numbers and add themselves to the store queue. The store professional will then serve the customers in the queue one by one. The system has the ability to keep track of all the steps starting from customers sign in process, services given to them and payment process. The store staffs can punch their timecards in and out using this system. The system has a payroll system where store owner can define the payroll structure of their staffs and generate the payroll of a staff based on the total work hours tracked by the system. The system provides and interfaces to the admin, owners and supervisors to view their live store cameras and their customer queues from outside the store via web. The system provides daily, weekly and monthly calendar views to the manager so that they can view their store's staff schedules and add new schedules on a day. The staffs can also view their own schedules on calendar views. It has a web component for the web visitors where they can find the stores by location and view the store schedules on calendars. The system provides an inventory management module where the supervisor and manager of a store can keep track of the stocks in their store inventory and manage the stocks. If necessary the managers can notify the store owner if there is any item to be ordered by the owners. The system allows the owners to place purchase orders for their stores using this system and do the payment for the orders via PayPal. The system dynamically deducts the available stocks from the inventory as soon as an item is used in a customer's service. The system also provides a panel where the store owner and admin can add/edit/delete services in a store and adds special offers for the stores. The admin has an option to compose the templates for payment received emails, coupon reminder emails, and many other emails that are sent out from the system.


Work Order Management Database

Client:
Product & Services
Industry:
Electrical
Technologies:
FileMaker Pro 11 Advanced, FileMaker Go

This is a Work Order Management database application developed for a company to manage their work orders for different customers. The database application is developed in FileMaker Pro 11 Adv and FileMaker Go for iPad. The system is used to keep track of work orders generated for the customers. Client Company provides different items to the customers and engaged one or more technicians with helper/associate technicians for any work orders. The system also has modules to manage the item and technician databases. The application provides an user friendly interface to add different items with quantity and prices, involving technician(s) with helper(s) for generating any work order. The application also keeps track of respective pricing details of each work order and wages calculation of technicians and helpers effectively. Digital signature capture ability is introduced in the application by which customers can able to capture their digital signature for each work order through iPad or through MAC system. The system also provides dynamic work order search option based on any customer with both detail view and list view. The application has print option to print any well designed work order report and also send the same report as PDF version to any technicians.


Camp Management System

Client:
Camp organizers
Industry:
Event Management
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11

This is a FileMaker solution developed for the client to help them organizing and managing the Camps for their clients. Data separation model has been implemented in this application which adds easy maintainability to solution and also increases the security of the application. The application runs on a client-server architecture with multi-user access and user access restriction ability. The application has simple light weight and user friendly UI layout designed within it. The application provides interfaces to track and manage the clients and their in database, manage camps for the clients, manage the camp dates, process and program the camps, assign resources to the camps. There are interfaces designed to manage the resource 'To-do' list and manage the camp cost and billing. The client and camp history are tracked in the FileMaker application for any reference. The application has an admin console implemented where the admin user can manage the Staffs and control their access to the system by assigning them certain privileges/roles. The admin can able to add as many user roles as they want and define the areas and functionalities that are to be accessible by a user role dynamically. When the user logs in to the system the navigation menus, modules and functionalities are restricted as per the user's role/privilege defined by admin. The application provides letter and email campaigning ability, which allows the users to send campaigns/bulk emails to their clients periodically from one place in the system. The admin console provides the ability to compose the email and letter/envelop templates with the option to add merge dynamic tags which can be send out by staffs in the front end to multiple clients. The staff can use any predefined template and edit it at the runtime, add recipient list and send the campaign.


FileMaker - CRM/ERP System

Client:
Solar systems design and installers
Industry:
Solar Technologies
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11

This is a CRM/ERP system developed in FileMaker 11 to be used by a company that installs solar equipment at their client locations. This system has been developed to increase the efficiency and reduce costs in what is rapidly becoming a dynamic, volatile and exciting market. The system has following modules built into it. Such as: Lead Management, Quoting, Residential Account Management, Jobs, Lead Origins, Sales Dashboard, Scheduling Dashboard, Email Template etc.

Lead Management: This section is used to organize leads into categories, assign them to consultants and log contact history, appointment schedules, related quotes and jobs accounts.

Quotes:  This section keeps track of the lead quotes and converts them into Jobs and Accounts.

Account Management:  Here the company records the residential client details, link the account to multiple jobs to Accounts and log contact history.

Jobs:  All the quotes converted to job are tracked in this section. The jobs can any one of the following 4 types such as: Solar PV Installs, Solar PV Upgrades, and Solar Hot Water Systems.

Account Origin: Manage basic lead source information and assign leads and accounts to these records. Also manage referrals.

Sales Dashboard:  Here the overview of leads and sales related to sales representative/consultants are displayed. This is used as a user dashboard in the system.

Scheduling Dashboard:  This is a section which provides an easy portal for Schedulers to manage the installs jobs.

User Management: This place is accessed by admin only where the admin can add/edit the system users.

Administration: This is specifically accessed by the admin user where s/he can manage the product details, rebate and discount available geographic location wise, managing email templates for all types of outgoing emails from the system and also can do the other global settings applicable to the system.


Vehicle maintenance and overhaul contracts tracking system

Client:
Software Service Provider
Industry:
Automobile
Technologies:
FileMaker, PHP 5, jQuery Mobile framework

This PHP based web application is a front-end design of existing Filemaker Application with the purpose of improving speed, more user friendly, Add some extra features like PDF/excel export , upload images/video files to amazon server etc.

The Application starts with a login page where users authenticated through the FileMaker user Account details. After the successful login the user navigated to the dashboard page. The user can able to see all the records associated to that particular account. There is a search form using which some specific records can be found. Also user can search with multiple data by selecting more than one value from the dropdown list. An image search feature search all images associated with the input title. After search if the user wants to export the data then he/she can export all the search data to either PDF or excel format.

There is an Add Tag icon which takes the user (Inspectors) to create a new work order page. In the new work order page all the information of Car Defects are specified with the Contract name to whom the repair work is assigned. The users also can upload some images as well as videos to describe the defect more specifically. Upon submitting the work order a new Work order created in the FileMaker database, all the image/video files uploaded to the Amazon web server and emails are sent to the Admin as well as Contract email account.The contractor can find the details URL of the newly created work order through the email.

An Edit Work order page is there if the user (inspector) wants to change some data or need to upload images/video file later. Same way the Contractor can change the status, repair date etc. of the Car Defect details. Only after adding a work order the contractor can accept or reject it. All the users associated to that Contract can find the changed status of work order though the email. Also the contractor can check the images and can play the video files added for that particular Work Order.

Mobile Version:
A mobile version (for iPhone, iPad, Android Mobiles) of the above application created for the users with login and Add work order functionality using jQuery Mobile.


CRM database solution migration to Filemaker Pro 10

Client:
Software Service Provider
Industry:
SMB
Technologies:
FileMaker 10 Pro Advanced, FileMaker Server 10, Platforms: Windows, MAC OS X

The project is a multi-file CRM solution developed in FileMaker 6 and we have migrated the complete solution to FileMaker Pro 10 with fixing all the conversion issues in the new upgraded solution. We have consolidated the navigation menus present in all the different files layouts to a common hierarchical navigation menu bar window to appear always on the left side. We have also worked on restricting the Navigation menu items based on the logged-in user's role/privilege. Customized the headers of all the layouts to show all the title information and the action buttons. In this solution we have integrated the Active Directory login authentication in the whole application.


FileMaker - Octink and Rep

Client:
Software Service provider
Industry:
Oil and Gas Industry
Technologies:
FileMaker 11

This is an existing database solution developed in FileMaker Pro 11 Advanced on which Mindfire's FileMaker team worked on optimizing different types of reports used in the database. The system has the ability to run several kinds of reports on the data present in the database. Mainly the data shown in the reports are summary results grouped by different fields. This was taking a very long time to load the entire report screen, as a result severe performance issue has occurred. Mindfire has optimized all the reports effectively to speed up the performance up to 96% to 98%. We have also enhanced the reporting tool in the system to allow users to generate yearly summarized reports for different modules.

We have also worked on providing a feature to set user preference, ability to add new company and add it to several groups. Designed a place to see the company report status overview at a glance and provided a new area in the system to maintain the to-do checklist. We have designed several custom reports based on the template given by the client.


FileMaker - AIMS Eco System & AIMS Default System

Client:
Software Service Provider
Industry:
Software ISV
Technologies:
FileMaker 11

This is a small CRM project developed in FileMaker. We have worked on few areas to design find screens, list views, navigation etc. functionality in the application. We have also developed a Task Management' system in FileMaker for client's internal use for his projects.


Job Tracking System

Client:
Software Service Provider
Industry:
Software ISV
Technologies:
FileMaker 11 Pro Advanced, FileMaker Server 11, Platforms: Windows and MAC OS X

This is a database system developed in FileMaker 11, which is used by a company to track their contracts and the detail information on all the contracts. The system keeps track of the contracts as new job by auto assigning a job number to it. It also tracks of the 3rd party contractor's information on the jobs. The user can add change orders to a job with the amount to be added or deducted from the total contract amount. The system provides ability to create invoice(s) for a job and also allows user to manage balance sheet against each job by tracking the total invoices generated for a job and total amount receivable from customer's payment till date. The user can also view/print the total change orders made on a job. Similarly user can also view/print all the invoices created for a particular job and also can print the balance sheet for the job. The system provides several reporting abilities based on different search criteria on jobs, change orders, invoices and account receivables.
 
The system has an address Book section where all the contractors and other client's records are maintained. The system has a user management module where the administrator can manage all the users of this system.


FileMaker CRM

Client:
Printing Service
Industry:
Publishing
Technologies:
FileMaker 11 Pro Advanced, FileMaker Server 11, Platforms: Windows and MAC OS X

This is a system that is used by a company dealing with printing industries. The system keeps track of all the printers/vendors that the company deals with along with the printer address. The system allows the user to create new quotes or orders for their customers order and add the job specification for the customer's order from a set of pre available specs templates managed in a separate area in this application. After importing the spec template to a job user then modifies the spec details according to the job requirement. We have worked on a set of features like allowing the user to create and send quote request to the vendors that are appropriate for this order. After receiving the vendor bids the user can create customer bids and send them for customer's pricing approval. Once a vendor's pricing is approved by customer, the system will create/send a purchase order to the winning vendor. All the different forms and print screens have been developed for all the above described work flow.


Furniture iPad application

Client:
iOS developments
Industry:
Service
Technologies:
FileMaker Pro 12 Adv. and FileMaker Go 12 for iPad

This is a prototype developed in FileMaker 12 for a demo purpose which is being used by iPad users using FileMaker Go 12. This application is designed completely for iPads, it has iOS style look and feel. The application has a gallery screen which shows the dynamic list view of thumbnails of the product images 6 thumbnails per row. The number of rows in this gallery grows as the number of product images added to the database. It has the ability to sort the gallery view by a selected category. Tapping on a thumbnail will show a full view of the image and tapping again on the full view image will show the detail view of the product. In product detail view it shows a medium size image of the product, product detail information and the product pricing in a spreadsheet like view. In the product full view and detail info view screens it has several icons in a customer designed menu bar. It has a List View' menu icon that pulls down a quick view product list with thumbnails, the menu provides ability to search a product in the list by typing on a search box. It searches the list as soon as the user types in. The menu lists are shown using FileMaker portal with zero scrollbar. The user can finger tap on the list and move the finger up/down to scroll through the list. The system is developed for multiuser environment. The application layouts are designed such that it gives a look and feel of iOS application with taking the application performance into account. The layouts are designed to fit properly into the horizontal and vertical orientations of iPad.


FileMaker Go App for Food Joints

Client:
Software service provider
Industry:
Food Manufacturer
Technologies:
FileMaker Pro 12 and FileMaker Go 12

This is an application developed in FileMaker 12 to run on both desktops and iPads. It maintains the quality control stages of food supplied by different suppliers from different location all over the world. It also maintains the incoming and outgoing of various material in the industry and the financial status of the company.

The application is distributed on various modules such as:- product, inventory, customers, suppliers, staffs, purchase order from suppliers and customers order management system, payment tracking system, plantation quality control, container quality control, quality control of batches of bins, bags and boxes.

It allows users to record the freeze temperature, humidity, CO2 during the period of bins and boxes entry and exit. The application has two dashboards implemented for financials and quality control overview. The application is capable of generating and printing barcodes at each stages which helps in tracking the product produced and also it has the ability to read the scanned barcodes into the database application.


Event Management, Reservation and Selling system

Industry:
Event Organizer
Technologies:
FileMaker Pro 12

This application is developed in FileMaker Pro 12 for a company to fine tune the event dates reservation and selling process. It allows user to create and maintain events, event dates at different venues, it's budget, options ordered by the customer, total seats in an event date, seats reserved for customers, seats available, total turnover of the event on that event date and in a event including all dates.

The system keeps track of the companies/customers of the client in a small Contact Management module. It also tags the customers with the events that they have attended. The system tracks the sales done for the event dates and auto calculates the total turnover from the sales. The system provides easy graphic views to give the user a quick view of event sales summary. This has been developed using the charting feature provided by FileMaker 12.

We have given options to view the report chart in different ways e.g bar chart, line chart, pie chart, etc. There is a Dashboard implemented in the system that allows the user to view the summary of upcoming event dates and their sales and seat reservation status. The system has a built in portal that allows the sales representatives to add their activities into a diary for each event and contacts. All the activities or actions done with the contacts are tracked in the system.

The system also provides an easy and efficient way to filter/find the actions/activities that are logged for a customer in an event.The system provides easy navigation links to navigate back and forth between different sections, easy and efficient find and reporting ability.


Document Management System

Client:
Software Service Provider
Industry:

Technologies:
FileMaker Pro 12, Instant Web Publishing, 360works SuperContainer plug-in and 360works Email plug-in

This is a FileMaker 12 database system which is developed to be used as document management system. This application works in a multiuser environment and is accessed by both FileMaker Pro and IWP clients. The application provides features to upload new documents or any files into the FileMaker 12 database.

Any files uploaded here are stored at a remote server location using 360works SuperContainer plug-in. Records are created in the database for each file uploaded to the server. The user can change, view, download, delete the uploaded document by clicking on the button scripts provided in the application.

There is a Mailbox feature implemented in the application where the user can Send/Receive email messages along with email attachments from a user specified Email Account. It will download the email messages and attachments to the FileMaker database and upload the attachments to the remote server path using Supercontainer plug-in. This process can be done Manually by clicking on a button, and also this process is scheduled at the FileMaker Server Event Scheduler to automate the email message download process by triggering the event in a regular interval in the back end. The user can Compose and Send Bulk Emails with HTML body and multiple attachments from the FileMaker application.

The user can send attachments by selecting from the documents uploaded to the database. There is an Admin Interface provided in the application where the user can manage the plug-in license info, email server settings for outgoing and incoming emails. The user can also test and check the email server connections by clicking the buttons.


Medical diagnosis tracking System

Client:
USA
Industry:
Healthcare
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11 Advanced, IWP

It is a database solution which has been developed using FileMaker Pro 11 Adv. This solution can be accessible from MAC/PC desktop and laptop and also it has a web component accessible from web browsers over internet which is developed using FileMaker IWP. The application can also be used offline in the desktop environment using FileMaker Pro 11 and when the user comes online they can manually click a button script to transfer their offline data to the server hosted online database.

This application is used by team of Psychologist. It's main purpose is to keep a track of the military patients those were suffering from Psychological or Physical problems and the diagnosis done on them. All the users associated with this application are divided into certain teams which are assigned to certain tasks. The teams are generally comprises of Development, Testing, Engineering, call Center etc etc. There are different types of users in this application and they are categorized based on different roles like Psychologist,Psychologist Chief and Admin. As per other applications each user can log in to his dashboard by providing his username or password. There are three types of dashboards having different functionalities.

Psychologists are the ones who creates Patients and keeps a track of his problems which are known as CASES, it generally comprises of patients information the diagnosis executed on them, it can be renewed later when some more diagnosis is done these are also maintained as logs also known as sessions with proper date and time entry, each session shows cases information. If any further diagnosis is not required then the cases are closed,so that new cases can be created, a case can also transferred from a psychologist to another one. A psychologist can also see a list of patients and cases created by him in his own dashboard.He can quick search to get the details of the cases and patients,he can be able to search by name,creation date assigned psychologist etc etc. In the dashboard he can upload patients and cases into the server,send e-mail,view reports and can download them into excel sheets.  

Psychologist chief are the leaders under a whom a group of psychologists work.The chief can transfer a case from one psychologist to another and also can close a case.They are allowed to view all psychologist's cases. But the chief cannot add a patient or a case.A psychologist chief can also see a list of patients and cases created by all psychologist in his own dashboard. He can quick search to get the details of the cases and patients,he can be able to search by name,creation date assigned psychologist etc etc. In the dashboard he can upload patients and cases into the server,send e-mail,view reports and can download them into excel sheets,view user log history, so as which user has logged in when and how much he has used the application.

Admin is responsible for the configuration of the application whether it will be opened in English or Spanish, they play an important role they can assign or de-assign users and teams as well,they can also change the role of a  user,view reports in graphical charts and can download them into excel sheets,they can also add users or delete them.They are able to view the user log history so as which user has logged in when and how much he has used the application.They also maintain the value lists which are associated in the application,they can also remove older data like patients cases as well from the application. They can also import phone call records from external spreadsheets.

This how the application is used and all it's users are restricted to perform the tasks assigned to them as far as there roles are concerned.This application can be hosted in FM 11 Server so that it can be used by many users,it can be used in local but after FM pro is hosted, and also it can be accessed by IWP mechanism.


Wholesale Mangement System for Furniture Companies

Client:
Software Service Provider
Industry:
Retail
Technologies:
Filemaker Pro 12 Adv, Filemaker Go 12, FileMaker Server 12, PHP (FM-PHP API), HTML, CSS, JAVASCRIPT.

This project is mainly constructed for ordering process and archiving ordered data. It has a CMS(Content Management System) or Data Entry Interface which is enabled through web(Custom Web Publishing).

The functionalities implemented are gallery menu, barcode scanning of products and archival, Products ordering, invoice generation, emailing, auto resize the layout to fit into the iPad screen according to the iPad's orientation. Dynamic sorting and searching. Automatic server data update and different report generation.

When a dealer comes to a furniture company then he/she visits the gallery. According to the category selected for products in the gallery, user is navigated to the products. A product may have different types of items. Each item can have Option to be assembled or to be ordered as it is.

After the different items are ordered, an order form is populated with items and its price. Then order can be processed to create an invoice .This invoice is mailed to the user with shipping and billing address. A user also have the option to search the product by barcode or from products list displayed in the search UI of iPad. There is a sync button for synchronizing server data .When the application starts syncing the latest products, items and other data from server is passed to the app.

Additional features, a user (Dealer) can have the option to rate a product which can be archived in the DB. This additional information helps the furniture company to know which Products are rated good so that they can order  frequently rated products more. Dealer can also have the option to declare a product as CustomGallery1 , CustomGallery2 or CustomGallery3. So that the products will appear in the Gallery as CustomGallery1, CustomGallery2 or CustomGallery3 products. Each Ordering from a dealer is archived in the Database  for future references.

The app's performance is handled in iPad such that the FileMaker processing bar doesn't show up when loading a portal or updating a related field or finding records on a layout. A Sync option is provided in the FM Go app to synchronize the offline app with the online app by doing a bi-directional data transfer. This has been developed in the system without using any external plug-in. Made the layouts rotate according to the iPad orientations. The application has category, sub category menu shows in a hierarchical manner, like a tree or folder structure with ability open/close the tree. Designed the layouts in such a way that it looks very professional sufficing iPad features.


SportsManagement System

Client:
Sports organization
Industry:
Sports organization
Technologies:
FileMaker Pro 12, FileMaker Go 12 (iPad), FileMaker Server 12

This is an Event Management System designed for recording game analysis for a sports organization. This application is specifically designed for iPad users. It is layout sensitive - the screen changes accordingly to the layout mode (i.e. Landscape or Portrait mode) and has different views for their respective modes.

The app has a login authentication portal which allows valid and authenticated users to log on to the app. The application shows a list of events created by different users. Users can create an event depending on their privilege/access level and select any event and view the details of the event. A user can edit only the event he created, not those created by others, thus maintaining integrity. However a user logged in as administrator can edit every event, irrespective of who added it. Users can log in to the system using the login screen.

An administrator has full access to the application. New users can be created; privileges are defined to them both for existing or new users. And can easily change the user's privilege type. The "Others" users can only create events, view events info. There is a Sync feature implemented in the application that allows the iPad users to update their event data to the server hosted database.


Event Management System for a Fashion World

Client:
Software Service Provider
Industry:
FileMaker Pro 11 Advanced, FileMaker Server 11
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11 

This is a database solution built on FileMaker Pro 12 Adv,  which is used as an Event Management system by a fashion organization that organises 2 weeks fashion show. The application has 4 basic modules:

1. Events: The Event module contains 5 basic features:

-  Critical path - This is a grid designed for the staff and manger to define and view the whole event path that manage the event tasks and other details assign to different owners. This defined the event path staring from staff assignment to event warehouse items delivery by trucks to the event venue.
-  Production Schedule - The task view for the events.
-  Security Staffing - The weekly view for the security management for the events.
-  Op's Boys Rota - A time sheet schedules for their staffs.
-  Badge Master - The badge master was a list of passes/Badges for the events. 2. Organizations: This module holds the company details.
3. Contacts: This module stores the staffs detail and their company details
4. Preferences:

All the system and user preferences can be managed in this section. The different value lists used in the system are managed here. Such as a vehicle tracking module used to track the vehicles being used by them in the events.


Application For Apartment Booking

Client:
Software Services
Industry:
Real estate
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11, PHP 5

The web application is used for checking the availability of apartment booking details. The user can search for apartment with the search criteria in the web page. Then the user can check the pricing details of individual apartments. After booking is completed, the details are sent to user through email.

In FileMaker we have designed the script to get the XML Response of booking details of all the properties (apartments) for 365 days and individual properties monthly. The application can also import data from SQL File using ODBC Connection.


Recording forms and fillings from website in Filemaker

Industry:

Technologies:
FileMaker Server 11, FileMaker Pro 11 Adv., 360Works ScriptMaster plug-in 

This is database template created in FileMaker 11 that has a manual and auto importing feature which imports the data filing form fields from a given website link at a regular interval every day. The FileMaker script reads the form rows from a given website URL and stores them in the FileMaker database as individual records. The script also further reads the content of the text file links attached with each forms in the website and parses the different fields and their respective data into the FileMaker database.

The FileMaker template provides the user ability to edit the website URL settings by entering the record limit parameter i.e at a time how many records can be fetched from the URL. The script is optimized properly so that it does the importing efficiently in a less time span. Features and functions from 360Works Scriptmaster plug-in has been used in the FileMaker template to accomplish this job.


Track monster job visitors

Client:
Software Service Provider
Industry:
IT
Technologies:
FileMaker Server 12, FileMaker Pro 12 Adv, PHP, FileMaker API

The client creates and stores job in FileMaker database and posts the jobs to Monster website. The client provides Job Apply URL for every job in the FM database and this url is posted to Monster website when the job is posted. This is a small project where we have created a small PHP script to track the number of times the Job apply website URL is clicked by the visitors and the visitors count will be updated in FileMaker database directly.

The FileMaker db automatically generates the Trackable URL for the job as soon as the Job Apply web address is entered by the user. The Count of visitors tracked by the trackable php url is displayed on the FileMaker Job record and is used in other analytical reports by the client.


Cookbook Software

Client:
Software Service Provider
Industry:
Restaurant Services
Technologies:
Filemaker Server 12, FileMaker Pro Adv 12

This project is to design a database for high level professional cooks and master chiefs. This is a database solution developed for keeping Chef's Recipes in a CookBook software. Cookbook address those professionals, especially restaurant owners, with specific recipes and suppliers. The database was to be provided through internet or FileMaker network for single users and it was to be exclusively distributed through FileMaker network for Restaurants. Users can access CookBook modules according to their access privilege. If User will be Admin h/she can access all the sections. Restaurant Owners can access all section except Admin Settings. Single Users and Students can access only Products and Recipe sections.

The pages were developed are dashboard, Contacts, Products,Recipes, Purchase order, Sales, Admin settings and License activation/validation section  page.


Internal Trace Mobile System

Industry:

Technologies:
Filemaker Pro 12 Advanced, FileMaker Go 12, iOS, iPad

This is a single file database solution designed for FileMaker Go and it is intended to be used in iPad .The goal of this project is to let the user enter and save the data while on the go. At the end of the day the user needs to synchronize the data with the desktop version of this solution using GoZync.

Here the user is an inspector who goes from house-to-house for inspection. The user inspects the various modules of the house such as Fire Alarm  Systems, Portable Equipment Systems, Emergency Lighting Systems and Sprinklers. The user can turn off the three modules i.e "Dry Sprinklers", "Wet Sprinklers" and "Pumps and Other". The rest of the modules are compulsory.

When the user logs-in, a list is shown with the different inspection details such as address of the building and date of inspection etc. After clicking on any inspection, the user is taken to the "Inspection Header" layout where the user can turn-off or on the three module which are not compulsory. Also after completion of the inspection of any module,the user can come back to this layout and check the check-box associated with that module which shows that the inspection is complete for that module. There is a Navigation bar on the left hand side of every layout (after selecting one inspection) which allows the user to navigate between the different modules or sub-modules. The user can click on the "Inspection Queue" from the navigation bar to go back to the list of inspections from where he/she can choose any inspection assigned to him/her.


School Admission Data Management System

Client:
Software Solutions Provider
Industry:
Education
Technologies:
FileMaker 12 Pro Advanced, FileMaker Server 12, MySQL, PHP Web Services

This is a multi-file database solution developed in FileMaker 12 Pro Advanced. The system is used by a school management who runs many schools at different locations all across the world. There is an agent database system which is used by the individual schools to manage their admission, registration, student inquiries, their families and contacts records. The agent database systems allow each school to create student records and corresponding families records in their respective database servers. And then each schools data are collaborated at a centralized FileMaker server through a nightly server side script. This centralized database is known as their central repository. Which is used by the School Management only to view the reports on each schools admissions, overall student results, etc.

The data collaboration to the central repository is processed via a MySQL database server. Which is used as a middle layer between the FileMaker Pro Agent databases and the Central Repository FileMaker Server. The FileMaker agent databases push data to MySQL database server and then another nightly script scheduled at Central Repository FileMaker Server pulls the data from MySQL to the central FM database. The data transfer between FileMaker and MySQL are done using PHP WebServices integrated in FileMaker databases.

The FileMaker 12's ExecuteSQL() function and ExecuteSQL[] script step has been used to filter the data set that needs to be transferred to the central repository database. This has made the performance of the nightly script much faster at the server.


Project Management Database

Client:
Software Solutions Provider
Industry:

Technologies:
FileMaker Pro 11/12 Advanced, FileMaker Server 11/12

It is a project management software which is an assembly of client, partner, company of the client as the compulsory information and optional information are documents(whether it is a mail,letter, memo, fax etc) related to a project,tasks associated to a project, invoices of the project,receipts of the project if any.

In this system the project is a primary module apart from that rest are secondary modules. It has Dashboard section which navigates accordingly the logged-in user, keeps a track of log-in and log out time of a user and also it provides Admin section where certain customers are provided privileges, whether they have limited access(read only), or full access to this system.

Some of the important secondary modules in this system are, Money which contains sub-modules like invoices,receipts,proposals accounting where all invoices, receipts created are stored in this system. The system also provides facility to print as well as email the above sub-modules.

Contacts Module stores all the contacts and companies, which includes all employees or staff, partners, the company or client and contact information of persons belonging to companies. There is another feature in this module that is exporting contacts and company into V-Cards. Then comes the Document module which has all the documents stored,these are actually the documents used in projects,the type may be of letter,fax,memo,mails.In this document section we can check mails,send this document as a pdf,or just save the doc as a pdf.

In this system there are some General Features in all modules like,In every module of the system there are buttons to navigate to and from to previous screen or next screen,buttons are provided to navigate first record or last record, previous record or next record,apart from that it has features like searching data instantly, creating new data,deleting data(depends on user access), it has list views,detail views in one screen but separate tabs, export to excel,printing data, generating reports(summary and without summary).


Project and Task Management System

Industry:
IT
Technologies:
FileMaker Server 13, FileMaker 13 Pro Advanced, FileMaker Go 13 (iPad), ODBC to SQL Server 2012

The Filemaker File is using SQL Server 2012 as its external Data Source which contains the tables required for this Application. The information from the SQL Server are fetched to Filemaker and used in it. Here the user is asked for his login credentials before entering to the Application.

After Logging in, the User is taken to TASK DASHBOARD which shows all the Tasks which are open within a particular Date Range. The User can change that Date Range and based on that particular Date Range the list of Tasks changes. This Application consists of Projects, which contains various Tasks. Each Task can have various Task Details & Task File. So the required relationships between Project & Task & their related tables are done.

We also have Customer & Meeting & Attendee tables. Depending on those, a Meeting can attended by a List of Attendees. A meeting can be based on a Customer/Project/Task. The User can mail a particular task or a Meeting to any e-mail id with the detailed information regarding that task/meeting. Task File can contain any files like .pdf or any image/video files which are related to that Task and are helpful for understanding of the Task. Just as task, each Meeting has various Meeting Details. We are also displayed a List of all Meetings whose Event Date lies between a particular Date Range just like the Task Dashboard. There are fields like Status & Priority which displays a list of Drop Down values from which the User selects particular value for each Project/Task/Meeting/TaskDetail.


Application For Employment

Industry:
IT
Technologies:
FileMaker Server 13, FileMaker 13 Pro Advanced, FileMaker Go 13, FileMaker Web Direct

This is a single file database solution developed in FileMaker 13 Pro Advanced. The system is used to store the information provided by each applicant in the Employment form.

The File if opened from iPad performs only limited functionalities like SUBMIT, PRINT for the applicants. The File if opened from Filemaker 13 Pro Advanced, then the added functionalities for the Admin & back end staff can be accessed. For desktop users, we can open the remote AFE database file using Web Browser using the FM Server 13 Web Direct feature.

Role Of Applicant: There will be a person present with the iPad, where each applicant can go in a queue and fill the Application form under the guidance of that person. The applicant fills the information & is bound to fill the mandatory fields like FirstName, Salary Desired, Zip Code, Signature, etc. On filling the Form, the applicant can SUBMIT his filled form, which will mail the filled form(as an attachment) to any e-mail id he wishes. The applicant can also PRINT his filled form at the end of the filling process.

Role Of User: The User when opens the Application from Web Direct can VIEW the applications, SEARCH the applications or Change the Admin Settings. Depending on the requirement the User can perform the action. The User is shown the List of all the filled applications that are present in the Database. Here the User can sort the applications on the basis of any of the fields just by clicking on its respective Column Header. The Sorting is ASC/DESC alternatively. The User can EXPORT any particular application to MS Office Access 2003 and while exporting that particular application gets LOCKED. The User can perform multiple delete action also from the List View. The Locked Applications cannot be deleted. SO to delete a LOCK application will need the application to be unlocked first & then deleted.

The applications can be viewed in DETAILED form just by clicking the DETAIL button in the List View. We have implemented the PRINT functionality in Web Direct using HTML as Print functionality is not present in Web Direct.


System for Relief and Welfare Department

Client:
Service providers in Building Fabric Shelter Systems for other Companies
Industry:
Non-profit Organization
Technologies:
FileMaker 13 Pro Advanced, FileMaker Go 13 (iPad), FileMaker Server 13

This application is built for a non-profit organization who focus on serving the poor people all over the world. This application helps them register the people, provide them with badge cards and track the relief delivered to the people in terms of breakfast, food and shelter provided.

The application database is centrally hosted at a server and the users of the application i.e the volunteers and staffs access the offline copy of the application on their iPads. On opening the application the user has to go through a login validation process. The user's access to the different features/functionlity in the application is controlled by the login/security policy defined by the Administrator of the system.

This application holds the following features in terms of different modules:

1. Badge Administration:- This is managed by the administration personnel. They can create new badge entries for the villagers/people. The system provides functionality to allow the user to take photo of the person from their iPads and save it in the FileMaker application database containers using external storage options. The user can then click a button to generate a unique barcode for the person and print a badge id card for the person with the person's details, photo and the unique barcode printed on it.
2. Breakfast, Bags, Water Distribution:- This module is accessed by the distributor staffs. While distributing the breakfast, bags or water the staff will scan the person's badge id card to validate the eligibility and then give them the breakfast. Each scan is recorded in the application for admin reporting purpose.
3. Distribution Inventory:- They keep track and manage their inventory here. The inventory is automatically deducted when the items are consumed in the distribution process.
4. Bags:- The user creates similar type of bags and puts relief items in them equally. The bags are then distributed to individual person or a family. The items used in the bags are auto deducted from the Inventory.
5. Medical Records:- This holds the medical fitness parameters for different age limits of the persons so that the volunteers can advice/treat people accordingly. It provides a form where the volunteers can record the medical fitness of the people.
6. Demographics:- This holds the people demographics showing the details about people, their house number, related family members, etc.
7. Accounts:- This is an Admin accessible area where the admin can manage the users and their access to this application.
8. Employee Payroll System (with clock in and out data)
9. Reports:- Based on the badges scanned different kinds of reports can be generated by the admin to know the number of distributions made, how many people didn't get the food on a day due to some reason, how many new badges were created, etc. Based on these reports the company aims to do better the next time.


POS system for Jewelry Retail store

Client:
Jewelry Retailer
Industry:
Retail
Technologies:
FileMaker 13 Pro Advanced, FileMaker Server 13

Designed and developed an application with a complete CRM for retail industries using Filemaker 13 version, which can run on both Windows and Macintosh platform. It maintains data with regards to the Customers, Staffs, Vendors, Items, Inventory, Purchase Orders, Vendor Invoice, Accounting of the Jewelry Companies. The system is used to keep track of the items in the inventory for several different stores. The system also manages the different stores, the items or Jewelry available for several different brands at the stores, the store items that are lent out by the customers, keeps a record when the items are returned to the stores, creates invoices for the customers, etc.

This application helps to generate the reports for each store construction project with all the details of its expenses with different cost types and incomes from the project. It also provides a good accounting management to maintain the Journals and Ledgers for different financial periods.

The application database is centrally hosted at a server and the users of the application i.e the staff access the application on their desktop. On opening the application the user has to go through a login validation process. The user's access to the different features/functionality in the application is controlled by the login / security policy defined by the Administrator of the system.

This application holds many features in terms of different modules. Such as:

1. Customer Central: This module records the customer's contact information. It also gives information about contact persons, the firm's address, realized turnover, and the customer's balance of payment.
2. Inventory: Inventory Module is used to identify all the information associated with a specific inventory part. The admin will be able to update quantities, change product names, descriptions, price, category and sub-category.
3. Project: This module calculates a project plan based on time and material. This plan takes into consideration the number of orders that have already been processed, those that have recently been submitted, the current store situation, incoming orders from customers, and the quantity of items needed for project. This module also creates daily project plans and alerts the team if there is any reason to modify the project.
4. Employee Central: This module records the employee's contact information. It also gives information about contact persons, address, salary, appraisal, employee status, leaves, absent, in-out time etc.
5. Invoice: The customer invoices module can be used to manage customer invoices (create, update, delete, list) that contains several invoices lines. It also helps to generate documents for each invoice in a format like PDF.

Vendors invoices are managed with the following modules:

1. Vendor: Contains the list of vendors, their contact information, realized turnover, and other necessary information.
2. Items: Items Module maintains the Items information, Stock Information, helps view history of inventory transactions, and enables the user to add, edit or delete new items.
3. Purchase Order: This module contains information of purchase orders, approved purchase order lines, non-approved purchase order lines, vendor invoice, etc.
4. Shipping/Payment: This module records all payments that have been made, whether they have been made in cash or by online transfer, and matches the invoices with the payments. It maintains the incoming and outgoing shipping details.
5. Reports: The application provides a lot of reporting and printing options.


Task Tracker System

Client:
Software Consultant
Industry:
Production
Technologies:
FileMaker 13 Pro Advanced, FileMaker Go 13 (iPad and iPhone), FileMaker Server 13

The project is a task management system where there are various job, process and task templates from which the real jobs, process and tasks are created for the various clients managed in the application and modified accordingly as per requirements. The managers can monitor closely the tasks and the control the workers working on them thereby having a clear picture of the time-consumed, progress and status of various tasks for a particular job. One can dynamically add photos and new attributes to jobs, process and tasks in the real time on the factory floor. Apart from this central functionality, there are other modules like 'Production Shifts', 'Client Management', 'User Roles', 'Templates' etc.

There is also an app for the iOS devices(iPhone and iPad).


Inventory Management for a Furniture Business

Client:
Software Services Provider
Industry:
Retail
Technologies:
FileMaker 12 Pro Advanced,  FileMaker 13 Pro Advanced, MAC OS X and Windows

This is a project which has implemented data separation model in it,containing two files i.e interface file and the data file. The application is developed in FileMaker 12 Pro Advanced. The project is customized on top of "FM Starting Point" template. It uses the Contacts and Products/Inventory business modules to track the antique furniture business.

The system manages different Antique Furniture items available from several different brands at the showrooms for sale and allows the user to create invoices to the customers. It is a relational database system that manages related data in Company, Contacts, Inventory, Staffs, etc. modules. The system reserves access rights for different levels of user roles, such as: Developer, Administrator, Manager, Client. It has the admin ability to manage system configuration and set ups. It provides built in ability to create/edit the e-mail templates to be send as reminder e-mails to contacts and for different type of information in both product and contact sections. It has web viewer contents and thumbnail views of products. It has an Audit Log feature developed in it to keep the track of all changes being made in the system. Import feature implemented in it to migrate old systems data into the FileMaker application.

A part of the Inventory system is developed for iPad users, that allows users to take pictures of the item as it is found in the wild and store them directly in the database Containers. This uses FileMaker 12's advanced container feature to store container data externally.


Email Moving Application

Client:
Software Services Provider
Industry:
Information Technology
Technologies:
FileMaker 12 Pro Advanced, Ruby On Rails, MAC OS X, Windows

It is a single database application which deals with moving a large quantity of emails from one email server to another email server. It has the ability to select the mailbox folders from the first email server and move those folders and the email messages inside them to the second or destination email server.

The user can add the server address and credentials for the email servers as records to the database. He can select an email server to view the list of folders that email account has. Then it can select the folder(s) they want to move and then choose the destination or second email server to where the folder(s) has to be moved. The FileMaker system calls ROR Email APIs to do the email operations.


Contacts Database

Client:
Real Estate Service Provider
Industry:
Real Estate
Technologies:
FileMaker 12 Pro Advanced

Developed a Contacts Database which helps the client to keep a track of the contact details of his own clients and as well as the contacts of internal members/agents.

Here each contact can be tagged with one or more keywords which eventually helps the client to group the contacts based on the tag values. This database is integrated with 360works Email 2 plug-in to send emails to one or multiple email ids simultaneously. This database is also integrated with MailChimp to subscribe and unsubscribe contacts to a particular MailChimp list using MailChimp API. This project also contains the customized SeedCode Calendar to  create events for the contacts.


Project Management Application

Client:
Real Estate Services Provider
Industry:
Real Estate
Technologies:
FileMaker 13 Pro Advanced, FileMaker 13 Go (iPhone and iPad), FileMaker 13 Server

In this project, the client keeps track of project details. This project uses 360works DocuBin plug-in to upload and manage documents related to each project. This project is integrated with customized SeedCode Calendar which can be used to create events based on the key dates (like property acquire date, estimated closing date, etc ). This database is related to another Contacts database from which contacts can be fetched and assigned to different property.


Home Inspection Application

Client:
Real Estate Service Providers
Industry:
Real Estate
Technologies:
FileMaker 13 Pro Advanced, FileMaker 13 Go (iPhone and iPad), FileMaker 13 Server

This project helps the client to prepare a report for each property. Here, the client maintains two kind of  report one is Simple Condition report and the other one is Advanced Condition report. In Simple Condition report, an overview of features available in the property are specified whereas in Advanced Condition report the details of each feature are specified. This project allows the client to take photos and videos of different parts of the property using iPhone and iPad devices which are stored and accessed from 360works SuperContainer server.


Flooring Management Application

Client:
Software Service Provider
Industry:
Flooring
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11, PHP, ASP .NET, 360Works ScriptMaster plug-in, Troi File/URL, Google Language Converter, PCEM Outlook Manulator, FTPit Pro, BaseElement

Flooring Management Application is a multiple file database solution developed in FileMaker 11 Pro Advanced, which can run on both Windows and Macintosh platform. It is an application to workout estimate, used by the companies, doing flooring. It maintains data with regards to the Contacts, Opportunity, Request Measure, Proposals, Labor Catalog, Product Catalog, Orders, Invoice, Purchase Order,Inventory, Vendors for Flooring Companies.

The application database is centrally hosted at a server and the users of the application i.e the staff access the application on their desktop. On opening the application the user has to go through a login validation process. The user's access to the different features/functionality in the application is controlled by the login / security policy defined by the Administrator of the system. We also have Administrator Login which is used by the company providing Software to manage the licence and different features of the Application.All application used by different Clients are managed by Client and feature Management application.This Application is hosted in Software provider Company which consists of all the information about the different Clients using this Software.

The application also makes use of third party services for Tax Calculation and Email features. Avalara and CCH Calculator services are used to calculate tax for the transactions.

This application also helps to generate the different type of reports required by the Client Side . It also provides a good accounting management to maintain the Journals and Ledgers for different financial periods.

The Client and feature management application is a different application used to store and connect the Flooring Management Application of all the clients.It is used by Software Company to know and keep track on what all functionalities were sold to a particular Client and give authorization for using that functionalities. All the licence information of Flooring Management Application are listed in this application.


Leads and Task Management

Client:
Fabric shelter system provider
Industry:
Social Welfare
Technologies:
FileMaker 13 pro Advanced, FileMaker Server 13

This project is developed using the data separation model. It has two versions i.e a local version that all the user keep in their local system and the other one is the server version hosted in the FileMaker server. This database solution is a Leads and Task Management which is mainly used by the user to keep track of the different tasks assigned to the him/her. To keep track there are various functionalites such as the alarm system, status (shows the current status) and done (hides the task after it's completed). To make the usability of the application even better there are various drag and drop functionalities are implemented which helps in quickly grouping the tasks in to different groups.

There are four types of users in this application. They are Full Access,Data Entry, Only access to Task and Admin. Admin has the full privilege to do the modifications. Full access account can view leads and assigned tasks. The user having only access to the Task can view only Tasks that are assigned to him. DataEntry user can only add new Leads.

There are few other functionalities added to make the data entry easier. Downloading the E-mails  and allowing drag and drop of E-Mail from the apple mail client are among them.

The system also provides a user dashboard ability to get an overview of the tasks and the upcoming tasks to be done by the user.


Work Allocation Management System

Client:
Bike Manufacturer
Industry:
Manufacturing (Bicycle)
Technologies:
FileMaker 13 pro Advanced,FileMaker Server 13

This project is developed using the data separation model. This database solution is used to keep track of the shifts on the different stores of the client. We have used the SeedCode Calendar in this project to show the events on each day.

There are three types of users in this application. They are Regional Manger, Store Manager and normal Employees.

The regional manager adds Plans for the stores. The Plans includes the number of shifts the store needs each day for Sales, Services and Admin. A Plan is done for a pay-period which consist of two weeks and it starts always from a Saturday. To make the event entry faster, the regional manager can add "Templates". A "Template" includes the employee shifts for one week. So when creating a Plan, the regional manager can directly select a template and it will fill-up events for that week. So at maximum two templates can be chosen for both the week of a Plan. After the Plan is ready the Regional Manager marks the Plan as "Ready to Schedule" and it becomes visible to the assigned Store Manager.

The Regional Managers have a feature to duplicate a Plan for a different Store and a different Pay-Period. This copies all the events from current Plan to a new Plan having the store and pay-period as specified.

When the Store Manager logs-in, he can see all the plans that has a status of "Ready to Schedule" and that are assigned to him. Then he can build the schedules for that Plan and assign employees to the Schedule Event based on their availability. There is also an automated script that assigns the Employees automatically on First Come First Serve basis. But the Store Manager has the option to either Turn on or off the auto-assign feature. After the Schedule is ready the store manager can finalize it. Before finalizing the schedule, the Store Manager can compare the Schedule Events with the Plan events. On the dashboard, tha store manager can also see the Schedules with status "Scheduling in Progress, "Finalized" and "Void".

When a schedule is Finalized and if the Plan of that schedule is Unlocked by the Regional, then that schedule is marked as Void.

The Store Managers have a functionality to duplicate the schedule for a different store and a pay-period. This copies all the schedule events along with all details to the new Schedule.

The Regional and Store manager has also a feature to view the schedule events for each or a set of Employees. Then can filter out the events based on assigned Employee or the staff type of that event.

For normal employees, when they log-in they are taken to a calendar screen where all the schedule events assigned to them are displayed. They have an option to print the events.


Learning Application

Client:
Software Services Provider
Industry:
Education
Technologies:
FileMaker Pro 12 Advanced , FileMaker 12 Server, FileMaker Go, JavaScript

Learning Application is a multiple file database solution developed in FileMaker 12 Pro Advanced, which can run on Windows , Macintosh platform and iPad using FileMaker Go. It is an study application which is network independent  which can be constantly adapted for the changing needs of the schools,grades,classes,as well as the individual students. It offers flexibility,which allows for use in all subjects. It allows for the creation of 100 % self-made lessons by the teachers and a theoretically unlimited number of different lessons types.

Server file is centrally hosted at a server and the local versions are installed on the different iPad. On opening the application from the local version the application searches for the server and synchronize the application with the server information. For this application we have three different user types (Admin,Teacher and students). Admin and Teacher  directly works on the server file using the local file when we have connectivity to the Server. Student works on the local version and when they comes to connectivity then it synchronize the local tables with Server tables which means we have two way synchronization functionality.

Student can use this application to study the different Questions Sets. In Study mode we categorize whether it is sure or unsure question on the basis of given answers. Which helps them to work on questions which are difficult for them. In  Exam mode we have timer as well as after exam it give statics for the right and wrong questions answers.


Ticket Management System

Client:
Software / Hardware service provider
Industry:
Service provider
Technologies:
FileMaker Pro 13 Advanced , FileMaker 13 Server and Mailit 6 plugin

The application is a network-capable ticketing database that can be used to manage the incidents. The application is comprised of six modules that are linked to one another: Incidents, Customers, Hardware, Software, Documents and Providers. The application allows for the manual creation of tickets or automated creation via email requests directly from the client.

Mailit plug-in is used to import all the emails from clients and store in FileMaker Database. Which is further used classified as a new incidents for the support management. All the incidents are assigned to the different support persons. Application  can run in both the platform Windows and Macintosh.


Real Estate MIS

Client:
Software Services Provider
Industry:
Real Estate
Technologies:
FileMaker Pro Advanced, FileMaker Server

The application, built on a data separation model concept, maintains the information of the house and/or lands sold, the legal documents, and the associated sales processes.

It contains a dynamic navigational menu on the left of the menu with the ability for the admin to change the menu order by drag-and-drop. The menu contains headers which on click expand to their sub-menus and can be navigated accordingly. A similar functionality is provided at the header section of the pages through popovers which expand on click.The header popovers also provide dynamic navigational system where the menu items to be shown in the popover can be selected by the admin. It also provides repair services on the homes that are under the Village Homes.

Work Orders are generated based on the deal or the service information selected. This is usually done by selecting the address on a search screen and technicians or contractors are assigned to perform the requested services.


Insurance Compensation Management

Client:
Software Services Provider
Industry:
Healthcare Insurance
Technologies:
FileMaker Pro Advanced, FileMaker Server

This is a healthcare service database which contains the information regarding an insurance claimant. It contains case wise claimant details, along with accident descriptions, documents, injuries and disability. It maintains transactions specifying the insurance payment with the associated calculations.We have built these interfaces along with charts and reports specifying the reserves and injuries yearly or monthly.

This system has also a dynamic functionality which loads data based on the login credentials. Users can be selected as the financial handler or the administrator and the functionality and visibility of the database depends on the accessibility of the one selected.


Project Management System

Client:
Software Services Provider
Industry:
Information Technology
Technologies:
FileMaker Pro Advanced, FileMaker Server

Designed and developed a project management system that has required features to add clients, users, projects and related tasks, work session, time-sheets. It also has a dashboard, contains summarized information, built using virtual portals and calculations fetched through sql queries make the process faster.

The project management system is integrated with the work session to manage the task schedules in users calendar. An algorithm is built to great people upon their login to maintain healthily work environment.


Real Estate Project

Client:
Software Services Provider
Industry:
Real Estate
Technologies:
FileMaker Pro Advanced 12/13, FileMaker Server 12/13

Developed an application for real estate industry which has 3 main sections i.e. expenses, income, deposits. Additional sections such as tasks, contacts, interactions(sending messages to users online , as notifications) are also present.

Expenses section deals with all the expenses incurred by the client for a particular property buyer. E.g. expense against dinner towards client, expenses incurred in order to verify the documents of property, etc.

Income section deals with all the income incurred made from the client after selling/purchasing of property on behalf of client. E.g. fixed percent of the amount of income made on selling of a property or buying the property. Then, income gets distributed among the shareholders of the company by their share percentages.

Deposits sections archives the different monetary transactions being made by Expense and Income sections, the cheques for Income incurred, invoices and receipts for different expenses etc.

In addition to these sections, there are other sections, like tasks, interactions, property locations, reconciliation, reimbursement, bank statements sections.

For internal use, tasks can be allocated from admin to subordinates or between subordinates. When 2 or more users have opened the system ,interaction can be also made in order to facilitate any important information during project work(web viewer-javascript implementation, auto-update , no refresh).

Contacts of clients as well as the employees are maintained, in order for Invoice/quote creation. The statements section accesses bank statements which are then converted to expenses or income accordingly.

Reports and charts are also created for specific filter conditions through the use of 360 chart plugins,  JavaScript web-viewer and native chart creating widget from FileMaker.

A lot of other plugins like 360 SuperContainer plugin, 360 ScriptMaster plugin and groovy code are created for various project related works. Server scheduling is present to send the backup folders as zip to another remote server and deleting the backup folder from parent server. For better search and filter, hyper list /ExecuteSQL functionality is also used. There is another server schedule present to update all the latest plugins used by the project.


Please learn more about our FileMaker expertise:
   
FileMaker development services
   FileMaker/PHP/Lasso web development
Mindfire is a FileMaker Business Alliance (FBA) partners alliance.

To discuss about our services and how we could work together, please contact us on sales@mindfiresolutions.com or call 1-248-686-1424..

News & Updates

  • January 17

    DDM IT Quiz, Inspired by Mindfire, is Spreading its Wings!

  • December 16

    Santa in a different Avatar- International vacations gifted to All Mindfireans!

Let us Connect!

Related Pages

  • Our FileMaker Expertise
  • FileMaker Web, PHP, Lasso Development
  • Our InDesign Skills
  • Our SQL Server Skills
  • FileMaker Business Alliance

Awards and Achievements

Red Herringcolor DeloitteFast50 DB ZInnov1   Nascome  DB Stpi

This site uses cookies. We respect your privacy.copyright (c) Mindfire Solutions 2007-2018. Login