Monkeybread Software - MBS FileMaker Plugin: New in version 14.2

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

New in version 14.2

Item	Details	Server
CURL.AvailableSSLBackends Queries the list of available SSL backends.	All	✅ Server
CURL.SetSSLBackend Sets which backend to use for SSL connections.	All	✅ Server
Container.RemovePreview Removes the preview from a container value.	All	✅ Server
Dictionary.HasKeys Checks if the given keys exist in dictionary.	All	✅ Server
Files.IsSystemImmutable Queries the system immutable flag.	Mac/iOS	✅ Server
Files.IsUserImmutable Queries the user immutable flag.	Mac/iOS	✅ Server
Files.SetSystemImmutable Sets the system immutable flag.	Mac/iOS	✅ Server
Files.SetUserImmutable Sets the user immutable flag.	Mac/iOS	✅ Server
GMImage.Flatten Flatten the alpha channel.	All	✅ Server
JSON.CurrentMatch Queries JSON for current match in JSON.ReplaceEvaluate function.	All	✅ Server
JSON.CurrentMatchPath Queries JSON for current match path in JSON.ReplaceEvaluate function.	All	✅ Server
JSON.Import.SetBaseFields Sets the names of the base fields per record.	All	✅ Server
JSON.Import.SetExtraField Sets the extra field to add to all tables.	All	✅ Server
JSON.Merge Merges multiple JSON objects or arrays.	All	✅ Server
JSON.ReplaceEvaluate Searches for all values that match the JSONPath expression and replaces them with the result of the evaluation.	All	✅ Server
ListDialog.GetShowCloseBox Queries whether the close box is enabled.	Mac/Win	❌ Server
ListDialog.SetShowCloseBox Sets whether the close box widget is enabled.	Mac/Win	❌ Server
Math.MovingAverage Calculates moving average.	All	✅ Server
MongoDB.ClientCommand Execute a command on the server, interpreting options according to the MongoDB server version.	All	✅ Server
MongoDB.ClientCommandQuery Creates a query cursor.	All	✅ Server
MongoDB.ClientCommandWithServerId This function executes a command on a specific server, using the database and command specification provided.	All	✅ Server
MongoDB.GetAppName Queries the client application name.	All	✅ Server
MongoDB.GetCredentials Queries credentials as JSON.	All	✅ Server
MongoDB.SetAppName Sets the client application name.	All	✅ Server
PDFKit.SelectPrinter Shows the printer picker.	iOS	❌ Server
QuickList.HasValues Checks whether a list contains the given values.	All	✅ Server
Text.LeftTrim Trims whitespace on the left side.	All	✅ Server
Text.RightTrim Trims whitespace on the right side.	All	✅ Server
XL.Book.AddConditionalFormat Adds a new conditional format to the workbook for using with conditional formatting rules.	All	✅ Server
XL.ConditionalFormat.Font Returns the font for this format.	All	✅ Server
XL.ConditionalFormat.GetBorderBottom Returns the bottom border style.	All	✅ Server
XL.ConditionalFormat.GetBorderBottomColor Returns the color of the bottom border.	All	✅ Server
XL.ConditionalFormat.GetBorderLeft Returns the left border style.	All	✅ Server
XL.ConditionalFormat.GetBorderLeftColor Returns the color of the left border.	All	✅ Server
XL.ConditionalFormat.GetBorderRight Returns the right border style.	All	✅ Server
XL.ConditionalFormat.GetBorderRightColor Returns the color of the right border.	All	✅ Server
XL.ConditionalFormat.GetBorderTop Returns the top border style.	All	✅ Server
XL.ConditionalFormat.GetBorderTopColor Returns the color of the top border.	All	✅ Server
XL.ConditionalFormat.GetCustomNumFormat Queries custom format string.	All	✅ Server
XL.ConditionalFormat.GetFillPattern Returns the fill pattern.	All	✅ Server
XL.ConditionalFormat.GetNumFormat Returns the number format identifier.	All	✅ Server
XL.ConditionalFormat.GetPatternBackgroundColor Returns the background color of the fill pattern.	All	✅ Server
XL.ConditionalFormat.GetPatternForegroundColor Returns the foreground color of the fill pattern.	All	✅ Server
XL.ConditionalFormat.SetBorder Sets the border style.	All	✅ Server
XL.ConditionalFormat.SetBorderBottom Sets the bottom border style.	All	✅ Server
XL.ConditionalFormat.SetBorderBottomColor Sets the color of the bottom border.	All	✅ Server
XL.ConditionalFormat.SetBorderColor Sets the border color.	All	✅ Server
XL.ConditionalFormat.SetBorderLeft Sets the left border style.	All	✅ Server
XL.ConditionalFormat.SetBorderLeftColor Sets the color of the left border.	All	✅ Server
XL.ConditionalFormat.SetBorderRight Sets the right border style.	All	✅ Server
XL.ConditionalFormat.SetBorderRightColor Sets the color of the right border.	All	✅ Server
XL.ConditionalFormat.SetBorderTop Sets the top border style.	All	✅ Server
XL.ConditionalFormat.SetBorderTopColor Sets the color of the top border.	All	✅ Server
XL.ConditionalFormat.SetCustomNumFormat Sets a custom number format.	All	✅ Server
XL.ConditionalFormat.SetFillPattern Sets the fill pattern.	All	✅ Server
XL.ConditionalFormat.SetNumFormat Sets the number format identifier.	All	✅ Server
XL.ConditionalFormat.SetPatternBackgroundColor Sets the background color of the fill pattern.	All	✅ Server
XL.ConditionalFormat.SetPatternForegroundColor Sets the foreground color of the fill pattern.	All	✅ Server
XL.ConditionalFormating.Add2ColorScaleFormulaRule Adds a conditional formatting rule that creates a gradated 2-color scale on the cells.	All	✅ Server
XL.ConditionalFormating.Add2ColorScaleRule Adds a conditional formatting rule that creates a gradated 2-color scale on the cells.	All	✅ Server
XL.ConditionalFormating.Add3ColorScaleFormulaRule Adds a conditional formatting rule that creates a gradated 3-color scale on the cells.	All	✅ Server
XL.ConditionalFormating.Add3ColorScaleRule Adds a conditional formatting rule that creates a gradated 3-color scale on the cells.	All	✅ Server
XL.ConditionalFormating.AddAboveAverageRule Adds a conditional formatting rule that highlights cells that are above or below the average for all values in the range.	All	✅ Server
XL.ConditionalFormating.AddOpNumRule Adds a conditional formatting rule that highlights cells whose values are compared with a calculated result, using an operator.	All	✅ Server
XL.ConditionalFormating.AddOpStrRule Adds a conditional formatting rule that highlights cells whose values are compared with a calculated result, using an operator.	All	✅ Server
XL.ConditionalFormating.AddRange Adds a range to these conditional formatting rules.	All	✅ Server
XL.ConditionalFormating.AddRule Adds a conditional formatting rule that highlights cells whose values correspond to the specified criteria.	All	✅ Server
XL.ConditionalFormating.AddTimePeriodRule Adds a conditional formatting rule that highlights cells containing dates in the specified time period.	All	✅ Server
XL.ConditionalFormating.AddTopRule Adds a conditional formatting rule that highlights cells whose values fall in the [top N] or [bottom N] bracket.	All	✅ Server
XL.Sheet.AddConditionalFormatting Adds a conditional formatting rules to the sheet.	All	✅ Server

70 functions shown.

New parameters added

Item	Details	Server
DynaPDF.SaveAndSignFileWinCryptDialog: CertificateName Saves and signs the current PDF.	Win only	❌ Server
FM.SQL.JSONRecords: firstRow, lastRow Returns rows as JSON array.	All	✅ Server
FM.SQL.XMLRecords: firstRow, lastRow Returns rows as XML.	All	✅ Server
Hash.DigestFile: UpdateProgressbar Calculates a hash of a file.	All	✅ Server
Matrix.JSONRecords: firstRow, lastRow Returns rows as JSON array.	All	✅ Server
Overlay.Move: AnimationTime Moves the window the given position.	Mac/Win	❌ Server
XL.LoadBookPartially: keepAllSheets Loads a Excel file partially.	All	✅ Server

7 functions shown.

These functions require a license (86%).

Blog Entries

Older Version 14.1 Newer Version 14.3

💬 Ask a question or report a problem