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.