Release notes for version 13.1 - 7th March 2023

New functions in 13.1 and Announcement in blog.

• Added 45 new functions for XL functions to work on form controls and XL.Sheet.FormControlCount function.
• Added Archive.Create, Archive.AddContainer, Archive.AddFile, Archive.AddText and Archive.Close functions.
• Added Audit.BaseTableNameForID function.
• Added ContinuityCamera.CanImport and ContinuityCamera.HasPopupMenu functions.
• Added dot as valid character for field names for syntax coloring.
• Added DynaPDF.ChangeNamedDest function.
• Added DynaPDF.CreateStructureTreeEx function.
• Added DynaPDF.SaveAndSignFileExt1 and DynaPDF.SaveAndSignFileExt2 functions to sign a PDF using external PKCS7 signature provider.
• Added flag 32 for Text.TextToHTML function to use paragraphs.
• Added flags parameter to Matrix.Text function and a flag for Matrix.CSV and Matrix.Text to include column names in first row.
• Added FM.TextWithDataType function.
• Added iOSApp.AddSwipeGestureRecognizer and iOSApp.ClearSwipeGestureRecognizer functions to recognize a swipe gesture on your layout.
• Added JavaScript.LoadLibrary and JavaScript.Available functions.
• Added MongoDB.Command, MongoDB.AggregateDatabase and MongoDB.AggregateCollection functions.
• Added MongoDB.GetOptions, MongoDB.GetTLS and MongoDB.SetDatabase functions.
• Added PDF/UA-1 for DynaPDF.SetPDFVersion function.
• Added PKCS12.SignData function.
• Added Plugin.IsMaintenanceExpired function.
• Added Plugin.State function.
• Added Process.GetDllDirectory and Process.SetDllDirectory functions.
• Added Queue Length parameter for WebHook.Listen function.
• Added shouldPrintBackgrounds parameter for WebView.SetPrintParameter for use in WebKit 1 and 2.
• Added shouldPrintBackgrounds to WebView.SetPreferences and WebView.GetPreferences for WebKit 2 to control printing of backgrounds.
• Added support for JavaScriptWebKit functions to work on Windows and Linux if you provide a JavaScriptEngine library file to load.
• Added SyntaxColoring.ScriptSearchBox.GetRegEx and SyntaxColoring.ScriptSearchBox.SetRegEx functions.
• Added Windows support for Clipboard.SetPDF and Clipboard.GetPDF functions.
• Added Windows support for Container.ReadImage and Container.ReadImageFile functions to e.g. load HEIF/HEIC files on Windows.
• Added WindowsML.List function.
• Added WindowsOCR functions.
• Added WindowsUserNotification.List function.
• Added WindowsUserNotification.SetExpiresOnReboot and WindowsUserNotification.GetExpiresOnReboot functions.
• Added WindowsUserNotification.SetExpiresOnReboot and WindowsUserNotification.GetExpiresOnReboot functions.
• Added WindowsUserNotification.SetGroup and WindowsUserNotification.GetGroup functions.
• Added WindowsUserNotification.SetNotificationMirroring and WindowsUserNotification.GetNotificationMirroring functions.
• Added WindowsUserNotification.SetPriority and WindowsUserNotification.GetPriority functions.
• Added WindowsUserNotification.SetRemoteId and WindowsUserNotification.GetRemoteId functions.
• Added WindowsUserNotification.SetSuppressPopup and WindowsUserNotification.GetSuppressPopup functions.
• Added WindowsUserNotification.SetTag and WindowsUserNotification.GetTag functions.
• Added XL.Book.IsWriteProtected, XL.Sheet.DefaultRowHeight, XL.Sheet.GetTabColor, XL.Sheet.GetTabColorRGB and XL.Sheet.SetDefaultRowHeight functions.
• Added XL.Sheet.AddSelectionRange, XL.Sheet.GetActiveCell, XL.Sheet.RemoveSelection, XL.Sheet.SelectionRange and XL.Sheet.SetActiveCell functions.
• Adjusted various internals for future FileMaker versions.
• Applied SQLAPI patch for Oracle fix in memory leak.
• Changed all SystemInfo functions to be free to use without license.
• Changed CURL.SetOptionPassword function to not show password in log.
• Changed plugin to ignore Registration calls with older keys if a newer license was already set to avoid complaining dialogs when opening older solutions.
• Changed script search to do regular repressions (opt-in via preferences dialog).
• Changed search field for relationship graph on Windows to be a combo box.
• Changed SQL functions to log SQL statements when trace is active.
• Deprecated PHP functions.
• Deprecated SystemInfo.isLeopard, SystemInfo.isSnowLeopard, SystemInfo.isLion and SystemInfo.isMountainLion.
• Deprecated SystemInfo.isWindows2000, SystemInfo.isWindowsXP, SystemInfo.isWindowsVista and SystemInfo.isWindows7.
• Deprecated SystemInfo.WinCSDVersion and SystemInfo.WindowsAero functions.
• Deprecated SystemInfo.WinServicePackMajor and SystemInfo.WinServicePackMinor functions.
• Deprecated WebView.Cookies.Count and WebView.Cookies.Query in favor of WebView.AllCookies function.
• Disabled FTP access in libxml to avoid unintended network access.
• Enabled the WindowsML functions again for the public release.
• Fixed a bug in MongoDB.ChangeStreamErrorDocument, MongoDB.ChangeStreamResumeToken and MongoDB.NextChange functions.
• Fixed a bug with library loading for aarch64 on Linux for libusb, libidn2, libiconv and libldap.
• Fixed a crash in JSON.ToHTML function.
• Fixed a crash in trace function.
• Fixed a link error in the simulator plugin for Apple Silicon which prevented it from loading when used in newer iOS SDK versions when using newer Xcode version.
• Fixed a problem loading iconv on Linux.
• Fixed a problem with Container.ReadImage function returning error about NSRange being wrong.
• Fixed a problem with CURL.SetProgressScriptName causing a crash when transfer went too fast.
• Fixed a problem with export dialog tooltips not showing when using the script step.
• Fixed a timing crash with option click on Set Field in newer FileMaker Pro being too quick.
• Fixed Clipboard.SetPicture to better pass transparency.
• Fixed CURL.GetProgressFileName and CURL.GetProgressScriptName functions.
• Fixed FM.SQL.InsertRecords, FM.SQL.InsertRecordsToSQL, Matrix.InsertRecordsToSQL and Matrix.InsertRecords to quote the table name for the SQL used internally.
• Fixed JavaScript.New to work on iOS again.
• Fixed problem in Barcode.Generate and Barcode.GenerateJSON functions, where a warning from the zint library would be treated as an error.
• Fixed relationship graph search box not showing in Dutch.
• Fixed ScreenshotRect, Container.Screenshot and WebView.Screenshot for Windows to better use right DPI for high DPI screens.
• Implemented local Hotkeys for Windows. So if HotKey.Register is passed Local = 1, we run a different code path to monitor keyboard instead of registering global hotkey.
• Implemented Vision.RecognizeText for Windows using WindowsOCR functions.
• Implemented WebView.AllCookies and WebView.PrintToFile for Windows.
• Improved Clipboard.GetPicture to take JPEG, PNG or GIF directly from the clipboard if available. Falls back to bitmap if that is not available.
• Improved Clipboard.SetPicture to put PNG on the clipboard in addition to a bitmap for applications, that can read PNG forever.
• Patched SQLAPI to work again with Field() query without FetchNext.
• Rewrote the WindowsUserNotification functions.
• Updated CURL library to version 7.88.1.
• Updated DynaPDF to version 4.0.72.208.
• Updated DynaPDF.GetBookmark and DynaPDF.GetBookmarksAsJSON functions to return Action and NamedDest properties.
• Updated LCMS2 library to version 2.15.
• Updated LibXL to version 4.1.
• Updated libxml to version 2.10.3.
• Updated openssl library to 1.1.1t.
• Updated SQLite to version 3.41.0.
• Updated tiff library to version 4.5.0.

New in version 13.0  

More details in the Release notes and Announcement in blog.