1.1 Overview of the FileMaker platform
FileMaker is one of the most versatile platforms for developing customized database applications. Designed for users who want to create database solutions without in-depth programming knowledge, FileMaker offers a user-friendly environment that is still powerful enough to support complex business processes. This introduction provides an overview of the key features and components of the FileMaker platform, its uses and the benefits it offers.
Table of contents
- 1.1 Overview of the FileMaker platform
- What is FileMaker?
- gFM-Business Open Source FileMaker Basis ERP The software for a crash course
- The main components of the FileMaker platform
- Version history since FileMaker 12
- FileMaker ERP software with merchandise management, CRM and billing, flexibly customizable.
- Possible applications and use cases
- Advantages of the FileMaker platform
- Differences between FileMaker Pro, FileMaker Go and FileMaker Server
- Frequently asked questions about the FileMaker platform
What is FileMaker?
FileMaker is a relational database software that enables users to create customized database solutions tailored to their specific business needs. The platform combines a user-friendly development environment with a robust database engine. This enables both amateurs and professional developers to create applications that collect, manage and analyze data.
The software was originally developed in the 1980s and has continued to evolve ever since. Today, the FileMaker platform comprises various products, including FileMaker Pro, FileMaker Go and FileMaker Server, which work together to provide a comprehensive solution for managing business data.
gFM-Business Open Source FileMaker Basis-ERP
The software for the crash course
Download for free
The main components of the FileMaker platform
The FileMaker platform consists of several key components that together provide a complete solution for data management and development.
FileMaker Pro
FileMaker Pro is the core of the platform and serves as the main tool for creating and managing databases. It offers an intuitive user interface that makes it possible to design and manage complex database structures without extensive programming knowledge. The main functions of FileMaker Pro include
- Data modelingUsers can create tables, fields and relationships to define the structure of their databases.
- Layout designFileMaker Pro allows you to create customized layouts for data entry and display.
- ScriptingThe platform provides a powerful scripting engine that can be used to automate tasks and implement custom logic.
- ReportingUsers can create reports and charts to analyze and visualize the information stored in the database.
FileMaker Go
FileMaker Go is the platform's mobile application that allows FileMaker databases to be used on iOS devices such as iPhones and iPads. This app is ideal for employees who work on the go and need real-time access to company data. FileMaker Go offers many of the features of FileMaker Pro, optimized for mobile devices. Key features include:
- Offline useData can also be recorded offline and synchronized later as soon as a connection is available.
- Barcodes and signaturesFileMaker Go supports barcode scanning and signature capture, making it particularly useful for field service applications.
FileMaker Server
FileMaker Server is a component that is responsible for centrally managing and hosting FileMaker databases over a network or the Internet. This component is particularly important for organizations that have multiple users who need to access the same databases simultaneously. The main functions of FileMaker Server include:
- Centralized data managementFileMaker Server makes it possible to store and manage all databases in one central location, which improves data security and integrity.
- Automated backupsThe server component performs regular backups to ensure that data can be restored quickly in the event of a system failure.
- Security functionsFileMaker Server provides advanced security features, including encryption and access controls, to ensure that only authorized users have access to the data.
FileMaker Cloud
With FileMaker Cloud, the platform offers a cloud-based solution that provides similar functionality to FileMaker Server, but without the need to run your own server infrastructure. FileMaker Cloud is particularly useful for organizations that need a flexible, scalable solution that is accessible from anywhere. The benefits of FileMaker Cloud include:
- Simple provisionFileMaker Cloud can be set up quickly and does not require an extensive IT infrastructure.
- Automatic updatesSecurity updates and software improvements are installed automatically so that users are always up to date.
Claris Connect: Extension of the FileMaker platform
Claris Connect is a powerful extension of the FileMaker platform that enables users to integrate their database solutions with a variety of cloud services and APIs. As part of the Claris portfolio, Claris Connect provides a simple yet flexible way to automate workflows and seamlessly exchange data between different applications. This enables organizations to connect their FileMaker databases with external services such as Slack, Mailchimp, Salesforce, and many others to streamline processes and increase efficiency. Claris Connect supports both simple and complex automations without the need for extensive programming knowledge, making it a valuable tool for extending the functionality of FileMaker solutions.
Version history since FileMaker 12
Important features
- Improved support for machine learning and AI to integrate predictions and automation into databases
- Introduction of "Connected Apps": Ability to seamlessly integrate FileMaker solutions with other SaaS applications
- Extended cloud functions and optimization of security for enterprise applications
- Improvements to the user interface and usability to further increase the efficiency of developers
Minimum requirements
macOS:
- Operating system: macOS 12 Monterey, macOS 13 Ventura, macOS 14 (upcoming version)
- Hardware: Apple Silicon Mac (natively supported) or Intel-based Mac, at least 8 GB RAM
- Storage space: Approx. 3 GB for the installation
Windows:
- Operating system: Windows 10 Pro/Enterprise, Windows 11
- Hardware: Intel Core i5 or better, at least 8 GB RAM
- Storage space: Approx. 3 GB for the installation
iOS (FileMaker Go 2024):
- Operating system: iOS 16.0 or newer
- Devices: iPad, iPhone, iPod Touch
Important features
- Native support for Apple Silicon, which significantly improves performance on modern Macs
- Extended low-code and no-code functions for faster development without in-depth programming knowledge
- New layout options and tools for even more intuitive user interfaces
- Improved integration with cloud services and extended API support for hybrid and native apps
Minimum requirements
macOS:
- Operating system: macOS 11 Big Sur, macOS 12 Monterey, macOS 13 Ventura
- Hardware: Apple Silicon Mac (natively supported) or Intel-based Mac, at least 8 GB RAM
- Storage space: Approx. 3 GB for the installation
Windows:
- Operating system: Windows 10 Pro/Enterprise, Windows 11
- Hardware: Intel Core i5 or better, at least 8 GB RAM
- Storage space: Approx. 3 GB for the installation
iOS (FileMaker Go 2023):
- Operating system: iOS 15.0 or newer
- Devices: iPad, iPhone, iPod Touch
Important features
- Support for Apple Silicon (via Rosetta 2) and performance improvements on M1 Macs
- Improved WebDirect performance and compatibility
- Extended support for JavaScript and web viewer integration
- Introduction of new AI functions to automate repetitive tasks
Minimum requirements
macOS:
- Operating system: macOS 10.15 Catalina, macOS 11 Big Sur
- Hardware: Intel-based Mac or Apple Silicon Mac (Rosetta 2 required), at least 8 GB RAM
- Storage space: Approx. 2.5 GB for the installation
Windows:
- Operating system: Windows 10 Pro/Enterprise, Windows 11
- Hardware: Intel Core i3 or better, at least 8 GB RAM
- Storage space: Approx. 2.5 GB for the installation
iOS (FileMaker Go 20):
- Operating system: iOS 14.0 or newer
- Devices: iPad, iPhone, iPod Touch
Important features
- Introduction of add-ons and JavaScript support
- Improved performance and stability
- Extended API integration and automation functions
Minimum requirements
macOS:
- Operating system: macOS 10.14 Mojave, macOS 10.15 Catalina
- Hardware: Intel-based Mac, at least 8 GB RAM
- Storage space: Approx. 2.5 GB for the installation
Windows:
- Operating system: Windows 8.1, Windows 10 Pro/Enterprise
- Hardware: Intel Core i3 or better, at least 8 GB RAM
- Storage space: Approx. 2.5 GB for the installation
iOS (FileMaker Go 19):
- Operating system: iOS 13.2 or newer
- Devices: iPad, iPhone, iPod Touch
Important features
- Improved developer tools, including database analysis and troubleshooting
- Improved security through encryption and password management
- Enhanced FileMaker Data API for better integration
Minimum requirements
macOS:
- Operating system: macOS 10.13 High Sierra, macOS 10.14 Mojave
- Hardware: Intel-based Mac, at least 4 GB RAM
- Storage space: Approx. 2 GB for the installation
Windows:
- Operating system: Windows 7 SP1, Windows 8.1, Windows 10 Pro/Enterprise
- Hardware: Intel Core 2 Duo or better, at least 4 GB RAM
- Storage space: Approx. 2 GB for the installation
iOS (FileMaker Go 18):
- Operating system: iOS 12.0 or newer
- Devices: iPad, iPhone, iPod Touch
Important features
- Introduction of the FileMaker Admin Console
- Improved user interfaces with new layout options
- Enhanced security features and improvements to user management
Minimum requirements
macOS:
- Operating system: macOS 10.12 Sierra, macOS 10.13 High Sierra
- Hardware: Intel-based Mac, at least 4 GB RAM
- Storage space: Approx. 1.5 GB for the installation
Windows:
- Operating system: Windows 7 SP1, Windows 8.1, Windows 10 Pro/Enterprise
- Hardware: Intel Core 2 Duo or better, at least 4 GB RAM
- Storage space: Approx. 1.5 GB for the installation
iOS (FileMaker Go 17):
- Operating system: iOS 11.2 or newer
- Devices: iPad, iPhone, iPod Touch
Important features
- Support for JSON and extended cURL options
- Improved integration through REST-based FileMaker Data API
- Improvement of layout objects and anchor points
Minimum requirements
macOS:
- Operating system: macOS 10.11 El Capitan, macOS 10.12 Sierra
- Hardware: Intel-based Mac, at least 4 GB RAM
- Storage space: Approx. 1 GB for the installation
Windows:
- Operating system: Windows 7 SP1, Windows 8.1, Windows 10 Pro/Enterprise
- Hardware: Intel Pentium 4 / AMD Athlon 64 or better, at least 4 GB RAM
- Storage space: Approx. 1 GB for the installation
iOS (FileMaker Go 16):
- Operating system: iOS 10.0 or newer
- Devices: iPad, iPhone, iPod Touch
Important features
- Improved security features, including support for OAuth 2.0
- New WebDirect optimizations for mobile devices
- Performance optimizations and stability improvements
Minimum requirements
macOS:
- Operating system: OS X 10.9, 10.10, 10.11
- Hardware: Intel-based Mac, at least 4 GB RAM
- Storage space: Approx. 1 GB for the installation
Windows:
- Operating system: Windows 7 SP1, Windows 8.1, Windows 10 Pro/Enterprise
- Hardware: Intel Pentium 4 / AMD Athlon 64 or better, at least 4 GB RAM
- Storage space: Approx. 1 GB for the installation
iOS (FileMaker Go 15):
- Operating system: iOS 9.3 or newer
- Devices: iPad, iPhone, iPod Touch
Important features
- Introduction of Script Workspace for more efficient scripting
- Improved support for iOS devices
- Improved WebDirect functions
Minimum requirements
macOS:
- Operating system: OS X 10.8, 10.9, 10.10
- Hardware: Intel-based Mac, at least 4 GB RAM
- Storage space: Approx. 1 GB for the installation
Windows:
- Operating system: Windows 7 SP1, Windows 8.1, Windows 10 Pro
- Hardware: Intel Pentium 4 / AMD Athlon 64 or better, at least 4 GB RAM
- Storage space: Approx. 1 GB for the installation
iOS (FileMaker Go 14):
- Operating system: iOS 8.1 or newer
- Devices: iPad, iPhone, iPod Touch
Important features
- Introduction of WebDirect for the browser-based use of FileMaker databases
- Improved user interface with new designs
- Improved security through encryption at file level
Minimum requirements
macOS:
- Operating system: OS X 10.7, 10.8, 10.9
- Hardware: Intel-based, at least 2 GB RAM
- Storage space: Approx. 700 MB for the installation
Windows:
- Operating system: Windows 7 SP1, Windows 8, Windows 8.1
- Hardware: Pentium 4 or equivalent, at least 2 GB RAM
- Storage space: Approx. 700 MB for the installation
iOS (FileMaker Go 13):
- Operating system: iOS 6.0 or newer
- Devices: iPad, iPhone, iPod Touch
Important features
- Introduction of the new file format (.fmp12)
- Improved design and layout tools
- Performance improvements for operation on iOS devices
Minimum requirements
macOS:
- Operating system: Mac OS X 10.6.8, 10.7.x
- Hardware: Intel-based, at least 2 GB RAM
- Storage space: Approx. 300 MB for the installation
Windows:
- Operating system: Windows XP SP3, Windows Vista SP2, Windows 7 SP1
- Hardware: Pentium 4 processor (or equivalent), at least 2 GB RAM
- Storage space: Approx. 300 MB for the installation
iOS (FileMaker Go 12):
- Operating system: iOS 5.1 or newer
- Devices: iPad, iPhone, iPod Touch
FileMaker ERP software with merchandise management, CRM and billing, flexibly customizable.
More information
Possible applications and use cases
FileMaker is used in a variety of industries and application areas. Thanks to its flexibility and adaptability, the platform can be used for both simple and complex business processes.
Business process management
Many companies use FileMaker to manage and optimize their business processes. The platform can be used to manage sales processes, project management, customer relationships and much more. With FileMaker, companies can develop customized solutions that are precisely tailored to their specific requirements.
Inventory and warehouse management
Another common use of FileMaker is inventory and stock management. With FileMaker, companies can monitor their stock levels in real time, automate orders and manage inventory efficiently. The platform makes it possible to easily model and control complex warehouse management processes.
Healthcare
In the healthcare sector, FileMaker is often used to manage patient data, appointment scheduling and billing. The flexibility of the platform makes it possible to develop customized solutions that meet the strict data protection requirements of the healthcare sector.
Education and research
Educational institutions and research organizations use FileMaker to manage student data, course information and research results. The platform makes it possible to organize and analyze data efficiently, which is essential for the planning and implementation of educational and research projects.
Advantages of the FileMaker platform
FileMaker offers a variety of benefits that make it a preferred choice for companies that need customized database solutions.
User friendliness
An outstanding advantage of FileMaker is its user-friendliness. The platform is designed so that even users without programming knowledge can create complex database solutions. The intuitive user interface and graphical tools make the development process much easier and enable companies to quickly create functional applications.
Flexibility and adaptability
FileMaker offers exceptional flexibility, making it possible to develop solutions for a wide range of use cases. The platform supports a variety of functions and can be easily customized to meet the specific needs of an organization. Whether it's simple data management or complex automation tasks, FileMaker provides the tools required to achieve the desired results.
Integration and expandability
FileMaker can be seamlessly integrated into existing IT infrastructures. The platform supports connection to external data sources such as SQL databases and web services via APIs. In addition, users can develop custom plugins and extensions to extend the functionality of FileMaker and meet specific requirements.
Fast development cycles
Thanks to FileMaker's user-friendly development environment, companies can quickly create prototypes and turn them into fully functional solutions. This enables companies to react flexibly to changes in their business requirements and implement innovations more quickly.
Security functions
Data security is critical for any organization, and FileMaker offers robust security features to ensure the protection of sensitive data. The platform supports SSL encryption, user and group permissions, and database encryption. These features ensure that only authorized users have access to sensitive information.
Differences between FileMaker Pro, FileMaker Go and FileMaker Server
The FileMaker platform consists of several main components that fulfill different functions and complement each other.
FileMaker Pro
FileMaker Pro is the desktop application primarily used to develop and manage databases. It provides all the tools needed to create and customize database solutions. Users can create layouts, design database structures and use scripting to automate complex workflows.
FileMaker Go
FileMaker Go is the mobile extension of FileMaker Pro and enables access to databases via iOS devices. It offers similar functionality to FileMaker Pro, but optimized for mobile devices. FileMaker Go is ideal for employees who need to work on the go and require real-time access to company data.
FileMaker Server
FileMaker Server serves as the central component for hosting and managing FileMaker databases. It allows multiple users to access the same databases at the same time and offers advanced features such as automated backups, security controls and performance optimization.
Frequently asked questions about the FileMaker platform
- What is the FileMaker platform and what is it used for?
- The FileMaker platform is a low-code development environment that makes it possible to create customized database solutions for companies. It is used to optimize workflows, automate processes and manage data centrally, both for desktop and mobile devices and the web.
- Is FileMaker only suitable for simple applications, or can complex solutions also be implemented?
- FileMaker is suitable for both simple and complex solutions. The platform offers extensive functions for the development of database applications, including user-defined layouts, automation, scripting and the integration of external systems via APIs.
- Which operating systems does the FileMaker platform support?
- FileMaker supports both macOS and Windows. There is also an app for iOS, FileMaker Go, which was specially developed for iPhone and iPad, and FileMaker WebDirect, which provides solutions in a web browser so that the applications can be used across platforms.
- Is FileMaker a cloud-based solution or a desktop application?
- FileMaker offers both. You can use FileMaker locally on your desktop or use a fully cloud-based solution via FileMaker Cloud. FileMaker Cloud offers the advantage that you do not have to operate your own server infrastructure and can access your data from anywhere.
- Can FileMaker be integrated into other systems and platforms?
- Yes, FileMaker offers numerous integration options. External systems such as CRM, ERP and e-commerce platforms can be connected via the FileMaker API. The platform also supports common standards such as REST, OData and XML to exchange data and integrate external services.
- Do I need programming skills to use FileMaker?
- For simple applications, you do not need in-depth programming knowledge, as FileMaker is a user-friendly low-code platform. For more complex functions and automation, however, it can be an advantage to have basic knowledge of scripting and database development.
- Can I use FileMaker on mobile devices?
- Yes, with FileMaker Go you can use FileMaker solutions on iPhones and iPads. This app makes it possible to access the same databases as on the desktop, with support for mobile features such as cameras, GPS and barcode scanners.
- How secure is the FileMaker platform?
- FileMaker offers a high level of security through encrypted data transmission (SSL/TLS) and the option to encrypt databases both at rest and during transmission. You can also granularly control access rights and ensure that only authorized users can access sensitive data.
- Can I also use FileMaker in my team?
- Yes, FileMaker is ideal for team collaboration. You can share solutions with multiple users by using a FileMaker Server or FileMaker Cloud. Multiple users can access the database at the same time, make changes and collaborate in real time.
- What are the main advantages of the FileMaker platform?
- The FileMaker platform provides a flexible and customizable environment in which you can quickly develop tailored solutions without extensive programming. It enables the integration of mobile, desktop and web applications and provides an easy way to securely manage data and automate workflows.
