The Enterprise software gFM-Business is based on the FileMaker platform and requires the following for use in the Network under Mac OS X or Windows and a license for the FileMaker Pro database software for editing print layouts. In addition to the use of gFM-Business, this software can also be used for other purposes without any problems, as FileMaker Pro has a powerful range of functions for managing and editing all types of data in a structured manner.
In this three-part series of articles, we will introduce you to some of the possibilities that arise with the purchase of a FileMaker Pro license. Use FileMaker Pro as a tool for managing data or for editing and creating Excel spreadsheets. Anyone who works a lot with Excel will have a lot of fun with FileMaker Pro, because the possibilities of FileMaker go far beyond those of a spreadsheet in many areas. Below we present some starter solutions from the brand new FileMaker Pro (Advanced) 15. Most of the solutions are already available in FileMaker 14. In the second and third part of this series, we will present further starter solutions and possibilities of FileMaker Pro.
gFM-Business allows data access
If you use the gFM-Business business software, you can also easily access all data from gFM-Business with all the FileMaker starter solutions mentioned below.
Simply add an external data source to the desired data table from gFM-Business in your FileMaker Starter solution. This applies to all versions and is also available in the free Freeware merchandise management gFM-Business free possible. The use of gFM-Business in conjunction with FileMaker Pro allows unlimited flexibility to manage company data in a structured way.
FileMaker supports many data formats
To manage and edit data from external data sources in FileMaker, many different formats are available for importing data. In addition to the usual data formats text, CSV, dBase etc., Excel tables can also be imported into FileMaker with a simple mouse click. Of course, data can also be imported as ExcelTable can be exported again from FileMaker.
For data sources hosted on external servers, FileMaker supports the ODBC-ODBC is a standard that can be used to connect any data source to FileMaker. ODBC drivers are available for many different systems such as MySQL, Oracle, Microsoft SQL or IBM DB/2 are available. Data tables from such systems can easily be inserted in the relationship graph like a FileMaker data table and linked to other tables.
FileMaker direct start for beginners
In order to make the creation of databases as easy as possible for beginners, the FileMaker has already had an integrated direct start function for several versions. Once the software has been installed and started, the direct start window appears, in which a starter solution can be selected or a custom solution can be created at the touch of a button.
The direct start window can be moved downwards and contains the four apparently most frequently used starter solutions:
- Contacts
- Inventory
- Content Management
- Tasks
Click on the button [Show advanced solutions] opens another window containing many more starter solutions.
The starter solutions are ready-made databases that already have basic functions for recording and processing data. The databases are structured in such a way that they can be easily extended with your own tables, fields and functions. In the following we will take a closer look at the starter solutions integrated in FileMaker.
Fixed assets - management of fixed assets
With the starter solution integrated in FileMaker Pro Attachments fixed assets can be managed and processed. The software automatically calculates the residual value of an asset based on the date of purchase and the depreciation period.
For each system, some master data and up to six images or files can be added via drag & drop. The Database has the option of printing labels, a depreciation report and an inventory report. The list view can be filtered to borrowed items at the touch of a button.
Tasks - Simple task management
Manage any tasks and checklists with FileMaker Pro's built-in starter solution Tasks. Any number of editors with contact details and any number of attachments can be saved for each task.
Tasks can be categorized and sent by e-mail. Several print layouts and a page view are available for print output in the list view.
Expense report - manage expenses and mileage allowance
With the FileMaker Starter Solution Expenditure report can be used to manage any number of expenses and mileage allowances. The database allows you to create any number of expense reports, each of which can be assigned to an employee.
Expense reports can be sent by e-mail as a PDF file. Functions for exporting data and importing data from any external files are available in the list view.
Content management: Manage files of all kinds in FileMaker
The FileMaker Starter Solution Content Management allows you to manage any number of files in FileMaker Pro. Any number of data records can be created. Files can be added using drag & drop. After adding a file, a preview image of the file is displayed in the corresponding field.
Saved media can be exported or sent by email at the touch of a button. The software has a list view for all media as well as a thumbnail view with preview images that can be filtered according to the media types photo, image, PDF, audio, video, office and signature.
Event Management - Manage events with FileMaker
With the FileMaker Starter Solution Event Management is a somewhat more comprehensive database solution for managing events. In addition to general master data, any number of participants and guests as well as tasks and the agenda from any number of points can be saved for each event.
Status information can be stored for all entries, such as the participation status of a guest or contributors to a task. Participants can be contacted by e-mail at the touch of a button. The solution also includes a Print layout for an event report that can be saved, printed or sent by e-mail at the click of a mouse. The list view contains separate lists for events and contacts.
Manage research notes with FileMaker
Another integrated starter solution in FileMaker is the research notes. Starting from any number of projects, any number of notes, documents and media files can be managed per project, with files being saved directly in FileMaker using drag & drop.
The starter solution also includes a print layout for a research report that can be saved, printed and sent by email at the touch of a button. In the list view for all projects, functions for exporting data and importing data from any external files are available.
Inventory management as a starter solution
Inventory management is also available in FileMaker Pro as a starter solution. Inventory products can be categorized and assigned to a manufacturer. In addition to general master data such as the object name, article number, barcode, location, unit costs, etc., any number of transactions can be added per data record to display incoming and outgoing goods, after which the stock level and stock value are automatically calculated.
The software also allows you to store a reorder point and the date of the last order. An inventory report is available in the list view, which can be printed at the click of a mouse or sent by e-mail as a PDF file. There are also functions for exporting data and importing data from any external files.
Manage contacts easily with FileMaker
As a starter solution, FileMaker Pro also contains a simple contact management function that can be used to store any number of contacts. One business and one private address can be saved separately for each contact. With the function [Send by e-mail] all entered data including a map section of the address can be sent by e-mail.
The integrated list view allows any sorting and filtering of entries according to different categories. There is also a print layout for printing labels and a function for exporting data and importing data from any external files.
Further starter solutions in the second part
With FileMaker, the buyer acquires a powerful tool with which data of all kinds can be easily managed. In this article we have presented the first eight starter solutions that are supplied as standard with FileMaker Pro. In the next part of this article, we will present the following eight Starter Solutions that are supplied with FileMaker Pro:
- Cost estimates
- Meetings
- Personnel data
- Product catalog
- Projects
- Invoices
- Resource planning
- Time accounting
We hope you enjoyed the first part of this article series, and perhaps it has inspired you to take a closer look at FileMaker's starter solutions. All starter solutions are completely open database solutions that you can easily expand with additional data and functions.

Markus Schall has been developing individual databases, interfaces and business applications based on Claris FileMaker since 1994. He is a Claris partner, FMM Award winner 2011 and developer of the ERP software gFM-Business. He is also a book author and founder of the M. Schall Publishers.









