Monkeybread Software - MBS FileMaker Plugin: Component: FM

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

Component: FM

Functions for Claris FileMaker core functions like running scripts.

Version	macOS	Windows	Linux	Server	iOS SDK
1.2 / 14.4	✅ 98%	✅ 93%	✅ 83%	✅ 83%	✅ 82%

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

121 functions shown.

These functions require a license (60%).

Release notes

Version 14.4
- Added FieldName entry for FM.FieldStatistics function result.
- Added FM.FieldStatistics function.
- Fixed a bug in FM.FieldStatistics function. Now properly quotes field names.
Version 14.3
- Added FM.RecordStatistics function.
- Added TotalSize entry for FM.TableStatistics and FM.RecordStatistics.
Version 14.2
- Added firstRow and lastRow parameter to FM.SQL.JSONRecords and FM.SQL.XMLRecords functions.
- Enabled ALTER and CREATE commands to be used on server with FM.ExecuteFileSQL function.
- Fixed a bug in FM.SQL.InsertRecords that prevented containers from being transferred.
- Improved FM.SQL.JSONRecords function to return empty array for empty result.
Version 14.1
- Added CF function as a shortcut for FM.CF function, which assumes you store custom functions in a dictionary named CF.
Version 14.0
- Added FM.SQL.ToMatrix function.
- Changed FM.DeleteRecords to return OK if no record was found.
Version 13.3
- Fixed FM.ScriptNames for database file with dots inside.
Version 13.2
- Changed field quoting for FM.SQL.InsertRecordsToSQL and Matrix.InsertRecordsToSQL to handle non ANSI quotes for MySQL/MariaDB.
- Fixed FM.SQL.Field function to handle flags better.
- Fixed FM.SQL.Field function to return a name if there is no FNAM stream.
Version 13.1
- Added FM.TextWithDataType function.
- Fixed FM.SQL.InsertRecords, FM.SQL.InsertRecordsToSQL, Matrix.InsertRecordsToSQL and Matrix.InsertRecords to quote the table name for the SQL used internally.
Version 13.0
- Added new flags parameter to FM.SQL.CSV and Matrix.CSV.
- Changed FM.SQL.Text and FM.SQL.CSV functions to return empty text if there are no rows and no row parameter.
- Deprecated FM.GetDictionary and FM.GetDictionaryList functions.

Blog Entries

FileMaker Magazin

Example Databases

💬 Ask a question or report a problem