This release allows you to connect from FileMaker directly to MongoDB. Based on the open source Mongo driver we defined over 50 functions. You can connect, run queries, insert, update and delete records. Since the NoSQL Mongo database stores JSON documents in collections, our functions pass and return JSON. We support transport encryption and compression as well as multiple connections. Free your mind and enjoy a new way to store and retrieve data without a fixed table schema!
DynaPDF can now output PDF/X 5 and 6. We can now set date and time format for fields and change the bounding box for a template. When setting fonts, we now default to unicode code page unless you specify otherwise.
Our Vision.RecognizeText function to extract Live Text on macOS and iOS can now handle PDF documents in addition to images. Use SystemInfo.isVentura function to detect the upcoming macOS version.
We added a new way to handle errors in scripts. Our plugin can collect all plugin made errors in a log and provide the list to you as JSON with ErrorLog function. Add your own entries via AddToErrorLog function. Used in a one-time loop, you can do a try/catch exception handling like in other development tools.
In Audit, we can now handle timestamps as numbers with Audit.SetDateAndTimeAsNumbers function. This avoids problems with users in different locales using conflicting date and time formats. The SQL functions now explicitly allow MariaDB as client. The SerialPort.List function now returns more details on Windows with mode 2.
We added TOTP.Calculate function for time-based one-time-passwords calculated in FileMaker to calculate the second factor for logins. The new FM.VariableLookup and SharedMemory.LookupValue functions help to access global variables and return empty result when they are not defined. We updated our OCR functions to support for tesseract in version 5.1.
For macOS we got a few new features for the Script Workspace. First you can put comments into a comment line. When our plugin sees the URL there, we add a button on the right side of the script to open the URL in the browser. Connect directly to your Wiki, documentation or link to other FileMaker files. Enable this feature via preferences dialog or SyntaxColoring.CommentLinks.SetEnabled function.
The script list on the left in the Script Workspace can now be sorted alphabetically via our contextual menu. Select a few scripts and sort them ascending or descending. We improved syntax highlighting to work with more characters and our variable check can now better recognize Perform Script (on Server) and Install OnTimer Script script step. In the dialog to manage layouts, you can now find duplicates via our contextual menu.
Finally we updated CURL to version 7.84.0, DynaPDF to 188.8.131.52, SQLAPI to 5.2.1, LibXL to 4.0.4 and Xcode to version 13.4.
See release notes for a complete list of changes.