Claris FileMaker

Claris FileMaker is a low-code, cross-platform relational database platform that enables users to quickly build custom business applications. It integrates a database engine with a user-friendly graphical interface and supports development for desktop, mobile (iOS), web, and cloud environments. FileMaker combines ease of use with powerful features, including AI integration, automation, scripting, and broad connectivity to other systems, making it suitable for streamlining workflows, managing data, and creating scalable solutions across various industries.


Our thoughts on Claris FileMaker

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
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.
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.
Claris FileMaker Logo
by Ben Fletcher 5 March 2026
We look at the latest FileMaker 2025 (20.0.5) features & security fixes.
Toy Robot
by Ben Fletcher 22 January 2026
Learn what Model Context Protocol (MCP) is and why it matters for Claris FileMaker developers, enabling secure, flexible AI and LLM integrations.
Claris FileMaker Icon
by Ben Fletcher 18 December 2025
Find out what the latest bug fixes are in the Claris FileMaker 2025 (v22.0.4) release are.
Beach & horizon.
by Ben Fletcher 5 November 2025
Are you just surviving with your data — or thriving with it? 💡 Discover how DataTherapy’s Hierarchy of Data maps your journey from basic data integrity to AI-powered innovation.
Birthday cake.
by Ben Fletcher 3 November 2025
Claris FileMaker turns 40. Discover why its adaptability, longevity and continued innovation still make it a trusted platform for modern businesses.
Law book on a table.
by Ben Fletcher 7 October 2025
Discover 10 hidden GDPR risks in AI adoption and learn how Claris FileMaker helps UK SMEs innovate securely while staying fully compliant.
Stephoscope and medical clipboard.
by Ben Fletcher 18 September 2025
DataTherapy helped St Mark’s Centre streamline cancer research and patient care by unifying databases into a secure, efficient Claris FileMaker system.
Light shines through a window.
by Ben Fletcher 10 September 2025
Windows 10 support ends Oct 14, 2025. Upgrade to Windows 11 and FileMaker 2024 or FileMaker 2025 to stay secure, supported, and future-ready.
by Ben Fletcher 18 August 2025
Want faster, smarter FileMaker apps with AI? We compared gpt-oss, Llama & DeepSeek to find the best local model for Apple hardware. Find out who wins
by Ben Fletcher 9 July 2025
Claris FileMaker 2025 is the ultimate platform for custom app creation, now with powerful new native features for leveraging Artificial Intelligence by integrating Large Language Models (LLMs) and integrating with Claris Connect and Claris Studio . Given its advanced features and capabilities, it's the platform of choice for SMEs seeking to start fresh building a new custom business app. However, if you're thinking about upgrading from an older Claris FileMaker version, preparation is key, and that's where we come in. This brief guide outlines the major points of consideration when upgrading. However, don't worry if these technicalities overwhelm you - our expert consulting team is just a click away, ready to guide you through any concerns. The Upgrade Process: Claris FileMaker v12-v2024 (.fmp12 format) The good news: versions 12-2024 share the same file format as the 2025 version, making upgrades a breeze. However, certain interface changes might require user adaptation if your app was built prior to FileMaker 16. For example, if your users utilize the footer bar for zoom control, view mode changes, or status bar display, they'll have to adjust to using the upper status bar and application menus. If that's a challenge, our consultants can assist with incorporating zoom control into your interface layouts. One caveat is that while it's possible to use legacy versions of Claris FileMaker Pro to connect to Claris FileMaker Server 2025, we advise against it. Mixing client versions can prevent you from leveraging the full benefits of the Claris FileMaker 2025 feature set. For maximum security and optimal performance, make sure both the server and all users are on the latest software version and patch. Claris have compiled a handy checklist of deprecated features in Claris FileMaker 2025, so make sure to verify if these impact your usage: https://support.claris.com/s/answerview?anum=000048380&language=en_US Revamping Your Legacy Systems: Claris FileMaker v6-11 (.fp7 & .fp5 format) or earlier Older versions of FileMaker are a testament to the platform's longevity. However, they do come with unique challenges, including the impossibility of direct conversion using Claris FileMaker 2025. Don't worry, we're equipped to handle these issues and are ready to bring your vintage database files into the present. We also recommend considering a fresh start. The latest Claris FileMaker boasts myriad features that can significantly boost your business operations. Remember: upgrading isn't merely about maintaining the status quo—it's about embracing innovation and driving your business forward. If you want to do the minimum possible work to convert your files into the v2025 format then look at our previous guide for FileMaker Pro 19: https://www.datatherapy.com/news/2020/6/5/planning-your-upgrade-to-claris-filemaker-19-platform General Upgrade Considerations: Let's Get Practical No matter your current version, our team can assist you through the upgrade process, even if your app involves complex dependencies, such as integrations with legacy software or plugins. Note that most plugins will require updates (sometimes paid) to ensure compatibility with Claris FileMaker 2025. We encourage you to consider the future-proofing benefits of a 'cloud-first' and 'AI-first' mindset. Older systems may not have been built with this in mind, but the modern Claris FileMaker platform has been designed to seamlessly integrate with other cloud solutions and now leading public and private LLMs. Ultimately, we believe that your software should work for you, not the other way around. That's why we're committed to ensuring your upgrade is more than a simple technical exercise—it's a strategic move that aligns with your business' evolution. If you're ready to harness the power of the modern, interconnected, and dynamic Claris FileMaker 2025, get in touch with us today . We're here to help you achieve your business goals.
by Ben Fletcher 9 July 2025
Claris FileMaker 2025 is now available
Post pattern artwork.
by Ben Fletcher 30 June 2025
Integrate Claris FileMaker with local vision AI using llama3.2-vision and Ollama. Keep data private while adding powerful image processing to your workflows.
Ai Robot
by Ben Fletcher 17 June 2025
Discover the power of DeepSeek R1—an efficient, open-source AI model ideal for private, local deployment using Ollama and Apple Silicon. Learn how DeepSeek compares to LLaMA, Mistral, and other LLMs in real-world applications, and explore how it integrates seamlessly with Claris FileMaker for secure, on-premise AI automation. Ideal for businesses needing low-cost, high-performance, and fully private AI solutions.
by Ben Fletcher 16 May 2025
Learn how to run private AI locally using Ollama and integrate it with Claris FileMaker. Discover step-by-step setup, model recommendations, and how to build secure, AI-powered workflows without sending data to the cloud. Perfect for businesses prioritising data privacy and compliance.
Possibility of AI.
by Ben Fletcher 13 May 2025
Integrate Claris FileMaker with local LLMs like LLaMA 3 to boost efficiency with AI—without risking data privacy. Secure, intelligent automation for your business
by Ben Fletcher 29 April 2025
Still running your business on Google Sheets? Spreadsheets are great—until they start holding you back. If you’re managing complex processes, critical data, or multiple users through Google Sheets, it’s time to upgrade.
by Ben Fletcher 25 April 2025
The Claris FileMaker Server 21.1.4 update is now available and includes important fixes that address known issues from previous versions: Key Fixes 1. Field definitions incorrectly read from cache. A bug introduced in version 21.0 caused field definitions to be incorrectly cached, resulting in symptoms such as: Empty related fields Missing value lists and indexes “Insufficient privileges (error -9)” messages 2. Windows only: Server-side script sessions limited by CPU cores. Version 21.1.3 limited simultaneous server-side script sessions to the number of CPU cores on Windows. This impacted I/O-bound environments by unnecessarily queuing sessions. 21.1.4 resolves this by allowing up to 50 concurrent script sessions on Windows before queueing begins—regardless of CPU cores. These sessions may be triggered by schedules, OData, or Perform Script on Server (PSoS). Note: This behavior is not controlled by the AllowPSoS setting. Claris Recommends: To ensure system stability, it is advised to limit active clients to 40 - 45 simultaneous sessions. Exceeding 50 may result in delays, memory overload, or session hangs. Do you need assistance with upgrading? DataTherapy are pleased to announce that Claris FileMaker 2024 (version 21.1) managed private cloud hosting packages are immediately available. DataTherapy can provide scalable, managed FileMaker packages for businesses of all size. Full details of all of our packages can be found here . We can offer a range of a variety of enhanced options such as domain management, custom SSL certificates, VPN, VLAN, disaster recovery and integration with other technologies. If you need additional information on upgrading to the new release, advise on how to migrate your current on-premises FileMaker Server to the cloud, or would like to arrange a free trial of any of our packages then please don’t hesitate to contact our team .
Music venue
by Ben Fletcher 31 March 2025
How DataTherapy and Inner City Music built the Venue Dashboard for Band on the Wall with Claris FileMaker.
Optimising Claris FileMaker App Performance
by Ben Fletcher 25 March 2025
What to do when your FileMaker App isn't running as well as it used to . . .
by Ben Fletcher 14 March 2025
Ensuring Business Continuity: Augmenting or Replacing Your In-House FileMaker Team
by Ben Fletcher 18 February 2025
FileMaker 2024 massively simplifies the complexity of leverage LLMs . . .
by Ben Fletcher 6 June 2023
The Claris FileMaker 2023 is the ultimate platform for custom app creation. Given its advanced features and capabilities, it's the platform of choice for those seeking to start fresh building a new custom business app. However, if you're thinking about upgrading from an older Claris FileMaker version, preparation is key, and that's where we come in . . .
by Ben Fletcher 27 April 2023
New Features in Claris FileMaker 2023 Release
by Ben Fletcher 16 June 2022
New Features in Claris FileMaker 19.5 Release
by Ben Fletcher 17 December 2021
We can confirm that our Platopus platform does not make use of Java and so is unaffected by the Log4j security vulnerability.
by Ben Fletcher 17 November 2021
The Claris FileMaker 19.4 Platform release demonstrates Claris’ impressive commitment to more agile and frequent updates to the platform. Significiant features in this r elease:  Windows 11 and macOS Monterey 12 compatibility Updates to ensure the best performance, stability and security for Windows 11 in FileMaker Pro and macOS Monterey support for FileMaker Pro and FileMaker Server. Ability to automate tasks in FileMaker Pro with Shortcuts in macOS Monterey Run automation scripts in FileMaker Pro and streamline your everyday tasks. Just use the Shortcuts app or Siri voice control to run shortcuts. Use your voice to automatically search for records, run reports for specific dates, send attachments via email, update inventory, modify files stored in container fields, and more. More flexible authentication with customizable OAuth identity providers. Set up user authentication the way your business requires. In addition to three predefined OAuth identity providers, this release provides a straightforward UI to customize one of four additional supported providers (Ping, OneLogin, Auth0, and Okta), or any other provider using OAuth2 or OpenID protocols. iOS 15 and OpenSSL 1.1.1l compatibility in FileMaker Go 19.4. FileMaker Go 19.4 suppor ts new iOS 15 and OpenSSL 1.1.1l to improve security. Key b ug fixes and security updates. Take advantage of the latest performance and security improvements. More than 50 bugs are addressed throughout the entire FileMaker 19.4 product li ne, including issues related to Apple silicon, web viewers and interactive containers in Windows, FileMaker WebDirect performance, security, and much more. Contact us to book in your FREE consulting session to provide an overview of how to go about upgrading to the Claris FileMaker 19.4 platform or alternatively take a look about our blog post outlining some of the considerations here.
by Ben Fletcher 21 June 2021
The FileMaker 19.3 release demonstrates Claris’ impressive commitment to more agile and frequent updates to the platform. Noteable features in this release include: Native Apple silicon support. Claris FileMaker Pro and FileMaker Server are now Universal macOS binaries, ensuring optimized performance on Apple silicon computers while still offering impressive speed on Intel-based Macs. Windows Microsoft Edge. Windows users will love this release. FileMaker now leverages the latest Microsoft Edge browser WebView2 control, eliminating potential security concerns and ensuring full FileMaker extensibility on Windows. And with Microsoft Edge you get enhanced displays of PDF files – without needing to install a separate web browser plug-in. FileMaker Server: Future-proof with Ubuntu Linux and return of the log viewer. Claris continues to innovate our deployment options introducing Ubuntu, the most preferred Linux distribution worldwide. Known for its responsive, enterprise-grade support, stability and security, Ubuntu is also one of the most affordable open source platforms available. Also, you asked and we heard you. This release includes the return of a new and improved log viewer, and many more server fixes and under-the-hood functionality to boost performance, flexibility, stability and security. FileMaker Cloud: More feature parity between on-premise FileMaker Server and FileMaker Cloud. FileMaker Cloud now offers more of the popular FileMaker Server features you've asked for. You can now schedule FileMaker Scripts directly from the Admin Console and take advantage of the log viewer to easily download and view log files from the Admin Console. Test drive updates to the quick start experience* with the next generation no-code app builder. Explore our next generation no-code app builder to create FileMaker apps with a simple drag and drop interface in minutes. And when you’re ready, a simple button click lets you continue building your app with the full FileMaker Pro feature set. New in this release it’s easy to create relationships between tables with quick drag-and-drop and absolutely no coding. In addition, you can now quickly create one bottom navigation bar that works across all your connected layouts - super handy for mobile apps.  *Available on macOS only in FileMaker Pro and in FileMaker Cloud. Contact us to book in your FREE consulting session to provide an overview of how to go about upgrading to the Claris FileMaker 19.3 platform or alternatively take a look about our blog post outlining some of the considerations here.
by Ben Fletcher 16 December 2020
The FileMaker 19.2 release demonstrates Claris’ ongoing commitment to more agile and frequent updates to the platform. Noteable feature in this release: FileMaker Pro Controlling plugin-in access between files. Changes to the new macOS QuickStart experience. FileMaker Server Improved installer for simpler upgrades for FileMaker 16, 17 & 18. Support for HTTP/2 and improved cancel find ability to improve performance.  Contact us to book in your FREE consulting session to provide an overview of how to go about upgrading to the Claris FileMaker 19.2 platform or alternatively take a look about our blog post outlining some of the considerations here.
by Ben Fletcher 23 November 2020
The FileMaker 19.1 release demonstrates Claris’ new commitment to more agile and frequent updates to the platform. Notably in this release: Use snap together add-ons t o take advantage of the new JavaScript widgets. A new quick-start experience for macOS. Visit the Claris blog to read about the latest product release, which includes add-ons and an exciting quick start experience preview . Take a look at the Claris Market place to see try out some of the new add-ons. Claris official add-ons include: Calendar Calendar Heat Map Activity Timeline Barcode Creator Kanban Board Photo Gallery Rich Text Editor Simple Chart Time DataTherapy will be running Zoom Webinars throughout Q4 2020 to demonstrate these features to our customers. Contact us to book in your Webinar or a consulting session to provide an overview of how to go about upgrading to the Claris FileMaker 19.1 platform or alternatively take a look about our blog post outlining some of the considerations here.
by Ben Fletcher 17 July 2020
Machine learning and artificial intelligence are ushering in the next era of computing and it is exciting to see that Claris are at the forefront of providing these serv ices in a way that can be economically used even by small businesses. Claris FileMaker 19 makes use of the MacOS’ built in machine learning tools. Core ML is Apple’s answer to integrating machine learning models into your app. Getting started with Core ML and FileMaker If you download Apple’s Xcode development suite, then you will find it is bundled with the Create ML App. The Create ML App allows you to create a machine learning model file (.mlmodel) which can be used by the new FileMaker 19 Configure Machine Learning Model script step. Create ML App includes machine learning templates for image classification, image object detection, sound classification, text classification and word tagging. For example, I created a test image classifier project and then pointed it at a folder containing 10 sample images (5 cats & 5 dogs). When you click on ‘Train’, it will generate a model file which can then be exported for use in FileMaker. Within FileMaker, I created a simple database table containing two container fields (one to upload the machine learning model file to and another to upload images) and then output fields for the results of the machine learning (Raw result, Classification and Confidence). I then added a quick script to load the model, pass it the image to process and then corresponding fields to insert the data back into: The net result is that I can now add new images to the container and then click on the classify button to run the processing script and it will tell me if it thinks the image is a dog or cat and the degree of confidence in the result. Based on spot testing with a few dozen random images I found online of cats & dogs it does seem impressively accurate given the trivial amount of test data that I used to generate the model. My example is a pretty silly demo, so how might this be used in the real world and why use Core ML rather than one of the online services? Firstly, in terms of applications, the most obvious use would be to use FileMaker for rapid automated classification of large-scale digital image libraries. You could very quickly build a custom classification model and then run the system to classify thousands of images with a high degree of accuracy. A more intriguing use would be in the field of biomedical research – if you have access to historical images of confirmed benign and malignant tissue samples then you could potentially create a system to automate the detection of malignant samples for new images.  The second question then is why use Core ML rather than an online service? There are likely to be many applications where there are concerns about data privacy – for example in the biomedical imaging example I gave above not only does there need to be informed consent from the subjects about making use of their data for research purposes, but there is normally specific additional approval required to share that data with 3rd parties and even if that has been agreed then the security measures which need to be put in place to use such data with a cloud service can be onerous. In the care of Core ML, the data used for creating the learning model is all kept and processed locally on the Mac OS or iOS device – neither the model nor the training data is accessible to Apple or any other 3rd party.
by Ben Fletcher 10 June 2020
DataTherapy are pleased to announce that Claris FileMaker 19 managed private cloud hosting packages are immediately available on both Windows and Linux platforms. DataTherapy can provide scalable, managed FileMaker packages for businesses of all size. Full details of all of our packages can be found here: https://www.datatherapy.com/claris-platform/claris-filemaker-hosting We can offer a range of a variety of enhanced options such as domain management, custom SSL certificates, VPN, VLAN, disaster recovery and integration with other technologies. 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 5 June 2020
Claris FileMaker 19 is a significant upgrade to an already great platform custom app platform. While it is a given that one would immediately use the Claris FileMaker 19 platform for developing a new custom App if starting from scratch today, there may be some work to be done if you are planning on upgrading from an older version of the FileMaker platform. Here is our quick guide of technical considerations to watch out for when updating from previous versions. If you think any of the issues noted are a concern then you are welcome to contact our consulting team for assistance. Upgrading from FileMaker v12-v18 (.fmp12 format) Since FileMaker versions 12-18 share the same file format as version 19 there is no need to convert the file. This usually means the file should simply open in the newer version of the application and there are less likely to be significant conversion issues with upgrading. With FileMaker 16 onwards, in order to produce a more modern ‘app-like’ experience on the desktop, the footer bar which includes the ability to zoom in and out, change working view mode and show/hide the upper status bar has been removed. If your users are making use of these features then they will need to adapt to using the upper status and application menus (for changing mode/status bar) or you may find that you will need to program in zoom control into your interface layouts. Mixing client versions has always been possible to an extent (i.e. if you have legacy machines which are not able to be upgraded to the minimum hardware or OS requirements to run FileMaker 19, then you can still connect to FileMaker Server 19 using FileMaker 18) - this is more restrictive than in previous versions as there was general compatibility back two version and forward two version for FileMaker 18 and earlier. This tightening of support is in line with Claris’ commitment to releasing new updates more frequently and so it isn’t generally advisable to mix client versions and also it means that you cannot take full advantage of the full FileMaker 19 feature set. For optimal security and performance both server and all users should be on the most recent software version and patch. To prevent users from accidentally accessing an upgraded server/solution with an older version of the client software, you can set the minimum version allowed to access the file under File > File Options > Open tab. It is worth checking which features are now deprecated in Claris FileMaker 19 and reviewing if they impact your usage: https://support.claris.com/s/article/Deprecated-and-removed-features-in-FileMaker-19?language=en_US Upgrading from FileMaker v6 or earlier (.fp5 format) It is testament to the longevity of the platform that we still occasionally encounter clients which legacy systems which are running on very old versions of FileMaker. There are potentially lots of issues with converting files that are more than 11 years old, but here are some of the most common issues that need resolving: The most basic consideration if you have a database file of this vintage is that it isn’t possible to directly convert from v6 or earlier using FileMaker 19. You will need to use an intermediate FileMaker version (v7-11) to convert the file to the .fp7 format which 19 can then in turn convert to the .fmp12 format. FileMaker has a detailed guide on the issues and version compatibility here: http://help.filemaker.com/app/answers/detail/a_id/10571/~/converting-older-filemaker-pro-files-to-the-.fmp12-file-format Back in the FileMaker v6 days, you could only specify a password and not a login name – in converting it sets the login name to be the same as the password which obviously isn’t very secure so this will need to be changed quickly post upgrade. FileMaker 18 login names are case insensitive, but the passwords are not so it can be easy to get caught out by this. In many cases it is simplest to remove all passwords under the original version, convert and set-up the security again from scratch. Typically, since having multiple tables in a single database file wasn’t possible back in v6 and earlier, you may find you have lots of files to convert and re-set-up the login/password security across multiple files. If this is the case and you have complex security group arrangements then it is often more appropriate to set-up FileMaker Server to use Active Directory, Open Directory or the newer OAuth external authentication. Finally, external file references between files could not be directly accessed in the application in FileMaker v6 and earlier, but are exposed from FileMaker v7 onwards (File > Manage > External Data Sources in FileMaker v18). On occasions when the linked files had been re-linked, or moved between multiple machines this could result in multiple ‘paths’ being recorded to the appropriate related file. These often need clean-up post conversion so that they are set to the correct relative server location. If there are lots of incorrect/’hanging’ references to old paths then this can cause FileMaker to ‘pause’ while it times out looking for the dead link. This can significantly increase the time to open the files and lead to the perception that the Application is being unresponsive. All considered there are so many interface, calculation, scripting, and integration features that have been added to FIleMaker over the last 11 years, that we would strongly recommend re-writing a solution from scratch to benefit from all of the new technology that is available. Conversion is only a really means to an end to get your data into a format which can be readily worked on with the modern FileMaker 19 platform. By analogy why would you replace your landline telephone or ‘dum’ mobile phone of a pre-2010 vintage with a like for like device in 2020 instead of getting a current generation smart phone? The same principle applies to FileMaker. General upgrade considerations In all of the above cases, we are assuming that you have a relatively ‘vanilla’ FileMaker solution without any complex dependencies such as integrations with 3rd party software using legacy integration technology or plugins. FileMaker plugins will generally need updating to ensure compatibility with FileMaker 19 and in many cases this will be a paid for update. The syntax and functionality of plugins can change between versions, or certain features are deprecated if the core application offers overlapping functionality or similar functionality – this may mean that you will need to re-write elements of your solution scripting to use the new native FileMaker 19 technology or may need to migrate to a different plugin if the old one is no longer being actively developed. We strongly recommend that clients think seriously about how fit for purpose a legacy solution is before deciding that a simple ‘technocratic’ upgrade is an appropriate approach. Most successful businesses change their processes and focus significantly over time as well as the ecosystem of technologies that they adopt to support their workflow. In many cases, if the client has a legacy FileMaker solution that has not been updated for several years then it is usually more efficient and cost effective to consider developing a new solution from scratch which exactly fits an organisation’s modern requirements if the older system is no longer a ‘good fit’. The most obvious example of ‘fit’ is that older FileMaker systems were generally not developed with a ‘cloud-first’ or mobile mindset. For the last 3 versions of FileMaker, Claris has put a great deal of effort and resources to ensuring how well the modern platform can be used on the cloud. Equally, with the advent of JSON/REST support within FileMaker 18 onwards and the release of Claris Connect this year there are completely new opportunities to automate repetitive work by integration with 3rd party cloud solutions.
by Ben Fletcher 21 May 2020
The Claris FileMaker 19 platform is now available with a range of powerful new features that will benefit both new and existing users New in FileMaker Pro 19: JavaScri pt in a web viewer — Use readily-available JavaScript libraries or your own custom code to create modern apps. Directly embed things like maps, animated graphics, data visualization, and more. Core ML support — Run machine learning models for image classification, sentiment analysis, object detection, and more. Execute Data API script step — Requests data in JSON format from a FileMaker app hosted locally or on FileMaker Cloud or FileMaker Server. macOS Dark Mode support — FileMaker Pro displays in the appearance chosen in System Preferences. macOS Drag and drop installer — Install FileMaker Pro by dragging the application to your drive. Quick Open — Set a preference to open a specified file at start time. New in FileMaker Go 19 Core ML support — Run machine learning models on your device for image classification, sentiment analysis, object detection, and more. Support for Siri Shortcuts — Use your voice to run automations like searching for records, updating inventory, or starting a process. NFC (near field communication) tag reading — Quickly get information on tagged merchandise, navigate to a specific item in a database, or check in at a kiosk. New in Claris FileMaker Server 19 FileMaker Server for Linux — Host your apps on Linux, an industry-standard OS, for high availability and reliability. Available as a developer preview. Cards in FileMaker WebDirect — Create windows that are automatically sized and placed appropriately on the main screen. Open other windows or files without having to first close the card. Claris FileMaker Cloud 2.19 Create in cloud — Create apps directly in FileMaker Cloud from FileMaker Pro with zero configuration and deployment.  The Claris FileMaker Platform offers the ideal path to deliver modern custom apps that have been making businesses grow for decades. Using an older version of FileMaker or unsure of how to get started if you are new FileMaker? Call our team for a free initial consultation to find out more.
by Ben Fletcher 4 March 2020
Claris have now released their new cloud automation platform, Claris Connect. This represents a major evolution of Claris as a company, since the last time they had a se cond product alongside their premier FileMaker platforms was back in 2011 when they offered the entry-level Bento database product. Claris Connect is a cloud services integration automation tool - it he lps you quickly build workflows between different cloud applications with the minimum of effort. Now that cloud services have become mainstream, nearly all organisations make use of some form of cloud-based application - from Dropbox for file storage, to Shopify for e-commerce, Microsoft’s Office365 and Google’s G-Suite for email/calendaring. Historically, Claris’ FileMaker database and app platform has included support for integrating with 3rd party cloud servers via JSON/REST APIs, but such integrations are complex requiring detailed technical knowledge and robust testing approaches. Furthermore, no two APIs are completely identical and they tend to evolve over time ensuring that there is a high barrier to initially implementing an integration and maintaining them over time. Claris Connect solves this problem by offering pre-built connectors for 50+ of these cloud services with more planned for release in the next year. Integrations which would have taken days or weeks can now potentially be built in minutes or hours using Claris Connect. Since Claris Connect is itself cloud-based it can be accessed from any device with a web browser and so requires no software to install or deploy. A unique selling point for Claris Connect over competing cloud-based automation solutions is that it also offers on-premises connectors for integrating with its own FileMaker platform.  DataTherapy can provide support and consultancy for both FileMaker and Claris Connect to solve your organisation’s data and automation challenges. If you need additional information, or would like to book a complimentary initial consultation then contact our team.
by Ben Fletcher 1 March 2020
DataTherapy and FileMaker UK will be running a FREE mini business briefing focusing around FileMaker’s use within the NHS @ Apple's Hanover Street Office in London on 9t h March 2017 10:00-13:00. The schedule for this event is as follows: • 10:00 Coffee/attendee mixer to highlight areas of interest. • 10:10 Introduction: NHS Data Challenges • 10:40 Overview of FileMaker Platform and examples of current use in the NHS • 11:00 Real-world Case Study: Pathology Laboratory Information Management • 11:40 Real-world Case Study: Clinical Image Job Tracking • 12:20 Q&A • 12:50 Closing comments  Attendance is free, but places are strictly limited. If you woul d like to attend this event or future NHS FileMaker Events then contact Dr. Ben Fletcher @ DataTherapy to reserve your spot.
by Ben Fletcher 15 November 2019
The rebranding of FileMaker, Inc. to Claris International, Inc. will bring a knowing smile to the face of many long standing FileMaker Developers and Mac users that have fond memories of MacWrite and MacDraw. In 1998, Claris divested itself of all other software products it had inherited from parent Apple in order to focus exclusively on the flagship FileMaker product line hence the change of the name to FileMaker, Inc. to reinforce the importance of the move. This saw the birth of the FileMaker Business Alliance which supported the growth of both the modern FileMaker platform as well as the commercial developer community which companies like DataTherapy have participated in ever since. Now in 2019, FileMaker Inc.’s return to the Claris brand represents a nod towards both its legacy, but also to its future. Rightly, the new branding helps to frame a new chapter in the company’s direction as it focuses on cloud first products like the up coming Claris Connect - a pivotal product which bridges the gap between on premises and cloud data services. The pending release of Claris Connect in (hopefully) early 2020 marks an exciting milestone for Claris International which will be both a hugely complementary offering to existing FileMaker customers as well as being attractive to new customers that have never used the FileMaker platform before.  If you need assistance with migrating your on premises FileMaker App to cloud based hosting or if you would like the integrate with other cloud services then why not call our team for a no obligation quote. The body content of your post goes here. To edit this text, click on it and delete this default text and start typing your own or paste your own from a different source.
by Ben Fletcher 29 September 2019
If you missed the live Webinar today with DataTherapy's Ben Fletcher (@drbenfletcher) and Kieran Saunders (FileMaker) talking about FileMaker custom app deployment then you can now view the online video in your own time by registering on FileMaker.com here: http://info2.filemaker.com/NE_ANDeployyourCustomApp050517_Registration.html In the Webinar, you will learn about the following topics: • What is Deployment? • How to access your App • Determine deployment strategy • Cloud hosting providers • FM Cloud • On premises • FileMaker Server demo • Determine back-up strategy • Plan for disaster recovery
by Ben Fletcher 6 June 2019
DataTherapy are pleased to announce that FileMaker 18 managed private cloud hosting packages are immediately available. DataTherapy can provide scalable, managed FileMaker packages for businesses of all size. Full details of all of our packages can be found here: https://www.datatherapy.com/claris-platform/claris-filemaker-hosting Our data centre facility is based in London/UK and we can offer a range of a variety of enhanced options such as domain management, custom SSL certificates, VPN, VLAN, disaster recovery and integration with other technologies. 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 tea
by Ben Fletcher 28 May 2019
With the release of FileMaker 18, we’re sure that both newbies to the platform and FileMaker veterans alike will be only to pleased, to see that finally some much needed attention has been given to the file > Import dialog box which has existed without change since circa. 1986. The dialog box has been given a massive interface revamp with a much more user friendly interface and flexible options. With the new Import Field Mapping dialog box, you can: Choose target fields from a list that you can search - not more endless dragging match fields with large database tables. Choose any record in the source file to use as field names for certain import file types. For each target field, choose whether to perform auto-enter options while importing (previously this was an all or nothing option for the entire import). Import data that uses a custom character to separate field values. More conversion options – When converting certain supported file types, you can now specify a custom character that separates field values, choose any record to use as field names, choose which fields to include, and specify a target table name.  Need some assistance with writing a new FileMaker custom app or need some assistance with how to get the most out of FileMaker 18 platform? Call our team to find out more about the benefits from upgrading for a free, no obligation quotation.
by Ben Fletcher 28 May 2019
FileMaker 18 Platform has launched with a range of new features that will undoubtedly make developing new custom apps both quicker and more powerful. One area of focus f or these new features is ‘Improved usability’ and includes new features as follows:- Ability to move objects with Shift-Arrow keys – Using the Shift-Arrow keys in Layout mode now moves objects in increments 10 times larger than when using the Arrow keys. Ability to Read and write external data files – Create scripts that read, write, and manage external data files—for example, to write log files or export data in a custom file format. This is covered by a range of new file related script steps. Open files with a version-specific URL – You can now use the fmp18 scheme in URLs to open files specifically with FileMaker Pro 18 Advanced or FileMaker Go 18. The FMP URL protocol has existed for many versions now, but Windows users will be familiar with their OS perhaps defaulting to an older installed version of FileMaker for opening apps - adding this new version specific FMP URL gets around this problem quite neatly. Open a custom app upon start – You can now use the personalisation file during a command-line installation to specify a custom app to open when FileMaker Pro Advanced starts. Save files as XML – You can now save a FileMaker Pro Advanced file in an XML format that represents the schema, layouts, scripts, and other parts of the file. You can use the XML file to document changes in your custom app between versions and use standard text-based tools to compare versions.  Need some assistance with how to take advantage of these new features of the FileMaker 18 Platform? Call our team to find out more about the benefits from upgrading for a free, no obligation quotation.
by Ben Fletcher 28 May 2019
FileMaker 18 has launched with a range of new features that will undoubtedly make developing new custom apps both quicker and more powerful. As we would expect, given th e modern focus on security and data privacy this has been significiantly . With the new Manage Security dialog box, you can: Work with an account access list filtered by account type, assign privilege sets to users and groups directly in the list, and perform other common tasks in the details pane without leaving the list. Manage privilege sets, extended privileges, and file access in the Advanced Security Settings dialog box. See whether the selected authentication type is supported on the file's current host. Privilege to manage accounts that don't have full access – You can now grant users the limited ability to create and delete access to a file and assign existing privilege sets without allowing them to modify groups or users that have the Full Access privilege set or create or edit privilege sets. See Editing other privileges. New to File Maker 18 Platform: Unsigned plug-in notification – FileMaker Pro Advanced notifies you when a plug-in has not been digitally signed by its developer. Full access required by default to reference a file – The option to require the Full Access privilege set to use  references to a file is now enabled by default in newly created files. The option is unchanged in existing files. New functions for digitally signing data have been added to allow you to digitally sign data and verify signatures of signed data with cryptographic keys. Need some assistance to take advantage of these new security features of the FileMaker 18 Platform or review the current security arrangements in your existing app? Call our team to find out more about the benefits from upgrading for a free, no obligation quotation.
by Ben Fletcher 28 May 2019
One of the most significant enhancements in the FileMaker 18 Platform is the array of new script steps related to external data files. These include ‘Create Data File’, ‘Open Data File’, ‘Write to Data File’, ‘Read from Data File’ and ‘Close Data File’. This ability to read and write to external data files is great new addition to an already strong FileMaker platform, and one for which we envisage a number of useful applications: in FileMaker 17 and earlier has always been possible to export database data to files in tab separated values, comma separated values, DBF, Merge, HTML table, XML and Excel formats. ‘Live’ database data can be queried via Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC) and also https/JSON with the new FileMaker Data API.  So how is this different from the existing features and why is it needed? Firstly, all of the above methods, only allow for the export and transfer of data which is already within a database table structure. If you wanted to capture debugging information or create a new export then the first step would be to have to create the database structure necessary to store the information and then script to export it. If the information is transient then you may also then need to write maintenance routines to ‘prune’t or delete this information. With the new script steps, data can be captured directly to a variable and this variable is then written to the external data file - no new structure needed, making the code potentially simpler and more portable. This is really helpful when for example, you are writing debugging routines or persistent error logs to be saved on your server at timed intervals.. Secondly, there are many cases where you might want to transform data structure and then export it into another format. I can think on many occasions where I wanted create a simple XML export without having to write XSLT to achieve this quickly. Similarly, it could be used for local dumps of data to JSON or SQL formats for example. This feature is not without its limitations. FileMaker is limited to writing 64MB of data at a time with the Write to File script step and so for large scale exports it will be necessary to parcel out the writes into 64MB chunks.
by Ben Fletcher 23 May 2019
FileMaker 18 has launched with a range of new features that will undoubtedly make developing new custom apps both quicker and more powerful, but what are the benefits of upgrading if you are currently using an older version of the FileMaker platform? Using a version of FileMaker older than v15? In that case there are even more good reasons to upgrade - contact our team to find out more about the benefits from upgrading that you have been missing out on!  Highlighted below are some of the key differences in features were introduced between FileMaker v15, v16, v17 and now v18 releases