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

New in version 14.2 and in the upcoming version 14.3

Item Details Server
Archive.CompressText
Compresses a text into a new archive.
All
14.3
  ✅ Server
CURL.AvailableSSLBackends
Queries the list of available SSL backends.
All
14.2
  ✅ Server
CURL.GetMQTTFileName
Queries script name set to run for incoming MQTT file name.
All
14.3
  ✅ Server
CURL.GetMQTTMessages
Queries JSON array with messages.
All
14.3
  ✅ Server
CURL.GetMQTTScriptName
Queries script name set to run for incoming MQTT script name.
All
14.3
  ✅ Server
CURL.SetMQTTScript
Sets script to run when we receive a MQTT message,.
All
14.3
  ✅ Server
CURL.SetSSLBackend
Sets which backend to use for SSL connections.
All
14.2
  ✅ Server
Container.RemovePreview
Removes the preview from a container value.
All
14.2
  ✅ Server
Dictionary.HasKeys
Checks if the given keys exist in dictionary.
All
14.2
  ✅ Server
EmailParser.ReleaseAll
Releases all emails.
All
14.3
  ✅ Server
Files.IsSystemImmutable
Queries the system immutable flag.
Mac/iOS
14.2
  ✅ Server
Files.IsUserImmutable
Queries the user immutable flag.
Mac/iOS
14.2
  ✅ Server
Files.SetSystemImmutable
Sets the system immutable flag.
Mac/iOS
14.2
  ✅ Server
Files.SetUserImmutable
Sets the user immutable flag.
Mac/iOS
14.2
  ✅ Server
GMImage.Flatten
Flatten the alpha channel.
All
14.2
  ✅ Server
JSON.CurrentMatch
Queries JSON for current match in JSON.ReplaceEvaluate function.
All
14.2
  ✅ Server
JSON.CurrentMatchPath
Queries JSON for current match path in JSON.ReplaceEvaluate function.
All
14.2
  ✅ Server
JSON.Import.SetBaseFields
Sets the names of the base fields per record.
All
14.2
  ✅ Server
JSON.Import.SetExtraField
Sets the extra field to add to all tables.
All
14.2
  ✅ Server
JSON.Merge
Merges multiple JSON objects or arrays.
All
14.2
  ✅ Server
JSON.ReplaceEvaluate
Searches for all values that match the JSONPath expression and replaces them with the result of the evaluation.
All
14.2
  ✅ Server
ListDialog.GetShowCloseBox
Queries whether the close box is enabled.
Mac/Win
14.2
  ❌ Server
ListDialog.SetShowCloseBox
Sets whether the close box widget is enabled.
Mac/Win
14.2
  ❌ Server
Math.MovingAverage
Calculates moving average.
All
14.2
  ✅ Server
MongoDB.ClientCommand
Execute a command on the server, interpreting options according to the MongoDB server version.
All
14.2
  ✅ Server
MongoDB.ClientCommandQuery
Creates a query cursor.
All
14.2
  ✅ Server
MongoDB.ClientCommandWithServerId
This function executes a command on a specific server, using the database and command specification provided.
All
14.2
  ✅ Server
MongoDB.GetAppName
Queries the client application name.
All
14.2
  ✅ Server
MongoDB.GetCredentials
Queries credentials as JSON.
All
14.2
  ✅ Server
MongoDB.SetAppName
Sets the client application name.
All
14.2
  ✅ Server
Mutex.ReleaseAll
Releases all mutex objects.
All
14.3
  ✅ Server
PDFKit.SelectPrinter
Shows the printer picker.
iOS
14.2
  ❌ Server
Plugin.LockedFunctions
Lists the locked functions.
All
14.3
  ✅ Server
Python.AddEvaluateFunction
Adds an evaluate function.
All
14.3
  ✅ Server
Python.AddExecuteSQLFunction
Adds an execute SQL function.
All
14.3
  ✅ Server
Python.Clear
Clears the variables in the Python environment.
All
14.3
  ✅ Server
Python.DeleteValue
Deletes a variable in the Python environment.
All
14.3
  ✅ Server
Python.Evaluate
Evaluates an expression in Python.
All
14.3
  ✅ Server
Python.GetTag
Queries tag value.
All
14.3
  ✅ Server
Python.GetValue
Queries a variable in the Python environment.
All
14.3
  ✅ Server
Python.HasValue
Checks whether a variable is set for the Python environment.
All
14.3
  ✅ Server
Python.Keys
Queries the list of names for values.
All
14.3
  ✅ Server
Python.LibraryVersion
Queries the version text of the Python library.
All
14.3
  ✅ Server
Python.List
Returns list of all Python environment IDs.
All
14.3
  ✅ Server
Python.Load
Loads the Python library.
All
14.3
  ✅ Server
Python.Loaded
Queries whether Python libraries have been loaded.
All
14.3
  ✅ Server
Python.New
Creates a new Python environment.
All
14.3
  ✅ Server
Python.PrintOutput
Queries the output of print commands in Python.
All
14.3
  ✅ Server
Python.Release
Releases the Python environment.
All
14.3
  ✅ Server
Python.ReleaseAll
Releases all Python environments.
All
14.3
  ✅ Server
Python.Run
Runs a Python script.
All
14.3
  ✅ Server
Python.SetInput
Sets the input values to use.
All
14.3
  ✅ Server
Python.SetTag
Sets the tag value.
All
14.3
  ✅ Server
Python.SetValue
Sets a variable in the Python environment.
All
14.3
  ✅ Server
Python.ValueCount
Queries number of variables.
All
14.3
  ✅ Server
QuickList.HasValues
Checks whether a list contains the given values.
All
14.2
  ✅ Server
QuickList.JSONArray
Returns all texts in the QuickList as a JSON array.
All
14.3
  ✅ Server
SystemInfo.MacMemoryHostStatistics
Queries memory host statistics for macOS and iOS.
Mac/iOS
14.3
  ✅ Server
Text.LeftTrim
Trims whitespace on the left side.
All
14.2
  ✅ Server
Text.RightTrim
Trims whitespace on the right side.
All
14.2
  ✅ Server
XL.Book.AddConditionalFormat
Adds a new conditional format to the workbook for using with conditional formatting rules.
All
14.2
  ✅ Server
XL.ConditionalFormat.Font
Returns the font for this format.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetBorderBottom
Returns the bottom border style.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetBorderBottomColor
Returns the color of the bottom border.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetBorderLeft
Returns the left border style.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetBorderLeftColor
Returns the color of the left border.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetBorderRight
Returns the right border style.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetBorderRightColor
Returns the color of the right border.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetBorderTop
Returns the top border style.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetBorderTopColor
Returns the color of the top border.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetCustomNumFormat
Queries custom format string.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetFillPattern
Returns the fill pattern.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetNumFormat
Returns the number format identifier.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetPatternBackgroundColor
Returns the background color of the fill pattern.
All
14.2
  ✅ Server
XL.ConditionalFormat.GetPatternForegroundColor
Returns the foreground color of the fill pattern.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetBorder
Sets the border style.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetBorderBottom
Sets the bottom border style.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetBorderBottomColor
Sets the color of the bottom border.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetBorderColor
Sets the border color.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetBorderLeft
Sets the left border style.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetBorderLeftColor
Sets the color of the left border.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetBorderRight
Sets the right border style.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetBorderRightColor
Sets the color of the right border.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetBorderTop
Sets the top border style.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetBorderTopColor
Sets the color of the top border.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetCustomNumFormat
Sets a custom number format.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetFillPattern
Sets the fill pattern.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetNumFormat
Sets the number format identifier.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetPatternBackgroundColor
Sets the background color of the fill pattern.
All
14.2
  ✅ Server
XL.ConditionalFormat.SetPatternForegroundColor
Sets the foreground color of the fill pattern.
All
14.2
  ✅ Server
XL.ConditionalFormating.Add2ColorScaleFormulaRule
Adds a conditional formatting rule that creates a gradated 2-color scale on the cells.
All
14.2
  ✅ Server
XL.ConditionalFormating.Add2ColorScaleRule
Adds a conditional formatting rule that creates a gradated 2-color scale on the cells.
All
14.2
  ✅ Server
XL.ConditionalFormating.Add3ColorScaleFormulaRule
Adds a conditional formatting rule that creates a gradated 3-color scale on the cells.
All
14.2
  ✅ Server
XL.ConditionalFormating.Add3ColorScaleRule
Adds a conditional formatting rule that creates a gradated 3-color scale on the cells.
All
14.2
  ✅ 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
14.2
  ✅ Server
XL.ConditionalFormating.AddOpNumRule
Adds a conditional formatting rule that highlights cells whose values are compared with a calculated result, using an operator.
All
14.2
  ✅ Server
XL.ConditionalFormating.AddOpStrRule
Adds a conditional formatting rule that highlights cells whose values are compared with a calculated result, using an operator.
All
14.2
  ✅ Server
XL.ConditionalFormating.AddRange
Adds a range to these conditional formatting rules.
All
14.2
  ✅ Server
XL.ConditionalFormating.AddRule
Adds a conditional formatting rule that highlights cells whose values correspond to the specified criteria.
All
14.2
  ✅ Server
XL.ConditionalFormating.AddTimePeriodRule
Adds a conditional formatting rule that highlights cells containing dates in the specified time period.
All
14.2
  ✅ Server
XL.ConditionalFormating.AddTopRule
Adds a conditional formatting rule that highlights cells whose values fall in the [top N] or [bottom N] bracket.
All
14.2
  ✅ Server
XL.Sheet.AddConditionalFormatting
Adds a conditional formatting rules to the sheet.
All
14.2
  ✅ Server

102 functions shown.

New parameters added

Item Details Server
DynaPDF.SaveAndSignFileWinCryptDialog
Saves and signs the current PDF.
Win only
  ❌ Server
FM.SQL.JSONRecords
Returns rows as JSON array.
All
  ✅ Server
FM.SQL.XMLRecords
Returns rows as XML.
All
  ✅ Server
Hash.DigestFile
Calculates a hash of a file.
All
  ✅ Server
Matrix.CSVSplit
Splits CSV text.
All
  ✅ Server
Matrix.JSONRecords
Returns rows as JSON array.
All
  ✅ Server
Overlay.Move
Moves the window the given position.
Mac/Win
  ❌ Server
Preview.Create
Creates a new preview area inside the window with the given rectangle.
Mac/Win
  ❌ Server
Preview.CreateWithControl
Creates a new preview on the given window covering the area of the given control.
Mac/Win
  ❌ Server
XL.LoadBookPartially
Loads a Excel file partially.
All
  ✅ Server

10 functions shown.

These functions require a license (80%).

Older Version 14.1