MBS FileMaker Plugin 15.3 development

[MonkeybreadSoftware]

Hello,

in this thread I want to post to you what's new in development of MBS Plugin, version 15.3.

Download is available as usual here:

monkeybreadsoftware.com/filemaker/files/Prerelease/

If you like our plugin, bookmark, like or forward this thread.

If not, well you can ignore it.

New functions in documentation.

Thanks for supporting our plugin.

For questions please do not answer here, but start a new discussion.

Greetings
Christian

[MonkeybreadSoftware]

15.3pr1:

• Added Control-Up and Control-Down shortcuts for calculation editor to move lines up or down.
• Added Encryption.ProviderNames function.
• Added FileDialog.SetCanCreateDirectories and FileDialog.GetCanCreateDirectories functions.
• Added Format button for current value dialog in FileMaker's data viewer for XML and JSON.
• Added GMail oAuth SMTP example.
• Added Java.GetClassFields, Java.GetClassMethods and Java.GetLoadedClasses functions.
• Added JSON support for Saxon.XPathQuery, Saxon.XQuery and Saxon.XSLT functions.
• Added Math.BitwiseRotate function.
• Added Math.SetBit, Math.ClearBit and Math.GetBit functions.
• Added Matrix.Append function.
• Added Matrix.InsertRow and Matrix.InsertColumn functions.
• Added Saxon.LicenseeName function.
• Added ScriptWorkspace.GetBackgroundColor and ScriptWorkspace.SetBackgroundColor functions.
• Added SharingService.ShareValues function to pass text, that looks like an URL.
• Added Window.GetWindowDisplayAffinity and Window.SetWindowDisplayAffinity functions.
• Changed CURL functions to set OptionForbidReuse automatically when you do use PostFields.
• Changed Vision.DetectBarcode to detect OS version and use newer engine if available.
• Enhanced JSON.UpdateRecords to take keys as JSON array, so you can update multiple records with different primary keys.
• Fixed a crash with variable check if your line length is over 5 million characters.
• Fixed a possible crash in Process.GetCurrentDirectory function for macOS, iOS and Linux.
• Fixed an issue where our plugin would remove selection in ScriptWorkspace if you switch to another application and back.
• Fixed an issue with SQL.SetParamAsContainer and Firebird.
• Fixed FILEVERSION on Windows to sort bug and build numbers correctly.
• Fixed JSON.ToHTML to not get confused with invalid JSON when handling embedded JSON.
• Fixed link detection to work again in calculations.
• Fixed ListDialog functions to return OK instead of Select on success.
• Implemented ListDialog for iOS.
• Improved GMImage.GetAttribute and GMImage.GetAttributesJSON to decode high characters in text values.
• Improved search in tables to work for the dialog for importing custom functions.
• Improved SharingService.ShareItems to better work with sharing styled text.
• Improved Text.RemoveControlCharacters function to also remove BOM character.
• Improved the caching for CLGeocoder and MapView functions to better avoid duplicate lookups.
• Improved Vision.DetectBarcode function to report more details like coordinates.
• Improved Vision.DetectBarcode to return swapped coordinates.
• Tuned auto complete a bit.
• Updated DynaPDF to version 4.0.101.287.
• Updated Saxon library to version 12.7. Download
• Updated SQLAPI to version 5.3.7.
• Updated to Xcode 16.4.

[weetbicks]

Fixed a crash with variable check if your line length is over 5 million characters.

I'd like to know who submitted that one lol !

[planteg]

Certainly not on an 8-bit computer !

Some languages don't bother with LF, you may type a lot of things on a single line .

[Malcolm]

Sounds like a runaway iteration loop.

[MonkeybreadSoftware]

15.3pr2:

• Added uuid and base64 extensions for the built-in SQLite library in SQL.InternalSQLiteLibrary.Activate function.
• Added SQL.InternalSQLiteLibrary.GetBase64ExtensionEnabled, SQL.InternalSQLiteLibrary.GetUUIDExtensionEnabled, SQL.InternalSQLiteLibrary.SetBase64ExtensionEnabled and SQL.InternalSQLiteLibrary.SetUUIDExtensionEnabled functions.
• Fixed a little problem with AutoComplete duplicating the completed text.
• Fixed syntax coloring to work if you open custom functions dialog before opening script workspace.
• Fixed JSON.JSONPatch.FromDiff to do the copy key feature again, broken with jsoncons update in version 15.1.
• Added missing names GS1_128_CC and GS1_128 for the barcode symbology list.
• Changed Barcode.GenerateJSON to allow text to be an array for a stacked barcode.
• Fixed changing font size for future FileMaker version.
• Added CSV extension for the built-in SQLite library in SQL.InternalSQLiteLibrary.Activate function.
• Added Window.SetRoundCorners function for round corners in card windows.
• Added SQL.InternalSQLiteLibrary.Dump function.

[MonkeybreadSoftware]

15.3pr3:

• Updated DynaPDF to version 4.0.102.288.
• Added DynaPDF.SetActiveSigField function.
• Added SystemInfo.isTahoe function.
• Fixed a problem in CompressFiles method for ZipMBS class, broken since 25.0.
• Improved SQL.InternalSQLiteLibrary.Dump function.
• Updated SQLite to version 3.50.1.
• Improved our CoreML functions to handle Int8 data type in addition to Float16, Float32, Int32 and Float64 data types that your models may use.
• Updated CURL library to version 8.14.1.
• Added CURL.SetOptionSSLSignatureAlgorithms function.
• Improved loading LDAP library on Linux to work on Ubuntu 22 and 24.
• Changed copy text/selection in ScriptWorkspace to indent the lines.
• Added SelectedOnly and EndOfLine parameters for ScriptWorkspace.StyledScriptText function.

[weetbicks]

Feature request, this one came from Kent at fmslug but is something I also struggle with greatly.

On mac, the script debugger has an annoying trait where if you step over perform script steps, it jumps to the bottom of the debugger so you can't see what is coming next. Can this be fixed via MBS in any way so that it always ensures you can see the next 5 or 6 lines of a script coming next?

[MonkeybreadSoftware]

You mean to scroll the debugger automatically and make sure at least the next three lines before and after are visible?
I think I could do that.

[weetbicks]

Yes that's the one

[MonkeybreadSoftware]

15.3pr4:

• Updated mongo-c-driver to version 1.30.5.
• Improved OCR error messages to state whether tesseract or leptonica library is not loaded.
• Added search: prefix for comment links to jump to whatever text you provide.
• Added SystemInfo.AppResourceUsageStatistics function.
• Improved how we scroll lists to make sure more rows below and after a visible.
• Improved debugger in FileMaker to scroll better and show a few rows adhead on stepping.
• Improved our CopyButton to not show the warning in console about adding a button to the title bar.
• Updated DynaPDF to version 4.0.102.290.

[MonkeybreadSoftware]

@MonkeybreadSoftware

• Improved debugger in FileMaker to scroll better and show a few rows adhead on stepping.

This feature has unintended problems in the Script Workspace.

Please install an older version if you are affected by this bug.

You can find a newer build here: builds folder

[MonkeybreadSoftware]

15.3pr5:

• Added new scroll feature for debugger, which seems to work better.
• Removed the scroll feature from pr4 due to unintended side effects.
• Added SyntaxColoring.DebuggerScrolling.GetEnabled and SyntaxColoring.DebuggerScrolling.SetEnabled functions.
• Fixed possible crash with script workspace enhancements for future FileMaker version.
• Updated LibArchive to version 3.8.1.
• Added bzip2 and zstd as filter for zip archives for Archive.Compress, Archive.CompressContainer, Archive.CompressText and Archive.Create functions.
• Added Plugin.RegisterFunction function to register custom functions on the fly. These show up in calculation dialogs just like regular custom functions.
• Added Plugin.CustomFunctionNames to list custom functions.
• Added Plugin.CustomFunctionParameter and Plugin.CustomFunctionParameterCount to query parameters for the custom function.
• Added Plugin.RegisterScriptStep function.
• Deprecated MBS CustomScriptSteps.xml feature.
• Updated SQLite to version 3.50.2.
• Improved SerialPort functions to work better with suspended ports.

[MonkeybreadSoftware]

15.3pr6:

• Updated Saxon library to version 12.8. Download
• Added a search button to find function on documentation website.
• • Improved Plugin.RegisterFunction to pass parameters as they appear in prototype.
• Changed findbar to appear automatically in database design dialog if you use it there frequently.

[MonkeybreadSoftware]

15.3pr7:

• Added Files.PrintFile function for macOS and Windows.
• Rewrote macOS part of Files.LaunchFile to use newer API on macOS 10.15 or higher.
• Updated DynaPDF to version 4.0.102.291.

[MonkeybreadSoftware]

And released:

MBS Plugin 15.3 for Claris FileMaker

[weetbicks]

This request is obviously a little too late for 15.3 but hopefully this is doable for the next version!

This has always been an annoying thing for me with the Field calculation dialog pictured.

When you want to change the context of the calculation (which is often when working with an Interface table), you change it via the drop-down at the top. The problem is that the current table occurrence on the left does not change. You always have to change this context to be the same as the one you just chose at the top and this is super frustrating.

Is there any way possible that these two can basically be in sync so that when the top context changes, the 'current table' automatically changes to be the same one? There really is no reason for these two to ever be different upon changing of the evaluation context.

I would be eternally grateful!

[MonkeybreadSoftware]

But why don't you have it set to current type?
Which should be the same as above.

[weetbicks]

Sorry not sure I follow.

Here is an example. I have an interface table in my file. In this type of solution, all layouts are based on an anchor TO which is based on the interface table. However I have many interface table occurrences.

When you create a new calculation, the default TO it evaluates from is always the very first TO that got created in the file. In my case, D_Interface

I never want to create calcs evaluated from that context. For me the calculations are always evaluated from the context of wherever that calc is used, such as the layout (and thus the relevant TO).

So, imagine I'm creating a new calculation:

By default, the context is set to D_Interface. "Current Table" by default also always gets set to D_Interface.

Now I want to choose the actual correct context for this calculation. I must now select the correct context from the drop-down.

When I set the evaluation context, the left hand side field listing does not update the "current table" TO.

I can't just begin adding fields to this calc, as it then adds them for the wrong context. I must first now go and change the TO on the left to the one at the top before i can start writing the calc.

You have to do this every single time in this case, and it's always the same TO I need to change on the left, and it always gets changed to "Current Table" for the newly selected evaluation context.

I have never understood why when you change a calculations evaluation context can't the current table TO on the left also automatically change. The left hand side is purely for field selection it has no effect on the calculation at all, but it is just a complete nuisance to have to now always change this before I can start building the calc.

hope that clears it up !