FileMaker Pro 11 Database Tool

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.