A multitude of functions to offer support for AI/Large Language Model (LLM)

• Generate Response from Model

  Empowers developers to craft bespoke interactions with language models by customizing prompts and function calls directly within FileMaker scripts. This feature allows developers to interact with AI models to obtain text responses based on user prompts. It extends FileMaker's capabilities in integrating AI-driven content generation into custom solutions

• Perform SQL Query by Natural Language

  This feature allows developers to execute SQL queries in their databases using natural language prompts instead of manually writing SQL statements. It leverages AI models to interpret user queries, generate corresponding SQL, execute these queries -all without transferring actual database data to the AI model. And if you want, you can choose to sent the data to the model to get a natural language response.

• Perform Find by Natural Language

  Enables users to execute find requests using natural language prompts instead of traditional find criteria. By leveraging AI models, this feature interprets user inputs and dynamically generates corresponding FileMaker find requests, streamlining data retrieval processes.

• Configure Prompt Template

  Allows developers to define reusable prompt templates for AI operations involving natural language processing. These templates streamline the configuration of AI script steps by encapsulating predefined prompts and associated parameters, which can be easily referenced across solutions.

• Configure Regression Model

  Introduces the ability to train, save, load, and unload regression models directly within FileMaker solutions. This feature leverages embedding vectors derived from text data alongside numeric target values to facilitate predictive analytics and regression tasks.

• Perform RAG Action

  Facilitates interaction with Retrieval-Augmented Generation (RAG) spaces on AI model servers. This capability allows developers to manage prompts and data within these spaces, enhancing the contextual understanding and response quality of AI models used in FileMaker solutions.

• Semantic Search & Vector Embedding Improvements

  FileMaker 2025 introduces several enhancements to semantic search and vector embedding capabilities, enabling more sophisticated data analysis and retrieval options. These improvements aim to streamline operations involving text and image data, offering developers greater flexibility and control.

• AI Services

  A significant enhancement has been made to integrate open-source models and Python server functionalities more seamlessly into FileMaker Server, with improved management capabilities via the Admin Console. This update includes both backend improvements for server management and frontend conveniences for developers and administrators.

New functions in support of AI

• NormalizeEmbedding

  Ensures embedding vectors are optimally formatted and scaled, enhancing precision and compatibility for custom AI operations within FileMaker solutions

• AddEmbeddings & SubtractEmbeddings

  Streamlines semantic operations by offering built-in functions to seamlessly add and subtract embedding vectors, enhancing computational efficiency and accuracy in AI tasks.

• GetRAGSpaceInfo

  Delivers insightful visibility into RAG Server configurations, empowering administrators with essential details on existing RAG Spaces and embedding models for optimized management.

• MLRegressionPred

  Enables precise predictive analytics within FileMaker by leveraging trained regression models to generate insightful forecasts from embedding vectors.

• PredictFromModel

  Returns the predicted value from a trained regression model for the specified text embedding vector. You can use the Configure Regression Model script step to train and load a model first.

A number of new functions on FileMaker Pro

• GetFieldsOnLayout function

  Provides a detailed JSON representation of fields present on a specified layout, filtered by find accessibility criteria. This function aids developers in dynamically understanding and managing layout configurations within their solutions.

• GetTextFromPDF Calculation Function

  Extracts text content from PDF files stored in container fields, converting them into plain text format. This feature streamlines workflows that require interaction with PDF documents by enabling direct text retrieval and analysis.

• Go to List of Records Script Step

  Enhances navigation capabilities within FileMaker solutions by allowing scripts to redirect users to a specified list of records based on defined relationships and found sets. This feature facilitates efficient data exploration and relationship-based interactions.

• Folders for Custom Functions

  In FileMaker 2025, a significant enhancement has been made to the management of custom functions by introducing folder structures within the "Manage Custom Functions" dialog. This feature mirrors the organizational capabilities already available for scripts and layouts, allowing developers to better categorize and manage their custom functions.

• Collapse Script Parts

  FileMaker 2025 introduces code folding functionality to the Script Workspace, enabling developers to collapse and expand sections of scripts. This feature enhances script navigation and management by allowing developers to focus on high-level structures while working within complex scripts.

• macOS UI Refresh

  In FileMaker 2025, a significant macOS UI refresh aims to modernize the FileMaker Pro interface, enhancing user experience for both developers and end-users. This initiative, primarily targeting macOS, seeks to reduce the legacy perception of FileMaker by incorporating contemporary design elements and improving usability.

• Add/Remove Object to group

  FileMaker 2025 introduces enhanced grouping functionalities, allowing developers more precise control when managing objects within layouts. Specifically, the ability to add or remove objects from groups without disrupting their containment within other layout elements, such as tab controls, is now improved.

• GetRecordIDsFromFoundSet

  Returns record IDs from the current found set as a list or a JSON array. The record IDs can optionally be returned as values and ranges of values. The output can be used with the new Go to List of Records script step.

• JSONParse

  Parses text as JSON data and keeps the parsed JSON representation in memory for you to reuse with other JSON functions. You can significantly improve performance of JSON calculations that reuse the same JSON data many times by using this function first, for example, to store the result in a variable: Set Variable [ $json ; Value: JSONParse ( "[3]" ) ]

• JSONParsedState

  Examines the input passed into it to determine whether it has parsed JSON data as part of it (that is, JSON data previously parsed by the JSONParse function). The function returns 0 if JSON is not parsed, -1 if parsed but invalid, or a positive number representing the JSON type if parsed and valid.

Novelties on FileMaker Server

• Now runs on both Ubuntu 24 and Ubuntu 22 enabling faster, cost-effective deployment

• Improved JSON Performance

  Parsed JSON structures are now cached in DBData, reducing repeated parsing and significantly boosting performance. Note: these JSON performance enhancements also apply to FileMaker Pro and FileMaker Go.

• Upgrade Tool Enhancements

  Supports patching scripts, relationships, themes, and more, improving upgrade flexibility. Includes layout objects and field format options, streamlining data structure upgrades. Upgrade tool now bundled with FileMaker Server eliminates standalone downloads.

• Performance Improvements

  Addresses memory leaks by optimizing script execution threads, improving server responsiveness and stability during high-load scenarios, improving parallel task handling, reducing memory leaks, and boosting scalability.

• Improved Send Thread Pool

  You can now handle more concurrent users smoothly because FileMaker Server manages connections more efficiently.

• FAC/Admin API Enhancements

  Admin Console includes functionality to flush database pages to disk. You can set the number of FileMaker Script Engine (FMSE) sessions that are allowed to run simultaneously through Admin Console allowing administrators to optimize performance based on CPU-bound or I/O-bound workloads.

• Let’s Encrypt Integration

  FileMaker Server’s Let’s Encrypt SSL integration offers comprehensive management through the Admin Console, eliminating command-line needs. Enhanced security includes restricted port 80 access during verification and automated renewals for both primary and secondary machines, streamlining certificate handling across deployments. This setup simplifies operations while bolstering security for administrators.

Updates to FileMaker GO

• Keyboard Navigation Support

  Enhances accessibility and usability by supporting keyboard navigation via arrow keys and the Space/Enter key for layout object navigation in FileMaker Go.

• Hover State Support

  Introduces hover effects for various layout objects similar to what is available using visionOS, enhancing user interaction by providing visual feedback when hovering over elements like text, buttons, fields, and more.

• Manage FileMaker Go files in the Files app

  FileMaker Go files on device are now visible in the Files app, allowing access without starting FileMaker Go first. This provides an alternative way to share and access files on device.

• Support for the latest iOS and iPadOS.

Updates to WebDirect

• Right-Click Context Menu

  Right-click contextual menus are supported, allowing users to access common operations like copy and paste directly from the context menu.

• Custom Homepage Configuration

  Admin API includes endpoints for managing the Custom Homepage settings, allowing you to enable, disable, and configure custom home URLs programmatically. The Custom Homepage option is available in Admin Console, allowing you to configure custom home URLs.

• Browser Back Button Warning

  Warning dialog is displayed when users attempt to click the browser's Back or Forward buttons, closing the tab or window, reloading the page, or navigating away by clicking a link, helping prevent accidental session termination and providing a more intuitive user experience.

• Performance Improvements

  Optimization fixes for FileMaker Server, particularly addressing performance degradation on secondary machines in multi-machine deployments. Supports higher concurrency (500–1,000 users).

Important changes to the FileMaker API’s

• Data API Client Session Validation

  This update addresses issues related to session handling in FileMaker's Data API (DAPI), specifically focusing on improving concurrency and resource management during session use. It introduces a client session validation endpoint to provide session status, enhancing scripting and integration capabilities.

• WebHook Support in FileMaker OData API

  This new feature allows external services like Claris Studio and Claris Connect to receive real-time notifications about changes in records or schemas within a FileMaker database.

A tight integration with Claris Studio

Enabling bidirectional data flow, shared tables, and streamlined user input across web and desktop. Studio custom views now support large record sets (100,000+), letting developers confidently build performant solutions for data-heavy industries

Access control is now enforced across Studio hubs and views, even down to the record level. Only users granted access can see specific data—ensuring developers can safely deploy secure, role-based solutions.

If these technical details go too deep, go to THIS ARTICLE to explore how FileMaker 2025 can support your business goals tailored for business professionals and non-developers