Monkeybread Software - MBS FileMaker Plugin: Component: FM

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 9.5 10.0 10.1 10.2 10.3 10.4 10.5 11.0 11.1 11.2 Statistic FMM Blog

Component: FM

Functions for FileMaker core functions like running scripts.

Version	macOS	Windows	Linux	Server	iOS SDK
1.2 / 11.2	✅ 97%	✅ 93%	✅ 83%	✅ 82%	✅ 81%

Item	Details
FM.AllowFileDragDrop Installs fix for file drag and drop problem.	Mac only 7.0
FM.Argument Query an argument passed to FileMaker from command line.	All 5.1
FM.ArgumentCount Queries number of arguments.	All 5.1
FM.Beep Beeps.	Mac/Win 8.2
FM.ChooseDictionary Chooses or queries dictionary used.	Mac only 9.4
FM.CompareTables Compare two tables.	All 9.3
FM.CurrentLayoutID Queries ID of current running FileMaker layout.	All 10.2
FM.CurrentLayoutName Queries name of current layout.	All 10.2
FM.CurrentScriptID Queries ID of current running FileMaker script.	All 5.1
FM.CurrentScriptName Queries name of current script.	All 5.1
FM.CurrentThreadID Queries current thread ID.	All 5.1
FM.DataType Returns data type of argument.	All 6.1
FM.DataViewerContent Looks for data viewer and copies visible table content.	Mac only 6.3
FM.DeleteRecord Deletes an existing record in a table in one line.	All 6.0
FM.DeleteRecords Deletes existing records in a table in one line.	All 6.0
FM.DisableMouseWheel Disables use of mouse wheel on Windows.	Win only 5.1
FM.DisableRuntimeEndWindow Disables end screen on runtime on Mac.	Mac only 4.3
FM.EnableMouseWheel Enables use of mouse wheel on Windows.	Win only 5.1
FM.Evaluate Similar to FileMaker's built in FM Evaluate	All 1.3
FM.ExecuteFileSQL Execute the SQL Statement against a FileMaker database.	All 3.5
FM.ExecuteFileSQLOnIdle This is similar to FM.ExecuteFileSQL, except that it waits until idle to execute.	All 6.5
FM.ExecuteSQL Execute the SQL Statement against the current FileMaker File.	All 1.2
FM.ExecuteSQL.LastError Queries the last error code from an SQL call	All 1.2
FM.ExecuteSQL.LastErrorMessage Queries the last error message from an SQL call	All 3.0
FM.ExecuteSQL.LastSQL Queries last SQL command.	All 7.4
FM.ExecuteSQLOnIdle This is similar to FM.ExecuteSQL, except that it waits until idle to execute.	Mac/Win 1.2
FM.GetDictionary Queries current dictionary.	Mac only 9.4
FM.GetDictionaryList Queries current dictionaries list.	Mac only 9.4
FM.GetDisableContextualMenus Queries whether to disable contextual menus.	Mac/Win 10.1
FM.GetSQLBatchMode Queries turbo level for sending SQL in chunks.	All 6.4
FM.InitMessageFilter Initializes COM message filter.	Win only 8.3
FM.InsertOrUpdateRecord Inserts or updates a record in a table in one line.	All 6.0
FM.InsertOrUpdateRecord2 Inserts or updates a record in a table in one line.	All 6.1
FM.InsertOrUpdateRecord3 Inserts or updates a record in a table in one line.	All 6.1
FM.InsertOrUpdateRecord4 Inserts or updates a record in a table in one line.	All 11.2
FM.InsertOrUpdateRecord5 Inserts or updates a record in a table in one line.	All 11.2
FM.InsertOrUpdateRecordQuery Insert or updates a lot of records queried from a database.	All 8.4
FM.InsertRecord Inserts a new record in a table in one line.	All 5.1
FM.InsertRecordCSV Inserts records based on CSV text.	All 7.4
FM.InsertRecordQuery Inserts a lot of records queried from a database.	All 5.1
FM.InsertRecordQueryIgnoreDuplicates Inserts a lot of records queried from a database.	All 6.0
FM.InsertRecordTSV Inserts records based on tab/return separated text.	All 5.3
FM.InsertSetUpdateProgressDialog Enable updating progress bar.	Mac/Win 6.2
FM.IsMainThread Checks if current thread is main thread.	All 5.1
FM.LayoutIDForLayoutName Queries the ID for layout with given name.	All 10.2
FM.LayoutNameForLayoutID Queries layout name for a layout ID.	All 10.2
FM.LayoutNames Queries list of layout names in current file.	All 10.2
FM.Loop Universal function to run a loop with evaluate.	All 8.2
FM.MainThreadID Queries main thread ID.	All 5.1
FM.MouseWheelScriptTrigger Installs a script trigger for mouse wheel.	Mac/Win 6.3
FM.NULL Returns a null value.	All 5.1
FM.PatchNotificationProblem Patched problem with Scroll Notifications.	Mac only 8.1
FM.QueryBaseTableNames Queries the base table names of all tables currently open.	All 3.1
FM.QueryFieldsForBaseTableName Queries the field names of all fields in the given table.	All 3.1
FM.QueryFieldsForTableName Queries the field names of all fields in the given table.	All 3.1
FM.QueryTableNames Queries the table names of all tables currently open.	All 3.1
FM.RunDatabaseDesignReport Performs a data design report automatically.	Mac/Win 5.0
FM.RunSaveAsXML Saves database as XML.	Mac/Win 9.2
FM.RunScript Runs a script in any open FileMaker file.	All 1.2
FM.RunScriptIdle Runs a script after idle period.	Mac/Win/Linux 3.3
FM.RunScriptLater Runs a script in any open FileMaker file.	All 1.2
FM.SQL.Avg Calculates average value in a record set.	All 9.1
FM.SQL.CSV Queries text of SQL result for CSV export.	All 7.0
FM.SQL.Execute Execute the SQL Statement against a FileMaker database.	All 5.1
FM.SQL.Field Queries field value for given position in result.	All 5.1
FM.SQL.FieldCount Queries number of fields.	All 5.1
FM.SQL.FieldType Queries field type for given position in result.	All 5.1
FM.SQL.InsertRecords Inserts records in FileMaker database from records in memory.	All 6.4
FM.SQL.InsertRecordsToSQL Inserts records in SQL database from records in memory.	All 6.4
FM.SQL.JSONColumn Returns a column as JSON array.	All 10.5
FM.SQL.JSONRecord Returns a row as JSON object.	All 8.1
FM.SQL.JSONRecords Returns rows as JSON array.	All 8.1
FM.SQL.Max Queries max value in a record set.	All 9.1
FM.SQL.Min Queries min value in a record set.	All 9.1
FM.SQL.Release Releases memory used for the SQL result.	All 5.1
FM.SQL.ReleaseAll Release all FMSQL objects.	All 10.5
FM.SQL.RowCount Queries number of rows in the result.	All 5.1
FM.SQL.Sum Calculates sum value in a record set.	All 9.1
FM.SQL.Text Queries text of SQL result.	All 7.0
FM.SQL.XMLRecord Returns a row as XML object.	All 10.3
FM.SQL.XMLRecords Returns rows as XML.	All 10.3
FM.ScriptIDForScriptName Queries the ID for script with given name.	All 5.1
FM.ScriptNameForScriptID Queries script name for a script ID.	All 5.1
FM.ScriptNames Queries list of script names in current file.	All 5.1
FM.SetDisableContextualMenus Whether to disable contextual menus.	Mac/Win 10.1
FM.SetSQLBatchMode Sets turbo level for sending SQL in chunks.	All 6.4
FM.SetThreadName Sets a new name for a thread.	All 6.0
FM.StopScriptIdle Stops any idle timer.	Mac/Win/Linux 5.0
FM.TableStatistics Queries statistics on a table.	All 8.2
FM.UpdateRecord Update an existing record in a table in one line.	All 6.0
FM.UpdateRecord2 Updates existing records in a table in one line.	All 8.0
FM.UpdateRecord3 Updates existing records in a table in one line.	All 8.0
FM.UpdateRecords Updates existing records in a table in one line.	All 6.0
FM.UpdateRecords2 Updates existing records in a table in one line.	All 8.0
FM.UpdateRecords3 Updates existing records in a table in one line.	All 8.0
FM.VariableAdd Adds a value to a given variable atomically.	All 8.3
FM.VariableAppend Appends text to a variable.	All 9.5
FM.VariableClear Destroys a variable that was declared with FM.VariableSet.	All 1.2
FM.VariableClearAll Clears all variables.	All 5.2
FM.VariableExists Checks if a variable with that name exists.	All 4.0
FM.VariableGet Retrieves the value of named variable that was declared using FM.VariableSet.	All 1.2
FM.VariableList Returns list of all variables names and values.	All 4.0
FM.VariableNames Queries list of all variable names.	All 8.0
FM.VariableReset Resets the list of variables.	All 4.0
FM.VariableSet Stores a named variable that can be retrieved later using FM.VariableGet.	All 1.2

105 functions.

Release notes

Version 11.2
- Added flag 4 for FM.SQL.JSONRecords and FM.SQL.JSONRecord to return result as array of arrays instead of array of objects.
- Added FM.InsertOrUpdateRecord4 and FM.InsertOrUpdateRecord5.
- Changed FM.InsertRecordCSV and FM.InsertRecordTSV to recognize backslash escapes to have returns and tabs escaped in text.
Version 11.1
- Fixed memory leak in FM.SQL.JSONRecord and Matrix.JSONRecord functions.
Version 11.0
- Fixed issue with FM.SQL.JSONRecord, FM.SQL.JSONRecords and Dictionary.ToJSON where long numbers where truncated to double precision.
Version 10.5
- Added AVExport.ReleaseAll, AVRecorder.ReleaseAll, CoreML.ReleaseAll, DNSLookup.ReleaseAll, Dictionary.ReleaseAll, FM.SQL.ReleaseAll, JS.ReleaseAll, JavaScript.ReleaseAll, LDAP.ReleaseAll, PDFKit.ReleaseAll, PKCS12.ReleaseAll, PKCS7.ReleaseAll, PKey.ReleaseAll, SSH.ReleaseAll, WinSendMail.ReleaseAll, WindowsML.ReleaseAll, WordFile.ReleaseAll, and X509.ReleaseAll.
- Added FM.SQL.JSONColumn function.
Version 10.4
- Fixed FM.RunDatabaseDesignReport and FM.RunSaveAsXML to pass directory for macOS again. If possible we now skip the save dialog and tell FileMaker where to save directly.
Version 10.3
- Changed WIA.ImageDialog and WIA.SelectDeviceDialog to call FM.InitMessageFilter internally to avoid running into COM error dialogs.
- Fixed an edge case with FM.Loop function where start and end value are zero.
Version 10.2
- Added FM.CurrentLayoutID, FM.CurrentLayoutName, FM.LayoutIDForLayoutName, FM.LayoutNameForLayoutID and FM.LayoutNames matching similar functions for scripts.
Version 10.1
- Added FM.GetDisableContextualMenus and FM.SetDisableContextualMenus functions to disable contextual menus.
- Changed FM.InsertRecord, FM.CompareTables, FM.DeleteRecord, FM.DeleteRecords, FM.InsertOrUpdateRecord and FM.UpdateRecord to take table name from first field name if table name is empty.
- Fixed issue with FM.RunDatabaseDesignReport to work in MacOS Catalina. Needs accessibility permissions in system preferences to click save button.
Version 10.0
- Changed FM.TableStatistics to ignore calculated and global fields.

Blog Entries

FileMaker Magazin

Example Databases

Feedback: Report problem or ask question.