Release notes for version 14.0 - January 2024
New functions in 14.0 and Announcement in blog.
14.0 - 16th January 2024
- Added a Search Scripts example file to allow you searching your Script Workspace on Windows (and macOS) with the F8 hotkey.
- Added caching for variable check to improve performance for longer scripts.
- Added CaseSensitive flag for List.FindDuplicateItems, List.HasDuplicateItems, List.RemoveDuplicateItems, QuickList.FindDuplicateItems, QuickList.HasDuplicateItems, QuickList.RemoveDuplicateItems.
- Added checks for SQL functions in multiple places to avoid crashes if SQL command text is empty.
- Added CNContactStore.ContactsMatchingURL function.
- Added Command-+ and Command-- as keyboard shortcuts for calculation fields to directly adjust font size.
- Added command-J to format text as JSON in a text view, e.g. in data viewer result.
- Added Command-Option-Cursor key shortcuts for relationship graph on macOS to align items.
- Added Command-Option-Shift-Cursor key shortcuts for relationship graph on macOS to resize items to smallest/biggest size.
- Added Command-Shift-G for find bar to find previous match.
- Added Container.IdentifyData, Files.IdentifyData and Text.IdentifyData functions.
- Added CSS parameter for Matrix.HTML function.
- Added curl triggers for success and failure: CURL.GetFailedEvaluate, CURL.GetFailedFileName, CURL.GetFailedScriptName, CURL.GetSucceededEvaluate, CURL.GetSucceededFileName, CURL.GetSucceededScriptName, CURL.SetFailedEvaluate, CURL.SetFailedScript, CURL.SetSucceededEvaluate, and CURL.SetSucceededScript.
- Added CurrentTimeUTCMicroseconds for Audit as possible field.
- Added CurrentTimeUTCMicroseconds for our get function links.
- Added DynaPDF parser functions: DynaPDF.Parser.ChangeAltFont, DynaPDF.Parser.Create, DynaPDF.Parser.DeleteText, DynaPDF.Parser.ExtractText, DynaPDF.Parser.FindText, DynaPDF.Parser.Line, DynaPDF.Parser.ParsePage, DynaPDF.Parser.ReplaceSelText, DynaPDF.Parser.SetAltFont, DynaPDF.Parser.TextMatrix, DynaPDF.Parser.WriteToPage.
- Added DynaPDF.GetFullyQualifiedFieldName function.
- Added flags for List.BestMatch and QuickList.BestMatch to use Jaro-Winkler distance optionally and optionally return list of top 5.
- Added FM.SQL.ToMatrix function.
- Added FullyQualifiedFieldName as new field for DynaPDF.GetFieldAsJSON and DynaPDF.GetFieldAsJSON results.
- Added JSON.JSONPatch.ApplyPatch, JSON.JSONPatch.FromDiff, JSON.MergePatch.ApplyPatch and JSON.MergePatch.FromDiff functions.
- Added links to syntax coloring goodies from help pages.
- Added List.Shuffle and QuickList.Shuffle functions.
- Added Math.Random.ExponentialDistribution, Math.Random.NormalDistribution and Math.Random.PoissonDistribution functions.
- Added Matrix.IndexOfFirstValueMatching function.
- Added more Phidgets examples.
- Added new parameter for Archive.AddContainer, Archive.AddFile and Archive.AddText to pass a timestamp to use.
- Added Phidget.DisableServerDiscovery and Phidget.EnableServerDiscovery functions.
- Added Phidget.GetTag and Phidget.SetTag functions.
- Added QuickList.Release function as new name for QuickList.Free. Old name stays valid.
- Added Reset Colors button to the preferences dialog.
- Added SyntaxColoring.GetCodeFoldingEnabled and SyntaxColoring.SetCodeFoldingEnabled function.
- Added XL.FormControl.JSON function.
- Added XML.ToHTML function.
- Changed DynaPDF.FontInfo to return numbers for FontBBox as list of values with numbers.
- Changed FM.DeleteRecords to return OK if no record was found.
- Enabled Folders.UserDownloads to work in iOS.
- Fixed a bug for comment links which prevented them from working in older macOS versions.
- Fixed a problem in Matrix.CopyRow when using row names.
- Fixed a problem with custom web viewer to show PDF documents.
- Fixed a problem with Get function links and non breaking space.
- Fixed a problem with ImageView.CreateWithSize not working properly on macOS.
- Fixed a problem with int32 read as string in SQL functions.
- Fixed an edge case with auto complete of variables causing an exception.
- Fixed an edge case with Path.LastPathComponent to return last path name, even if a slash is on the end of the path.
- Fixed an endless loop in JSON.Search function with a bad query. Now propergates the error properly.
- Fixed an issue where calculation coloring would run, even when it was disabled.
- Fixed an issue with auto completing underscore prefixed local variables.
- Fixed AppleScript.Compile to clear last error for AppleScript.LastErrorMessage function.
- Fixed control placing on iOS to find layout view for a card window.
- Fixed copy variables command to not limit it to 500 lines.
- Fixed CURL.SetupAWS and CURL.SetupOAuth to reset NoBody flag if new transfer is not head.
- Fixed DynaPDF field functions to try different field structure sizes, if the DynaPDF DLL is much newer/older than our plugin and prevent errors about different structure sizes.
- Fixed Events.Item.GetCalendar function to not always return JSON.
- Fixed ListDialog functions to not use column widths if you have only one column.
- Fixed WebView.InstallUserMediaAccess to not return error when called a second time.
- Fixed window functions for future FileMaker version, e.g. affect Printer.Print.
- Implemented Time.Parse for Windows.
- Improved animation for ProgressDialog functions on macOS.
- Improved comment links with script: scheme to use script IDs in addition to names.
- Improved format button to handle <=, >= and <> correctly. But you can also use ≤, ≥ or ≠ of course.
- Improved handling of arrays for our JSON to HTML conversion in JSON.ToHTML function.
- Improved performance for newer JSON functions.
- Improved preferences dialog to not show Touch Bar ESC feature if you don't have a Mac with a Touch Bar.
- Improved script coloring to better read script lines.
- Improved SyntaxColoring.FactoryDefaults function to reset both dark and light colors.
- Improved XL functions for form controls to take name of control in addition to index.
- Removed support for Claris Pro/Server.
- Rewrote DynaPDF.ExtractDocumentText using newer DynaPDF.ExtractText function internally.
- The comment links to scripts can now recognize option key to open script in new window.
- Updated CURL to version 8.5.0.
- Updated DynaPDF to version 4.0.82.239.
- Updated for future FileMaker version.
- Updated openssl library to version 3.1.4.
- Updated SQLAPI to version 5.3.0.
- Updated SQLite to version 3.44.1.
- Updated to LCMS 2.16.
- Updated to Xcode 15.2.
- Updated Visual Studio to version 2022.
New in version 13.5 New in version 14.1
More details in the Release notes and Announcement in blog.

