Claris FileMaker Pro is at the center of the FileMaker platform, a professional low-code platform for creating and using custom business applications.
It allows organizations to build applications adapted to their own processes without assembling a separate database, programming language, user-interface framework, and reporting system. These components are brought together inside a FileMaker custom app.
FileMaker Pro has existed for more than 40 years and is the best-known product in the Claris platform. It runs on macOS and Windows and serves two distinct purposes:
- developers use FileMaker Pro to create and maintain custom apps;
- users use the same FileMaker Pro application to work with those apps.
This combination of development environment and desktop client is one of FileMaker Pro’s defining characteristics.
What Is a FileMaker Custom App?
A FileMaker custom app is a file, or collection of files, containing the application’s database structure, interface, automation, security, and data.
A FileMaker custom app can include:
- tables, fields, and relationships;
- records and documents;
- layouts and reports;
- calculations;
- scripts and automated workflows;
- charts and dashboards;
- user accounts and privileges;
- themes and interface elements;
- integrations with external services.
A useful comparison is a Microsoft Word document. A Word file contains not only its text, but also its styles, page structure, tables, images, and formatting rules.
Similarly, a FileMaker file can contain not only business data, but also the structure and behaviour of the application used to manage that data.
What Can You Build with FileMaker Pro?
FileMaker Pro is not designed for one particular industry or business process. It provides a general platform from which many different applications can be created.
Common examples include:
- customer relationship management;
- quotations, orders, and invoicing;
- inventory and asset management;
- project and task management;
- event registration;
- production planning;
- document management;
- field-service operations;
- case and membership management;
- reporting and operational dashboards.
The principal advantage is that the application follows the organization’s terminology and workflow. Users do not have to adapt every process to the assumptions made by a generic software package.
A Relational Database
At the foundation of every FileMaker custom app is a relational database.
Information is organized into tables containing fields and records. Relationships connect related information, such as customers with their invoices or projects with their tasks.
FileMaker Pro provides graphical tools for defining this structure. A developer does not need to write SQL to create tables, fields, or relationships.
This makes relational database development accessible to people who understand the business problem but may not have a traditional computer-science background.
However, ease of access should not be confused with an absence of engineering. A reliable business application still requires careful data modelling, security, testing, documentation, and planning for future changes.
Designing the User Interface with Layouts
FileMaker interfaces are created with layouts.
A layout determines how information is displayed, entered, searched, printed, or reported. The same data can appear on several layouts designed for different users or tasks.
A customer record might be presented as:
- a detailed data-entry form;
- a compact list;
- a sales dashboard;
- a printed customer summary;
- a mobile interface;
- a report grouped by country or account manager.
Developers can position fields, buttons, portals, text, images, charts, navigation controls, and other objects visually.
Layouts make it possible to build interfaces without developing a conventional desktop application in Swift, C#, or another programming language.
Automating Work with Scripts
FileMaker Pro includes a visual scripting environment for automating tasks and implementing business logic.
A script is an ordered sequence of actions. It can find records, create documents, validate data, send emails, generate reports, call external APIs, or guide a user through a complete business process.
Scripts can be launched from buttons, menus, record events, schedules, external applications, or other scripts.
Because scripts are assembled from FileMaker script steps, developers can build substantial automation without writing a conventional programming language. More advanced developers can combine scripts with calculations, JSON, cURL, SQL, JavaScript, APIs, and plug-ins.
Calculations and Custom Functions
FileMaker Pro includes an extensive calculation engine for working with text, numbers, dates, lists, JSON, containers, and many other types of information.
Calculations are used throughout a custom app: in fields, scripts, validation rules, object visibility, conditional formatting, reports, and security.
Developers can also create custom functions to centralize reusable calculation logic. Well-designed custom functions make complex applications easier to understand and maintain.
Finding, Sorting, and Reporting Data
FileMaker Pro is both an application-development platform and a powerful tool for working with information.
Users can:
- create and edit records;
- perform simple or complex searches;
- sort information;
- work with related records;
- generate summaries;
- display charts;
- preview and print reports;
- import and export data;
- save records as PDF or Excel files.
Its search system is particularly flexible. Users can combine criteria, omit records, search ranges, use operators, and refine an existing result without needing to write a database query.
Developers can then automate these same operations in scripts.
Integrating FileMaker with Other Systems
A FileMaker custom app does not need to operate in isolation.
FileMaker Pro can communicate with external applications and services using technologies such as:
- JSON and XML;
- HTTP and cURL;
- ODBC and JDBC;
- external SQL data sources;
- JavaScript in web viewers;
- Claris Connect;
- plug-ins;
- FileMaker scripts triggered by external systems.
When the application is hosted, external services can also access its data through the FileMaker Data API or the FileMaker OData API.
This allows FileMaker to become part of a wider information system involving websites, accounting software, CRM platforms, payment services, electronic invoicing, business intelligence, or artificial intelligence.
FileMaker Pro as a Desktop Client
FileMaker Pro is also the principal desktop application for using FileMaker custom apps.
Users on macOS or Windows can open a local FileMaker file or connect to an application hosted on FileMaker Server.
The desktop client provides the most complete FileMaker experience. It supports rich interfaces, printing, exporting, container data, keyboard interaction, multiple windows, and many other desktop capabilities.
Developers use the same application to modify the database structure, create layouts, write scripts, and manage application security, provided their account has the necessary privileges.
FileMaker Pro and FileMaker Pro Advanced
FileMaker Pro Advanced was previously sold as a separate product containing additional development tools.
That distinction no longer exists. The advanced development capabilities are now included in FileMaker Pro and can be enabled through the Use advanced tools setting.
These tools include:
- the Script Debugger;
- the Data Viewer;
- custom functions;
- custom menus;
- Developer Utilities;
- Database Design Reports;
- Save a Copy as XML.
Modern references to FileMaker Pro Advanced therefore generally describe an older product version. Today, there is only FileMaker Pro.
Sharing a FileMaker App
A FileMaker file can be used locally by one person, but professional multi-user applications should be hosted on FileMaker Server.
FileMaker Server opens the databases and makes them securely available to authorized users. Everyone works with the same live data rather than exchanging separate copies of the file.
Depending on the application and licensing, users can connect through:
- FileMaker Pro on macOS and Windows;
- FileMaker Go on iPhone and iPad;
- FileMaker WebDirect in a web browser;
- integrations using OData and other FileMaker APIs.
FileMaker Pro creates and runs the custom app. FileMaker Server provides the infrastructure required to share it reliably.
FileMaker Pro and FileMaker Server
FileMaker Pro and FileMaker Server have complementary roles.
FileMaker Pro is the desktop application used to create, maintain, and operate custom apps.
FileMaker Server hosts those applications for multiple users and provides services such as backups, server-side scripts, WebDirect, APIs, authentication, and administrative tools.
A simple application may begin as a local FileMaker Pro file. Once it becomes important to a team, hosting it on FileMaker Server provides centralized data, controlled access, automated backups, and continuous availability.
Sending copies of a FileMaker file between users is not a safe substitute for hosting. It creates several independent versions of the data and makes changes difficult or impossible to reconcile.
Is FileMaker Pro No-Code or Low-Code?
FileMaker Pro is best described as a low-code platform.
A beginner can create a useful database, form, or report with little technical knowledge. Templates and add-ons can accelerate the first stages of a project.
As requirements become more complex, FileMaker provides progressively deeper capabilities: relational modelling, calculations, scripts, custom functions, APIs, SQL, JSON, JavaScript, and plug-ins.
This progressive model is one of FileMaker’s strengths. It allows an application to begin simply and evolve without immediately requiring a complete rewrite in another technology.
Professional FileMaker development nevertheless remains a specialist discipline. A business-critical application must be designed for security, performance, maintainability, multi-user access, backup, integration, and long-term evolution.
Who Uses FileMaker Pro?
FileMaker Pro is used by organizations of many sizes, from individual professionals to international companies.
Typical users include:
- internal business teams creating their own operational tools;
- professional FileMaker developers;
- IT departments;
- consultants and Claris Partners;
- non-profit and educational organizations;
- companies replacing spreadsheets or obsolete databases;
- organizations whose processes are too specific for generic software.
FileMaker is especially effective when a business process is important, evolves regularly, and cannot be represented adequately by a standard off-the-shelf application.
Artificial Intelligence in FileMaker Pro
Current versions of FileMaker Pro include features for integrating artificial intelligence into custom apps.
Developers can connect FileMaker to supported AI providers, generate embeddings, perform semantic searches, use large language models, process documents, and integrate AI-generated results into existing workflows.
The important distinction is that AI operates within the application’s existing structure and security model. It complements FileMaker’s database and automation capabilities rather than replacing them.
As with any integration, production use requires careful attention to data confidentiality, accuracy, provider selection, cost, and the validation of generated results.
Hosting FileMaker Applications with fmcloud.fm
A FileMaker custom app becomes a shared service when it is uploaded to FileMaker Server.
fmcloud.fm provides managed FileMaker hosting in data centres around the world. Our platform includes automated deployment, SSL certificates, monitoring, local and off-site backups, FileMaker Server updates, and access to the principal FileMaker gateways and administrative tools.
A free 15-day trial allows customers to upload and test their own FileMaker app in a genuine production environment without providing credit-card information.
Once hosted, users connect to the application from FileMaker Pro, FileMaker Go, WebDirect, or an authorized integration while fmcloud.fm manages the server infrastructure.
Conclusion
FileMaker Pro is both a low-code development environment and the principal desktop client for FileMaker custom apps.
It brings together:
- a relational database;
- a visual interface designer;
- a scripting and calculation engine;
- reporting and search tools;
- security and access control;
- integration technologies;
- desktop application delivery.
This integrated approach allows organizations to create software around the way they actually work instead of forcing their processes into a generic application.
FileMaker Pro can be approachable enough for a beginner to create a first database and powerful enough for experienced developers to build business-critical systems used across desktop, mobile, web, and external services.
When the application needs to be shared, fmcloud.fm provides the FileMaker Server infrastructure, expertise, security, and support required to make it reliably available to its users.
