Using Artificial Intelligence tools in Claris FileMaker 2024

Ben Fletcher • 18 February 2025

Large Language Models & Artificial Intelligence

Large Language Models (LLMs) are a type of artificial intelligence (AI) designed to understand and generate human-like language using deep learning techniques. They are built on transformer neural networks, which enable them to process and analyse vast amounts of text data, often spanning billions of parameters, to perform tasks such as text generation, translation and summarisation.  Some prominant examples of LLMs include OpenAI GPT-4, Anthropic Claude, Google Gemini and DeepSeek.


These models have revolutionised natural language processing (NLP) by enabling machines to perform human-like communication tasks with remarkable accuracy.


How to use LLMs with FileMaker 2024

All of the LLMs mentioned above offer access via standard JSON/REST API interfaces and Claris FileMaker first introduced support for integrating with REST APIs using the cURL script step all the way back in FileMaker 16 (released in 2017).  FileMaker 2024 massively simplifies the complexity of leverage LLMs by adding a bunch of native AI specific script steps including: Configure AI Account, Insert Embedding and Perform Semantic Find.


  • Configure AI Account - allows you to specify an arbitrary internal reference for sending a specific LLM (i.e. 'DataTherapy Account with OpenAI'), along with the type of model (Open AI, Cohere and Custom local servers are current supported as of 17th Feb 2025) and the API key you have generated to access the LLM service.
  • Insert Embedding - you specify the AI Account to use (set-up with Configure AI Account), the text data that needs to be input into the LLM, the specific model to use and then the target to insert the vectorised representation of that data that the LLM has generated (this would normally be inserted into a FileMaker Container field).
  • Perform Semantic Find - carries out a find within the current found set of records, using the specified AI Account, either by natural language query or comparison to a vectorised text file.


Example use case for AI in FileMaker: CV Semantic Search for Recruitment

We have a number of clients using the FileMaker platform for Recruitment (as Consultants or in-house HR Teams).  As you might expect, they have extensive databases with thousands (or tens of thousands) of Candidate profiles, usually with a summary of the Candidate's CV stored in a text field.  Commonly, the first stage in generating a shortlist for a new role would be to whittle down potential candidates based on their availability, the seniority of the file and salary band, but this can still result in hundreds of suitable applicants that the Recruiter would need to look at or carry out keyword searches on their CV summary in the hope of getting down to a manageable list of 5-10 prospective candidates to contact.


Classic keyword searches can be exceptionally hit and miss - if you looking at CVs for a Marketing position then just about all candidates will mention 'Marketing' in their CV so that isn't a useful way to refine the search.  Likewise, too specific a search term might incorrectly rule out candidates that are otherwise qualified - for example, if you searched for an exact match on 'B2B Marketing' then you would miss candidates which has 'B2B and Consumer Marketing' or 'Marketing (B2B)' mentioned on their CV summary. 


Clearly, what we need here, is a search technology that focuses on understanding the meaning and the intent behind the Consultant's search query rather than just bluntly matching keywords and this is exactly what the semantic search does.  If they did a semantic search for an 'Experienced B2B Marketing Professional with background in IT', then we would want to to pick up on candidates that might mention as varied phrases in their CV as 'Experienced B2B Marketeer', 'B2B Veteran', 'Cloud Services Marketing (B2B)', etc. 


How to achieve this in FileMaker? First you need to register with a LLM provider and obtain an API key.  Cohere offers a free trial account.    Then you just need to set-up 3 script steps:


This first Script, 'Configure AI Account' simply contains the authentication information so that it can be run as a subscript each time the LLM account needs to be used.  The 'Embedding Details Data - Applicants' takes the text from the 'Biography' (Text) field and then pushes the vectorised representation from the LLM into the 'Biography_Embedding' (Container) field.  In practice you would probably want this to update every time the 'Biography' field is updated via a Script Trigger.  Finally, the last Script, 'Perform Semantic Find - Applicants' takes the text from the 'SearchApplicantGlobal' (Global text field), uses the LLM to generate a vectorised representation which is then compared to the contents of the 'Biography_Embedding' field for the current found set of records.  This is limited to only returning the 10 matches which only  similarity which the LLM judges to be greater than 25%.


You now have a system that will that allows you to carry out semantic searches on the biography of applicants rather than just key words!


Technical considerations

Despite how magical semantic search can seem when it is correctly implemented, it does have some technical constrains which need to be considered in real world applications:

  • LLMs have different pricing models and subscription fees.  In most cases there will be an effective cost per token.  While this may be trivial in our example for a handful of CVs/biographies to be embedded, but if you had millions of records then the costs would quickly escalate.  Equally, you need to update the embedding whenever CV/Biography is updated - an additional on-going costs.
  • AI systems offer multiple types of model optimised for different purposes.  In the example from Cohere above the 'embed-english-light-v3' model is only suitable English language use and only supports up to 512 tokens being sent per embedding request.  The GetToken() function can be used to estimate the no. of tokens that are in a given piece of text in advance of sending it to the LLM services.


If you don't know where to started with adding AI to your Claris FileMaker App , then why not contact our Team for a free initial consultation. We're here to help you achieve your business goals.

by Ben Fletcher 10 June 2026
Upgrade to Claris FileMaker 2026 with confidence. Learn key migration considerations, AI features, compatibility issues and best practices.
by Ben Fletcher 10 June 2026
FileMaker Server 26 Enhancements Multiple SASE Processes - FileMaker Server 26 allows you to configure the number of active process in the Server Side Script Engine (SASE), the upper limit being determined by the hardware in use. This allows for more server side processes to occur in parallel - for automated imports, sync and nightly data transformations which need high throughput. Auto-Restart - FileMaker Server's Web Publishing Engine (WPE), OData and Data API services now monitor and detect abnormal termination events and restart automatically on a crash. Export Field Contents on Server - No additional 3rd party plugins or work arounds to automate server side document generation and export to server side folders. FileMaker Go 26 for iOS Enhancements Additional support for iOS hardware and locale support. Core Platform Security Enhancements Additional corporate security enhanced with support for OpenSSL 3.5 LTS, Apache Tomcat 10.1.44+, Windows Server 2025 certification, and full macOS 2026 compatibility. Need help to upgrade to FileMaker 26? At DataTherapy, we specialise in supporting and upgrading legacy FileMaker apps as well as building new custom apps to leverage the latest features of the Claris FileMaker 26 platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. βœ… Certified Claris FileMaker Developers βœ… UK-based team of full-time professionals βœ… Platinum Claris Partner βœ… Experts in secure, on-premise and private cloud deployment of FileMaker πŸ“ž Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
by Ben Fletcher 10 June 2026
As well as the customer facing UI enhancements, FileMaker 26 has a number of 'under the hood' tool enhancements for long standing developers: Enhanced Inspector - layout controls dynamically adjust based on the object type, reading the cognitive load of navigating the Layout Mode tools for new and veteran developers alike. Control Field Entry by Calculation - field level editablity is now controlled by a boolean calculation that evaluates at runtime based on any developer defined logic. This makes building role based editing or workflow based record locking much easier to implement. Sort Custom Functions with Folders - this now is applied at an independent folder level, making it much easier to work with distributing a shared function library that needs to display in a specific order. Set Layout Zoom by Calculation - the UI zoom can now be scripted to any decimal percentage, making it easier to make layouts which adapt to a specific user or device screen size requirements. Draco Catalog - FileMaker 2026 now includes a persistent catalog which is independent from the application data which can be used for storing JavaScript modules and persistent solution-level settings (app versions, feature flags and environment identifiers). PDF Script Workspace - dedicated script steps have been added for PDF manipulation which makes the generation of multi-page reports assembled from different layouts both using FileMaker Pro client and via FileMaker Server. Need help to upgrade to FileMaker 26? At DataTherapy, we specialise in supporting and upgrading legacy FileMaker apps as well as building new custom apps to leverage the latest features of the Claris FileMaker 26 platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. βœ… Certified Claris FileMaker Developers βœ… UK-based team of full-time professionals βœ… Platinum Claris Partner βœ… Experts in secure, on-premise and private cloud deployment of FileMaker πŸ“ž Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
by Ben Fletcher 10 June 2026
FileMaker 2025 already added significant enhancements to leverage AI and FileMaker 26 continues to double down on this: Field Annotation A new AI tab is available within the Field Options to define a JSON calculation as the field's annotation which is used in Export dialogs, sort dialogs and most essential in Data Definition Language (DDL) for use in AI. Save as XML & Solution Upgrade Tool FileMaker Pro 26 can now save a copy of your solution as a .xml formatted text file and the enhanced Solution Upgrade Tool can now read XML input and create brand new .fmp12 files or patch existing ones. This is a huge boon for Claris FileMaker developers - it means that Claris FileMaker developers can now use AI tools to generate XML which can then be used to create real production ready FileMaker solutions. Additionally, traditional version controlling scheme and using diff tools to compare XML outputs between production and development releases can be compared. Google Gemini Support Gemini is now supported as a native option in FileMaker script steps making it substantially easier to integrate with Google Cloud and Gemini if that is your preferred AI backend provider. PDF Text Extraction The native ExtractTextfromPDF() function introduced in FileMaker 2025, can now be used to process OCR (scanned) PDFs and not just text-layer PDFs. This again reduces the reliance and cost of using additional 3rd party plugins, APIs or AI tools for text extraction. Need help to upgrade to FileMaker 26? At DataTherapy, we specialise in supporting and upgrading legacy FileMaker apps as well as building new custom apps to leverage the latest AI features of the Claris FileMaker 26 platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. βœ… Certified Claris FileMaker Developers βœ… UK-based team of full-time professionals βœ… Platinum Claris Partner βœ… Experts in secure, on-premise and private cloud deployment of FileMaker πŸ“ž Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
by Ben Fletcher 10 June 2026
The new Claris FileMaker 2026 release includes enhancements to user experience and accessibility: WebDirect Accessibility & Platform updates WebDirect now includes better screen reader support for the visually impaired or motor disabilities: semantic HTML is now correctly labelled and there is improved focus management for modal dialogs, portals and pop-ups. This is a critical requirement for any public-facing WebDirect solutions where accessibility is a legal obligation. WebDirect in FileMaker 2026 now runs on JDK 21 - removing a barrier to corporate environments that have strict or have deprecated older versions of JDK in their infrastructure. Japanese Calendar Support Native Japanese era-based (gengō) calendar system support has been added in FileMaker 2026— drop-down date pickers now display and accept dates in the Japanese calendar across all. This is critical to Japanese solutions where there s a legal mandate for governmental and official documents to use era-based dating. Need help to upgrade to FileMaker 2026? At DataTherapy, we specialise in supporting and upgrading legacy FileMaker apps as well as building new custom apps to leverage the latest features of the Claris FileMaker 26 platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. βœ… Certified Claris FileMaker Developers βœ… UK-based team of full-time professionals βœ… Platinum Claris Partner βœ… Experts in secure, on-premise and private cloud deployment of FileMaker πŸ“ž Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
by Ben Fletcher 10 June 2026
The new Claris FileMaker 2026 release includes two highly significant enhancements to business continuity and disaster recovery: FileMaker Standby Server FileMaker Server 2026 can be paired with a second 'hot spare' server which is always ready to become the primary, with failover only taking a few minutes to implement. This means that a hardware failure of the primary server server can be quickly recovered from by promoting the secondary server. Previously, synchronising data between a primary and fail over server would have required additional software adding complexity and cost to a FileMaker Server deployment. FileMaker Server 2026 now includes this service as standard, making it much more economic to implement. The fail over server does not have to be running on the same OS platform or network and so you can run a hybrid on-premises + cloud or split across different cloud data centres or providers for added robustness. FileMaker Server Remote Backup Claris now offer a cloud storage backup service integrated directly with FileMaker Server which can be bolted onto existing FileMaker Server installations (on-premises or running on private cloud). While many private managed hosting providers such as DataTherapy have implemented cloud backups as part of their standard service, FileMaker customers with on-premises infrastructure would often struggle to implement robust backup solutions without dedicated virtualisation teams and additional 3rd party backup software. Again, this provides an economic option for FileMaker customers to consider as part of their disaster recovery strategy. Need help to upgrade to FileMaker 2026? At DataTherapy, we specialise in supporting and upgrading legacy FileMaker apps as well as building new custom apps to leverage the latest features of the Claris FileMaker 2026 platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. βœ… Certified Claris FileMaker Developers βœ… UK-based team of full-time professionals βœ… Platinum Claris Partner βœ… Experts in secure, on-premise and private cloud deployment of FileMaker πŸ“ž Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
by Ben Fletcher 10 June 2026
Upgrade to Claris FileMaker 2026 now! DataTherapy are pleased to announce that Claris FileMaker 2026 managed private cloud hosting packages are immediately available on both Windows and Linux platforms via FileMaker Host . DataTherapy can provide scalable, managed FileMaker packages for businesses of all size. Full details of all of our packages can be found here . Why choose DataTherapy for Claris FileMaker Hosting? Hassle-Free Hosting We handle everything – from setup to ongoing maintenance, so you can focus on your business, not server management. Personalised UK-Based Support Speak to real FileMaker experts, not call centres. All our servers are fully managed by our in-house team. Secure, High Performance Infrastructure Our hosting is fine-tuned for optimal database performance and is hosted on Amazon Web Services (AWS). Our servers are scalable, provide enterprise-grade security, and we handle backups to keep your data safe. No Long-Term Contracts Flexible quarterly billing options with a free 2-week trial for maximum flexibility without long-term commitments. Fully Customised Hosting Tailored for your Business We understand FileMaker inside out. Whether you’re running a small business system or a large enterprise solution we can provide the perfect plan based on your user and performance needs. If you need additional information, or would like to arrange a free trial of any of our packages then please don’t hesitate to contact our team .
by Ben Fletcher 10 June 2026
What is new in FileMaker 26? The Claris FileMaker 26 (version 26 - they have officially skipped versions 23-25 so that the version number aligns with the year of release ) Platform for is now available as of 10th June 2026 and demonstrates Claris’ on-going commitment to embrace transformative technologies. Whether you’re a long-time FileMaker user or just exploring how to modernise your internal systems, this latest release includes expanded AI capabilities including Google Gemini support, major server reliability improvements, and significant accessibility advances. Here’s what you need to know: AI capabilities Google Gemini support: Adds Gemini to FileMaker's growing list of supported AI providers, giving developers greater flexibility when building intelligent applications. Field and table annotations: Attach semantic meaning to fields and tables so AI models have richer context — improving the accuracy of natural language queries and LLM-generated insights. Metadata calculation functions: New functions including BaseTableComment and FieldAnnotation provide programmatic access to schema documentation, making AI-powered solutions easier to build and maintain entirely within FileMaker. Server reliability and infrastructure Automatic crash recovery: The Web Publishing Engine, OData service, and Data API now restart themselves after interruptions — reducing downtime without manual intervention. Multiple SASE processes: Support for multiple Server-Side Script Engine processes improves throughput and responsiveness under heavy workloads. Updated platform compatibility: Full support for macOS 26, Windows Server 2025, OpenSSL 3.5 LTS, and Apache Tomcat 10.1.44+ ensures deployments stay secure and supported in modern IT environments. Accessibility WebDirect improvements: Updated semantic HTML, improved screen reader compatibility, better focus management, and ARIA compliance — a significant step toward WCAG 2.1 compliance. No redesign required: Existing layouts benefit from accessibility improvements automatically, lowering the barrier for partners serving clients with compliance requirements. What benefits doe this bring to new and existing FileMaker customers? Build and deliver faster — A smarter development environment with context-aware tooling and scripting improvements means less time on layout friction and more time building solutions our clients love. Lead with AI — Google Gemini support, field annotations, and native metadata functions give us the tools to build genuinely intelligent apps — without third-party platforms or custom integrations. Reduce client downtime — Automatic service recovery means enterprise deployments keep running even when issues arise. Serve every user — Built-in accessibility improvements help clients meet WCAG 2.1 and Section 508 requirements, opening doors to new government, healthcare, and enterprise customers. Grow with a future-ready platform — Compatibility with the latest operating systems, security standards, and AI providers means the solutions we build today are designed to last. Ready to upgrade your business to FileMaker 26? The new benefits of FileMaker 26 mean you can layer power AI into existing solutions without any major redevelopment work. Support for natural language input allow smarter and more intuitive applications to improve your business decision making. At DataTherapy , we specialise in building custom apps for business using the Claris FileMaker platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. βœ… Certified Claris FileMaker Developers βœ… UK-based team of full-time professionals βœ… Platinum Claris Partner βœ… Experts in secure, on-premise and private cloud deployment of FileMaker πŸ“ž Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
FileMaker Pro Logo
by Ben Fletcher 1 May 2026
Rosemary Tietge (Claris Community Engagement Manager) was kind enough to invite me to be a panelist on Community Live 45: Level up your FileMaker email game . This was off the back of our past blog post covering this topic . We were also joined by the highly knowledgeable David Sullivan of Mandelbrot LLC .
Claris FileMaker Logo
by Ben Fletcher 25 March 2026
We look at the latest FileMaker 2025 (20.0.6) security fixes.
More posts