Release notes for version 12.0 - 18th January 2022

New functions in 12.0 and Announcement in blog.

• Added AutoComplete feature for variable names to calculation dialogs on macOS.
• Added tools to add/remove table occurrence prefixes in calculations.
• Added AVRecorder.VideoResolutions function for Windows.
• Added DynaPDF.ActivateAltFontList, DynaPDF.CreateAltFontList, DynaPDF.DeleteAltFontList and DynaPDF.SetAltFonts functions.
• Added Events.Event.BirthdayContactIdentifier and deprecated older Events.Event.BirthdayPersonUniqueID.
• Added Files.IsExcludedFromBackup, Files.IsFileExtensionHidden, Files.SetExcludedFromBackup and Files.SetFileExtensionHidden functions.
• Added FM.ExecuteFileSQLValue function.
• Added FM.ValueListIDForValueListName, FM.ValueListNameForValueListID and FM.ValueListNames functions.
• Added new parameters for AVRecorder.SetVideoDevice function to pick desired width and height of resolution.
• Added Offset and Length parameters to CURL.SetInputFile, CURL.SetInputGIF, CURL.SetInputJPEG, CURL.SetInputPDF and CURL.SetInputPNG to only upload a portion of the container.
• Added option to show IDs for value list.
• Added Preferences.List function.
• Added ProgressDialog.SetPositionWindowCentered function.
• Added SQL.GetFieldAsNumber, SQL.GetParamAsNumber and SQL.SetParamAsNumber to better handle numeric values.
• Added subscript and superscript to Text.TextToHTML function.
• Added support for tab character in text replacements with WordFile functions.
• Added SyntaxColoring.AutoCompleteVariables.GetEnabled and SyntaxColoring.AutoCompleteVariables.SetEnabled functions.
• Added SyntaxColoring.GetShowValueListIDs and SyntaxColoring.SetShowValueListIDs functions.
• Added WebHook.GetTimeOut and WebHook.SetTimeOut functions.
• Added WebRequest.GetState function.
• Added workaround for Files.MoveFile and Files.CopyFile when it fails with MAX_PATH error.
• Changed default comment color in scripts to dark green instead of black. Feel free to adjust with SyntaxColoring.AddTag if you prefer other colors.
• Changed DynaPDF.SetFont, DynaPDF.Table.SetFont, DynaPDF.SetFontEx, DynaPDF.ChangeFontEx, DynaPDF.SetFieldFont and DynaPDF.SetBookmarkStyle functions to accept styles as text.
• Changed how we handles numbers in SQL functions to better handle numeric values and avoid conversion of numeric to floating pointer numbers.
• Changed license checks to make another 500 plugin functions to not check license status. Currently only 4900 of over 6600 functions do that. Even if this is quick, not doing it everywhere could speed up some processing.
• Changed object management to log warning if you have more than 100 objects allocated. This may point to an issue in your scripts not releasing objects.
• Changed relationship search field to be smaller.
• Changed showing of invisible characters in calculations to show more hidden characters like BOM character (Command-I in calculation to enable).
• Changed variable check to find multiple variables in a comment separated by space or tab.
• Changed variable coloring and checks to allow exclamation mark in variable names.
• Changed XML parsing to explicit disable network access.
• Changed XML.Query to remove surrounding quotes for namespaces.
• Deprecated MenuItem.GetSelectable and MenuItem.SetSelectable since they don't work properly anymore on current macOS versions.
• Deprecated SNMP functions in favor of running them via shell functions.
• Documented missing color space handle parameter for DynaPDF.Table.SetColorFloat function.
• Enhanced Clipboard.DetectFileMakerDataType and Clipboard.SetFileMakerData to recognize script folders.
• Fixed a case where @param comments where not found with several spaces before the variable name.
• Fixed a potential problem in SQL.InsertOrUpdateRecords function where it could crash with too many primary keys.
• Fixed a problem in CURL.GetHeaderAsJSON introduced in v11.5.
• Fixed a problem in email parser, which didn't get multi part right on Linux for EmailParser.Parse, EmailParser.ParseContainer and EmailParser.ParseFile.
• Fixed a problem where context menu would crash if the plugin was updated via script.
• Fixed a problem with WinSendMail.AddBCC, WinSendMail.AddCC, WinSendMail.AddRecipient, WinSendMail.AddTo not passing email when name is empty.
• Fixed an edge case for syntax coloring with block comments to color the full comment.
• Fixed Container.ReadFile to read empty files.
• Fixed handling of PageNumber field for Audit.Changed functions.
• Fixed issue with calendar item function, where a newly created event wouldn't be know on next function call if the calendar database reported change.
• Fixed JSON functions to return NULL for numbers with no content, e.g. empty text. This affects JSON.CreateNumber, Dictionary.ToJSON, FM.SQL.JSONColumn, FM.SQL.JSONRecord and FM.SQL.JSONRecords functions.
• Fixed Path.FileMakerPathToNativePath to recognise filelinux: prefix.
• Fixed problem in WebView.AllCookies with NULL values.
• Fixed problem where plugin would unnecessarily complain about mutex problem on server.
• Fixed problem with Linux for Shell functions where you could get an error: "A NULL argv[0] was passed through an exec system call." message.
• Fixed SyntaxColoring to colorize calculations starting with $ variable.
• Fixed value list IDs to work for Japanese, too.
• Redesigned our calculation dialog buttons to be a segmented control.
• Updated archive library to version 3.5.2.
• Updated cpuid library to version 0.51.
• Updated CURL to version 7.81.0.
• Updated DynaPDF to version 4.0.65.167.
• Updated expat library to version 2.4.1.
• Updated LCMS library to version 2.13rc1.
• Updated lz4 library to version 1.9.3.
• Updated openssl to version 1.1.1l.
• Updated SQLAPI to version 5.1.8.
• Updated SQLite to version 3.37.0.
• Updated ssh2 library to version 1.10.0.
• Updated SystemInfo.CPUBrandString to work on Apple Silicon.
• Updated LibXL to version 4.0.1.

New in version 11.5   New in version 12.1

More details in the Release notes and Announcement in blog.