Version history:

Release notes for version 15.2 - 6th May 2025

New functions in 15.2 and Announcement in blog.

15.2 - 6th May 2025

• Added AbortProc and an event processing loop to DynaPDF printing to help with updating a progress dialog.
• Added Audit.GetAuditLogTableName and Audit.SetAuditLogTableName functions.
• Added Audit.SetUUIDFields and Audit.GetUUIDFields function.
• Added CURL.SetOptionTCPKeepCount and CURL.SetOptionUploadFlags functions.
• Added DynaPDF.ReadImageFormatFile and DynaPDF.ReadImageResolutionFile function to inspect images files on disk.
• Added DynaPDF.RenderJob function.
• Added DynaPDF.SetBidiMode and DynaPDF.GetBidiMode functions.
• Added ExtensionFilter parameter to Files.ListRecursive function.
• Added flag 128 for matching substring with the ExtensionFilter parameter for the Files.List, Files.ListAsJSON and Files.ListRecursive functions.
• Added Folders.UbiquityContainer function.
• Added JSON.ToCSV function.
• Added ListDialog.GetCancelButtonValue, ListDialog.GetOtherButtonValue and ListDialog.GetSelectButtonValue functions.
• Added ListDialog.SetCancelButtonValue, ListDialog.SetOtherButtonValue and ListDialog.SetSelectButtonValue to set what value is returned by ListDialog.ShowDialog function.
• Added ListDialog.SetOtherButtonNeedsSelection and ListDialog.GetOtherButtonNeedsSelection functions.
• Added ListDialog.SetSwapButtons and ListDialog.GetSwapButtons functions.
• Added MapView.GetWindow function.
• Added more Python functions to query time and library information.
• Added PremulAlpha as a possible raster flag for DynaPDF.RenderPage, DynaPDF.RenderPDFFile and DynaPDF.RenderPDFFileEx functions.
• Added ScriptWorkspace.IsFocusOnScriptList and ScriptWorkspace.SetFocusToScriptList functions.
• Added shortcuts to calculation dialog to pick return type just like field types.
• Added Variable.AppendJSON and Variable.PopJSON functions.
• Added Variable.AppendValue and Variable.PopValue functions.
• Added Variable.ValueCount function.
• Added XL.Sheet.AddTable to add a table to a sheet.
• Added XL.Sheet.SetBorder to set border fo sheet.
• Changed Container.GetHex to have name or index parameter optional.
• Changed shortcut to show invisibles in calculation dialog to using command-option-I.
• Changed shortcut to show ruler in calculation dialog to using command-option-R.
• Changed tooltips for fields to use FieldType() instead of SQL for better performance.
• Changed tracing to log time with start script if Trace.SetWithTimes function.
• Enabled MBS Auto complete for more specify file dialogs, so we can auto complete variable for file paths.
• Fixed a bug in DuckDB client for SQL functions.
• Fixed a bug in DynaPDF.PageStatistics function, so it works on the last page of the document.
• Fixed a bug in Path.LastPathComponent function where the last character got cut off.
• Fixed a bug in Process.GetCurrentDirectory function.
• Fixed a problem with linux and endless loop with BeginLayer function in DynaPDF.
• Fixed an error in XL.Sheet.SetProtectEx function parsing the protection flags.
• Fixed an issue with Audit.BuildCaches function missing the FieldName.
• Fixed an issue with ListDialog.AddSQL function where filename parameter was ignored if no other parameters followed.
• Fixed Archive.Compress to better compress folder itself if file list is empty.
• Fixed link detection to work again in calculations.
• Fixed SQL.ConvertDateTimeFromSQL to return empty result if the date value is not valid.
• Fixed SSH2 library for Windows to use OpenSSL instead of Windows API again. Broken in last release.
• Fixed XL.CopyCellValue, XL.CopyColumn and XL.CopyRow to work if second document has more sheets.
• Implemented a maximum for sockets. Now limited to 1000 concurrent sockets to avoid crashing FileMaker when running out of file handles.
• Implemented text selector for ScriptWorkspace.StyledScriptText function.
• Improved Archive.Compress to compress folder itself if file list is empty.
• Improved auto complete to work better with XL functions.
• Improved Bonjour functions to cleanup threads better.
• Improved Container.GetBase64 to work better if you don't specify a name or index.
• Improved exceptions handling for GraphicsMagick functions.
• Improved functions like Container.ReadFile to return empty result if file size is zero.
• Improved ListDialog.SetOtherButtonEvaluate and ListDialog.SetOtherButtonLabel to allow three other buttons.
• Improved OCR error messages about missing functions to show the function name. you may see such an error if you have an older tesseract or leptonica library, which doesn't contain the functions we look for.
• Improved PDFKit.SelectPrinter to return an error when we fail to create the dialog.
• Improved performance of DynaPDF generating previews for container values for large files.
• Improved showing IDs for Database Design dialog to not rebuild cache for new fields.
• Improved the If/Loop highlighting to also highlight Enter Find Mode and Perform Find.
• Moved FM.Variable* functions into Variable.*. The old names stay valid.
• Rewrote parts of TOTP.Calculate function, broken with Xcode upgrade.
• Updated CURL library to version 8.13.0.
• Updated DynaPDF to version 4.0.100.285.
• Updated expat library to version 2.7.1.
• Updated libarchive to version 3.7.9.
• Updated LibXL to version 4.6.
• Updated plugin SDK.
• Updated Saxon library to 12.6.
• Updated SQLAPI to version 5.3.6.
• Updated to Xcode 16.3 with the newer clang and stdc++ library.
• Upgraded NSAttributedString handling to better work with postscript font names. This affects Clipboard.SetStyledText, Clipboard.GetStyledText and other functions on macOS using styled text.

Release notes for version 15.1 - 11th March 2025

New functions in 15.1 and Announcement in blog.

15.1 - 11th March 2025

• Added an OutputJSON option to the JSON for Barcode.GenerateJSON function to output drawing commands as JSON.
• Added AvailabilityExpression parameter to SyntaxColoring.AddContextMenuCommand function.
• Added check for menu sorting to not do it when a dialog shows.
• Added CNContactStore.ChangeHistory function to better track changes in contacts database.
• Added CNContactStore.GetTransactionAuthor and CNContactStore.SetTransactionAuthor functions.
• Added DynaPDF.CustomerID function.
• Added ECKey.BuiltInCurvesJSON function.
• Added ECKey.CurveNameToID function.
• Added ECKey.ES256Sign and ECKey.ES256Verify.
• Added Files.ShareFile function.
• Added Files.ShowPropertyDialog function for Windows to show a property dialog of a file.
• Added flag 2048 for JSON.Import and XML.Import functions to check field types and convert number, time, date and timestamp if needed.
• Added flags MediaBox and CropBox to DynaPDF.Parser.ExtractText, DynaPDF.ExtractText and DynaPDF.ExtractDocumentText.
• Added link detection for calculations.
• Added List.RemoveValues and QuickList.RemoveValues functions.
• Added mitigation against buffer overflow in Windows for snprintf function.
• Added Plugin.LimitToFile function.
• Added preferences option to toggle whether auto complete for custom functions shows parameters.
• Added Python.AddSysPath function.
• Added RoundHighlightAP flag to DynaPDF.SetGStateFlags function.
• Added Saxon example to validate the ZUGFeRD, Factur-X or X-Rechnung invoice.
• Added Saxon example to visualize electronic invoices in UBL, ZUGFeRD, Factur-X or X-Rechnung format.
• Added Saxon.SetLicense and Saxon.ClearLicense function.
• Added SendMail.GetUse8BitMime and SendMail.SetUse8BitMime functions.
• Added SendMail.GetUseSSL and SendMail.SetUseSSL functions.
• Added SyntaxColoring.AutoCompleteCustomFunctionsParameters.GetEnabled and SyntaxColoring.AutoCompleteCustomFunctionsParameters.SetEnabled functions.
• Added SyntaxColoring.SortMenuEntries.GetEnabled and SyntaxColoring.SortMenuEntries.SetEnabled functions.
• Added SyntaxColoring.TurnErrorsBlue.SetEnabled and SyntaxColoring.TurnErrorsBlue.GetEnabled functions to help colorblind people to read errors in debugger.
• Added Text.SplitByLength function.
• Added timeout parameter to ImageCapture.RequestScan function.
• Added useProgressDialog flag for DynaPDF.Print to tell the plugin to update the progress dialog while printing.
• Added WebView.ClearPrintParameters function.
• Added WebView.List function.
• Added workaround for a bug in Plugin SDK for returning text in UTF-16 back to FileMaker.
• Changed SerialPort.Resume and SerialPort.Clear to allow script trigger.
• Changed XL functions to accept letters for column parameters.
• Enabled EXSLT extensions for XML.ApplyStylesheet.
• Fixed a problem with a mutex deadlock OCR functions cleaning up on server scripts.
• Fixed a problem with our Audit Cache not finding a table because the query was case sensitive.
• Fixed a problem with WebView.PrintToFile not passing paper height correctly.
• Fixed a problem with XML.GetPathValue function crashing with name spaces, broken in 15.0.
• Fixed an issue with SerialPort function where script trigger would not be reset if you read zero bytes.
• Fixed CNContact.Value function to return empty value for birthday if there is none, instead of an error.
• Fixed memory issue for SyntaxColoring.AddContextMenuCommand causing crashes.
• Fixed Phidgets functions to not leak some JSON objects when using script triggers.
• Fixed search field in script workspace to scroll horizontally as you type.
• Fixed WebView.SetPrintParameter to use points in 72 dpi instead of inches for paper size and margins.
• Implemented keep alive for MQTT feature in CURL functions. Use CURL.SetOptionUpkeepIntervalMS function to enable.
• Improved auto complete for custom functions to show parameters when you type on end of line.
• Improved CNContactStore.SetChangeScript to deliver when no script is running and not too often.
• Improved CURL.GetResultAsGIF, CURL.GetResultAsJPEG, CURL.GetResultAsPDF and CURL.GetResultAsPNG to return empty if the data is not the expected type.
• Improved List.RegExMatch and QuickList.RegExMatch to take options in text form in addition to integers.
• Improved Menu.PopUp to report an error if the item for the positioning is not in the menu.
• Improved SerialPort.SetBaudRate to not try to change if the baud rate if the old and new rate are the same.
• Improved SyntaxColoring.AddContextMenuCommand to add entries to the menu, if you have a spelling suggestion.
• Improved SyntaxColoring.AddContextMenuCommand to better detect layout vs. browse mode.
• Improved Text.ReadTextFile to read things from /proc/ folder on Linux.
• Improved XML.Canonical, XML.Compact, XML.Format and XML.Colorize functions to return empty text for empty output.
• Removed dependency to CXXABI_1.3.13 for Linux, introduced in 15.0.
• Removed old tesseract 3 from the Linux plugin as it conflicted with tesseract 5 and we could not have both together.
• Tuned auto complete in custom functions to be less aggressive.
• Updated CURL library to version 8.12.1.
• Updated DynaPDF to version 4.0.98.278.
• Updated for next FileMaker version.
• Updated jsoncons library to version 1.3.0.
• Updated lcms library to version 2.17.
• Updated OpenSSL to version 3.3.3.
• Updated png library to version 1.6.47.
• Updated SQLite to version 3.49.1.

Release notes for version 15.0 - 14th January 2025

New functions in 15.0 and Announcement in blog.

15.0 - 14th January 2025

• Added ImagePlayground functions for macOS Sequoia.
• Added Saxon functions (Preview) to do XSLT, XQuery and XPathQuery in FileMaker.
• Added a sort feature to the plugin for the Show Window list.
• Added Archive.IsOpen function.
• Added Audit.GetIgnoreEmptyFieldsForCreate and Audit.SetIgnoreEmptyFieldsForCreate functions.
• Added Barcode.Version function.
• Added checkbox for custom functions autocomplete.
• Added DataRate as property name for Phidget.SetProperty function.
• Added Dialog.SetKeyEquivalent and Dialog.GetKeyEquivalent functions for macOS to control key equivalents for dialog buttons.
• Added DoBlanksForEmptyText parameter to XL.Sheet.CellWriteTexts function.
• Added DragDrop.GetPathList function.
• Added DynaPDF.CheckEmbeddedFileCheckSum function.
• Added DynaPDF.ConvToFreeTextCallout function.
• Added DynaPDF.DeleteOutputIntent function.
• Added DynaPDF.GetLastTextPosXAbs and DynaPDF.GetLastTextPosYAbs functions.
• Added FileNames parameter for Plugin.LimitFunction function.
• Added flags parameter for Files.AudioTags to request dumping all ID3v2Tags.
• Added formatDescription as selector for AVAsset.TrackInfo to query format description information.
• Added JSON.SetVariables and JSON.ClearVariables.
• Added MinDataInterval, MaxDataInterval, DataRate, MinDataRate, MaxDataRate and isOpen as property names for Phidget.GetProperty function.
• Added more parameter checks for MongoDB functions.
• Added our field picker extension to another field picker dialog in FileMaker, which you see when you duplicate a portal and reassign the fields. This dialog also now gets tooltips for fields.
• Added Plugin.LibExpatVersion function.
• Added Process.LoadFramework function.
• Added Shell.SetMergeErrorAndOutput and Shell.GetMergeErrorAndOutput functions.
• Added StoreKit.LastError function.
• Added StoreKit.SetRequestFailedTrigger function to set a script trigger for an error.
• Added SyntaxColoring.AutoCompleteCustomFunctions.GetEnabled and SyntaxColoring.AutoCompleteCustomFunctions.SetEnabled functions.
• Added Unit parameter to Screen.Height, Screen.Left, Screen.Top and Screen.Width functions.
• Added UTF-8 validation checks to WordFile functions to avoid creating invalid word files with invalid text.
• Added VolumeUUID to Files.DiskInfo function for macOS, iOS and Windows.
• Added XL.Book.GetCoreProperty and XL.Book.SetCoreProperty functions.
• Added XL.Book.RemoveAllCoreProperties and XL.Book.RemoveAllPhonetics functions.
• Added XL.Sheet.ColFormat and XL.Sheet.RowFormat functions.
• Changed custom function auto complete to not add bracket for function name if you are not at the end of the text.
• Changed functions returning CURL errors to mark this as error, so IsError function returns true. This affects CURL.Perform, CURL.FormClear, CURL.FormFinish, CURL.Upkeep, CURL.SendText, CURL.SendData, CURL.PerformAsync, CURL.WebSocketSend, CURL.WebSocketReceive, CURL.SetSocketNonBlocking, CURL.SetSocketNonBlocking, SendMail.PrepareCURL and various CURL.SetOption functions.
• Changed Script ID column for script workspace to be wider and allow more digits to show.
• Changed syntax coloring to keep gray lines gray, broken in 14.5.
• Deprecated Calendar functions. Please move to Events functions.
• Fixed a problem where our mutex handling for DynaPDF would log warnings.
• Fixed a problem with CGImageSource.SetProperty function not passing floating point numbers in automatic mode.
• Fixed a problem with Container.IdentifyData not recognizing a HEIF file.
• Fixed a problem with font handling for XL functions.
• Fixed a problem with text encoding being wrong in an error message with GMImage.WriteFile.
• Fixed a timing problem with DragDrop functions for macOS where not all paths arrived when you had a lot of files.
• Fixed an insufficient escaping for JSON.SortWithEvaluate function, which sometimes caused an internal error and prevented sorting.
• Fixed an issue where custom function auto complete would show Get multiple times.
• Fixed an issue with Path.NativePathToFileMakerPath on Linux adding an extra / to the path.
• Fixed crash in DuckDB client for SQL functions.
• Fixed DynaPDF.GetEmbeddedFile to return checksum as Hex string.
• Fixed Path.AddPathComponent function for Windows to automatically use slash or backslash depending on what the path has already.
• Fixed RSA.Verify function to work better reading private key.
• Improved auto complete for custom functions to delay suggestions, so you can type better without using auto complete.
• Improved auto complete for custom functions to show MBS FileMaker Plugin names.
• Improved code formatting to better handle listings with [] lines like in JSONSetElement.
• Improved JSON.SetVariables and XML.SetVariables functions to work better with multi line texts.
• Improved Math.FormatNumber function to work better with 11 or more digits.
• Improved menu sorting to ignore bracket on the beginning.
• Improved overlay to allow moving window with webviewer for macOS.
• Improved stack printing for Windows to help debugging issues.
• Improved SyntaxColoring.AddContextMenuCommand function to allow them to show in browse and layout mode.
• Improved SystemInfo.OSVersionString to better recognize Windows Server 2019 and newer.
• Improved Time.Format function to return empty result for empty timestamp.
• Improved WordFile.GetProperty and WordFile.SetProperty to work on custom and app properties, too.
• Improved XML.SetPathValue to not create duplicate nodes when finding them using namespaces.
• Increased the column width for script IDs so you see more digits.
• Tuned auto complete for custom functions to not make suggestions when entering brackets.
• Tuned custom function auto complete to not interfere with command-a.
• Tuned formatting of calculations to break behind and/or for long lines.
• Updated curl library to version 8.11.1.
• Updated DynaPDF to version 4.0.96.273.
• Updated expat library to version 2.6.4.
• Updated for future FileMaker version.
• Updated LibXL to version 4.5.0.
• Updated mongo-c-driver library to version 1.29.1.
• Updated plugin for Linux to work from Ubuntu 16 to 24.
• Updated ShowURL function for iOS to work again in newest iOS SDK version.
• Updated SQLAPI to version 5.3.5.
• Updated SQLite to version 3.47.2.
• Updated ssh2 library to version 1.11.1.
• Updated taglib to version 2.0.2.
• Updated to Xcode 16.2.
• Updated zlib to version 1.3.1.
• Updated zxing library to version 2.3.
• When logging that you have a ton of objects, we now list the object type and script name.

Release notes for version 14.5 - November 2024

New functions in 14.5 and Announcement in blog.

14.5 - 12th November 2024

• Added Overlay.AddWebViewer function.
• Added Barcode.DetectAsJSON function.
• Added some auto complete for custom functions for parameters and function names:
  • Table occurrences
  • Field names after ::
  • Operator names
  • Function names from function list
  • Parameter names
  • Get/Hole/Obtenir functions
  Invoke with fn-F5 in the dialog or we auto invoke it for you.
• Added a check to GMImage.Scale to return an error if width or height is > 99999.
• Added a field to database design dialog for tables to show comments. To add a comment, define a field _TableComment and put comment text there.
• Added Audit.BuildCaches function.
• Added CURL fix #15102 to fix a bug with FTP over SSL.
• Added CurrentTimeStamp field to the JSON for FM.TableStatistics, FM.RecordStatistics and FM.FieldStatistics functions.
• Added DynaPDF.ClearLicense function.
• Added DynaPDF.GetAnnotColor and DynaPDF.GetTextBBox functions.
• Added DynaPDF.GetAnnotTextAlign function.
• Added DynaPDF.GetGlyphIndex and DynaPDF.GetGlyphOutline functions.
• Added DynaPDF.Parser.DeleteAllImages, DynaPDF.Parser.DeleteImage and DynaPDF.Parser.ListImages functions.
• Added field comment text to the tooltips in the debugger for macOS.
• Added field comment to the tooltips for the export dialog.
• Added field value and comment tooltips to calculation dialog, script workspace and debugger for macOS.
• Added FM.UpdateRecord4, FM.UpdateRecord5, FM.UpdateRecords4 and FM.UpdateRecords5 functions.
• Added JSON.InsertRecords function to insert array of records in JSON.
• Added List.Intersection function.
• Added Math.Rate function.
• Added MYSQL_OPT_LOCAL_INFILE option for SQL.SetConnectionOption for use with MySQL connections.
• Added sample script into extras to launch two FileMaker on macOS, one with HTTP tunneling on and one with it being off.
• Added SharedMemory.DeleteValue function.
• Added Text.FilterSwissQRCode function.
• Added Vision.RectifyDocument function.
• Added WordFile.GetProperty and WordFile.SetProperty functions.
• Changed Archive.Content to skip GID, UID, Permissions, RDev, FileType and HardLink fields, if not set.
• Changed Barcode.Generate, Barcode.GenerateJSON and Barcode.WriteFile to use 4 as default scale.
• Disabled remembering column widths for FileMaker 21.1.1 since this feature is now built-in to FileMaker.
• Fixed a bug in the Gamutcheck for lcms2.
• Fixed a problem on Windows with shared memory objects not accessible for other users.
• Fixed a problem with Events.Reset with not clearing all cached events, so Events.RemoveEvent function failed.
• Fixed a problem with Preview, MapView, DragDrop and ImageView controls to avoid control disappearing.
• Fixed an edge case with plugin registration.
• Fixed an edge case with swiss keyboard layout for RemoteControl.PressKey function and the virtual key lookup.
• Fixed an issue in Window.PositionNextDialog function for Windows.
• Fixed an issue with GMImage.WriteToPDFContainer and Twain.Acquire on Windows.
• Fixed crash with running Python on Windows.
• Fixed CURL Multi functions, broken in 14.4.
• Fixed SharedMemory.GetValue and SharedMemory.SetValue functions to work with empty values.
• Fixes a crash in Python functions when using older Python 3.9.x version.
• Implemented Process.List for Linux.
• Improved auto complete when you are in the middle of text.
• Improved Barcode.Detect by using newer zxing library.
• Improved Container.ReadImage to read HEIC images on iOS.
• Improved custom function auto complete to cache table and field names.
• Improved DynaPDF.GeneratePreview, DynaPDF.ReadImageResolution, DynaPDF.ReadImageFormat, DynaPDF.InsertImage, DynaPDF.AttachFileContainer, DynaPDF.AddOutputIntentEx, DynaPDF.CreateICCBasedColorSpaceContainer and DynaPDF.OpenPDFFromContainer to return proper error if container is empty.
• Improved error handling for XML.ApplyStylesheet.
• Improved FM.QueryBaseTableNames to use newer API in FileMaker 21.0 and newer.
• Improved FM.TableStatistics function to ignore summary fields.
• Improved JSON.InsertRecord to be a bit faster and data type conversion to do numbers and texts, too.
• Improved script search to include comments.
• Improved styled text conversion on macOS to include better support for highlight, underline and strikethrough, e.g. for RichText.SetFormattedText and Clipboard.SetStyledText functions.
• Improved type detection for FM.InsertRecordCSV function.
• Improved Vision functions to better read HEIC images directly.
• Note: SSLv3 is disabled now.
• Optimized XML functions to better handle thread locking.
• Removed the dependency on VCRUNTIME140_1.DLL file.
• Updated CURL to version 8.10.1.
• Updated discount library to version 2.2.7d.
• Updated DynaPDF to version 4.0.94.265.
• Updated for next FileMaker version.
• Updated jpeg library to version 9.6.
• Updated libarchive to version 3.7.6.
• Updated LibXL to version 4.4.0.
• Updated OpenSSL to version 3.3.2.
• Updated plugin SDK.
• Updated SQLite to version 3.47.0.
• Updated to libxml2 version 2.13.4.
• Updated to libxslt version 1.1.42.
• Updated to Xcode 16.0.
• Updated unicode tables for removing accents for Text.RemoveAccents function.
• Updated zxing library to newer branch.

Release notes for version 14.4 - 17th September 2024

New functions in 14.4 and Announcement in blog.

14.4 - 17th September 2024

• Added JSON.InsertRecord and JSON.InsertOrUpdateRecord functions.
• Added JSON.UpdateRecord and JSON.UpdateRecords functions.
• Added JSON.DeleteRecord and JSON.DeleteRecords functions.
• Added Text.Tidy and Text.TidyErrorLog functions to tidy XML and HTML.
• Added XML.Tidy function.
• Added Text.HTMLtoJSON function.
• Added BaseFont as selector for DynaPDF.SysFontInfo function.
• Added BaseFont value to JSON for DynaPDF.SysFontInfoAsJSON function.
• Added ClearBuffer parameter to WebRequest.GetRawData function.
• Added DynaPDF.CreateExtGState and DynaPDF.SetExtGState functions.
• Added DynaPDF.CreateURIAction function.
• Added DynaPDF.GetInEncryptionInfo function.
• Added DynaPDF.TestPassword function.
• Added FieldName entry for FM.FieldStatistics function result.
• Added Flags parameter for DynaPDF.ExtractDocumentText function.
• Added FM.FieldStatistics function.
• Added MongoDB.CursorRecords function.
• Added OptionsJSON parameter for MongoDB.ReplaceOne function.
• Added Python.RunFile function.
• Added shortcut for layout editor to use Command-Option-Shift-F on macOS to jump to the objects search field.
• Added SyntaxColoring.AutoCompleteVariables.SetLocals and SyntaxColoring.AutoCompleteVariables.GetLocals functions.
• Added tooltips for specify field dialog to show field type.
• Added WebHook.GetTag, WebHook.SetTag, WebRequest.GetTag and WebRequest.SetTag functions.
• Added XL.Book.RemovePrinterSettings and XL.Book.RemoveVBA functions.
• Changed JSON.GetArrayItemsAsList to return empty result if JSON is empty.
• Changed linux version to include version number and build number for Get(InstalledFMPlugins).
• Changed plugin to return empty results as really empty and trace to log that as nothing. It makes a difference whether we return nothing or empty text.
• Changed tooltips to show container instead of binary, text instead of varchar.
• Disabled trace logging for MongoDB by default.
• Fixed a bug in FM.FieldStatistics function. Now properly quotes field names.
• Fixed a bug with Matrix.Text function where it would skip some columns if they were constants in SQL used to create the matrix.
• Fixed a memory leak in Clipboard.SetFileMakerData, Clipboard.DetectFileMakerDataType and XML.Import functions.
• Fixed a problem in Files.RenameFile function to rename folders on Windows if the path ended with a backslash.
• Fixed a problem with AVRecorder.AddPreviewWithControl positioning the layer for FileMaker 21.
• Fixed a problem with GMImage.NewFromFile and Japanese characters on Windows.
• Fixed an issue in SyntaxColoring.AutoCompleteVariables.SetGlobals function.
• Fixed crash in DynaPDF.GetFontsAsJSON function for font with missing values.
• Fixed DynaPDF.ImportPDFFile to return proper error message.
• Fixed incorrect returning of result for DynaPDF.SetRenderingIntent, DynaPDF.SetUserUnit and DynaPDF.SetLineWidth functions.
• Fixed possible crashes with Phidgets script triggers.
• Fixed thread naming to avoid renaming main thread.
• Improved Archive functions and UnZipFile.OpenContainer function to better read zip archives downloaded via Insert From URL script step.
• Improved check to XL.Initialize to return an error if the license key includes invalid characters like a space character.
• Improved CURL.GetResultAsEMailList function, so it includes In-Reply-To and References headers if you have them in the query.
• Improved GMImage.ReadContainer to better pick decoder based on file name.
• Improved JSON functions to return error if you pass non JSON parameters to JSON.AddItemToArray, JSON.AddItemToObject, JSON.Replace and related functions.
• Improved MapView.PlanRoute function to use less memory.
• Improved PDFKit.RestorePrintSettings to better read PDF from container.
• Improved Twain.Initialize to return better error messages on Windows.
• Reduced number of dependencies on Linux version of our plugin. Requires GLIBCXX_3.4.26 now.
• Updated CURL to version 8.10.0.
• Updated DynaPDF to version 4.0.92.261.
• Updated LibXL to version 4.4.0.
• Updated openssl to version 3.1.6.
• Updated SQLAPI to version 5.3.4 with DuckDB 1.0 support.
• Updated SQLite to version 3.46.1.
• Upgraded all linux compilers to newer versions.

Release notes for version 14.3 - 9th July 2024

New functions in 14.3 and Announcement in blog.

14.3 - 9th July 2024

• Added Python functions.
• Added MQTT example using CURL.
• Added Archive.CompressText function.
• Added CFunction.GetTag, CFunction.SetTag, CLibrary.GetTag and CLibrary.SetTag functions.
• Added check to XL.Initialize and DynaPDF.Initialize to return an error if the license key includes invalid characters like a space character.
• Added CURL.GetMQTTMessages function.
• Added CURL.SetMQTTScript, CURL.GetMQTTFileName and CURL.GetMQTTScriptName functions.
• Added Dictionary.GetTag and Dictionary.SetTag functions.
• Added DragDrop.AttachToOverlay function to accept drops on an overlay.
• Added DX, DY and ClassID parameters to Preview.CreateWithControl and Preview.Create functions.
• Added DynaPDF.SetLineAnnotPoints and DynaPDF.EnableImageCache functions.
• Added EmailParser.ReleaseAll function.
• Added FM.RecordStatistics function.
• Added header row flag for Matrix.CSVSplit to put first row into column names.
• Added Java.GetTag and Java.SetTag functions.
• Added KeepUnsupportedAnnots option for DynaPDF.FlattenAnnots function.
• Added kstSearchAsIs flag for DynaPDFParserMBS class.
• Added Mutex.GetTag and Mutex.SetTag functions.
• Added Mutex.ReleaseAll function.
• Added Options parameter for Archive.Content, Archive.Extract, Archive.ExtractFile, Archive.FileList and Archive.GZipDecompress functions.
• Added Plugin.LockedFunctions function.
• Added Plugin.SetLicenseKeyHidden and Plugin.IsLicenseKeyHidden functions.
• Added QuickList.JSONArray function.
• Added Schedule.GetTag and Schedule.SetTag functions.
• Added SyntaxColoring.AutoCompleteVariables.GetGlobals and SyntaxColoring.AutoCompleteVariables.SetGlobals functions.
• Added SystemInfo.isSequoia function.
• Added SystemInfo.MacMemoryHostStatistics function.
• Added TotalSize entry for FM.TableStatistics and FM.RecordStatistics.
• Added WebView.ClearVirtualHostNameToFolderMapping and WebView.SetVirtualHostNameToFolderMapping functions.
• Added Window.HasFormattingBar function.
• Changed CURL debug messages to include the full URL you requested for review. We include a warning, if URL has no scheme.
• Changed ListDialog.SetShowCheckboxes to allow flag 4 to have checkboxes with only one checkbox checked at maximum.
• Changed Matrix.CSVSplit to handle CSV with multi line values better.
• Changed Matrix.JSONRecord and Matrix.JSONRecords to take field names from column names, if you have some and you don't pass field names.
• Changed StoreKit.FinishTransaction to allow passing of index in additional of transaction Identifier.
• Changed trace function to not log the password for a Files.Mount call.
• Changed WindowsUserNotification and UNNotification functions to be free to use without license.
• Changed XL.Book.Version to have the book parameter optional.
• Deprecated SystemInfo.isElCapitan, SystemInfo.isMavericks, SystemInfo.isSierra and SystemInfo.isYosemite functions.
• Enhanced check syntax button for calculation dialog to allow pressing shift key to only check the selected text.
• Enhanced execute button for calculation dialog to allow pressing shift key to only evaluate the selected text.
• Enhanced format button for calculation dialog to allow pressing shift key to only format the selected text.
• Fixed a bug in IBAN.Format function.
• Fixed a bug in WebLink() function in DynaPDFMBS class returning negative number.
• Fixed a memory leak in loading Excel file from disk with XL.LoadBook function.
• Fixed a problem with copying script text with duplicate field names or calculations.
• Fixed a problem with XL functions where license key was not recognized properly.
• Fixed an issue with server calling WMIQuery.Connect function.
• Fixed Archive.AddContainer function to allow relative paths in file name parameter.
• Fixed Archive.AddText function to allow relative paths in file name parameter.
• Fixed DynaPDF.DeletePage to return remaining pages on success.
• Fixed JSON.GetArraySize to return no error for empty JSON and just return zero.
• Fixed JSON.GetPathItem to not return error for invalid JSON if flag 2 is used.
• Fixed problem with JSON returning negative floating point numbers without leading 0.
• Fixed problem with variable checking and "target:" in lines.
• Fixed the WordFile.ReplaceTag function, which broke in 14.2.
• Improved code formatting to detect semicolon first and then formats this way.
• Improved Files.ResolveAlias function to handle symbolic links, too.
• Improved JSON.Import to report SQL statements in the error list for JSON.Import.Errors alongside the error messages.
• Improved JSON.SetPathItem to take the given value as text if it doesn't parse as JSON.
• Improved list functions to better split lists with CRLF as delimiter.
• Improved the formatting code for calculations to handle special words like OR and AND better.
• Improved UNNotification functions to work better in FileMaker 21, so both ways can be used together.
• Improved variable auto completion to better handle custom functions starting with underscore.
• Improved XML.Import to report SQL statements in the error list for XML.Import.Errors alongside the error messages.
• Reimplemented JSON.IsValid using newer JSON functions internally, so it catches more errors.
• Renamed EmailParser.Free to EmailParser.Release, but old name will stay valid.
• Renamed Mutex.Free to Mutex.Release, but old name will stay valid.
• Update LibXL libraries for macOS and Windows to version 4.3.
• Updated CURL to version 8.8.0
• Updated DynaPDF to version 4.0.89.256.
• Updated for future FileMaker version.
• Updated our ICU integration for SQLite to the new SQLite version.
• Updated SQLAPI to version 5.3.2.
• Updated SQLite to version 3.46.0.
• Updated to newer plugin SDK for FileMaker 21.
• Updated to Xcode 15.4.

• Version 14.2
• Version 14.1
• Version 14.0

2023

• Version 13.5
• Version 13.4
• Version 13.3
• Version 13.2
• Version 13.1
• Version 13.0

2022

• Version 12.5
• Version 12.4
• Version 12.3
• Version 12.2
• Version 12.1
• Version 12.0

2021

• Version 11.5
• Version 11.4
• Version 11.3
• Version 11.2
• Version 11.1
• Version 11.0

2020

• Version 10.5
• Version 10.4
• Version 10.3
• Version 10.2
• Version 10.1
• Version 10.0

2019

• Version 9.5
• Version 9.4
• Version 9.3
• Version 9.2
• Version 9.1
• Version 9.0

2018

• Version 8.5
• Version 8.4
• Version 8.3
• Version 8.2
• Version 8.1
• Version 8.0

2017

• Version 7.5
• Version 7.4
• Version 7.3
• Version 7.2
• Version 7.1
• Version 7.0

2016

• Version 6.5
• Version 6.4
• Version 6.3
• Version 6.2
• Version 6.1
• Version 6.0

2015

• Version 5.4
• Version 5.3
• Version 5.2
• Version 5.1
• Version 5.0

2014

• Version 4.4
• Version 4.3
• Version 4.2
• Version 4.1
• Version 4.0

2013

• Version 3.5
• Version 3.4
• Version 3.3
• Version 3.2
• Version 3.1
• Version 3.0

2012

• Version 2.9
• Version 2.8
• Version 2.7
• Version 2.6
• Version 2.5

2011

• Version 2.4
• Version 2.3
• Version 2.2

2010

• Version 2.1
• Version 2.0

2006 to 2009

• Version 1.8
• Version 1.7
• Version 1.6
• Version 1.5
• Version 1.4
• Version 1.3
• Version 1.2
• Version 1.1
• Version 1.0