| 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 / 16.2 | ✅ 98% | ✅ 92% | ✅ 82% | ✅ 82% | ✅ 81% |
| Item | Details | Server |
|---|---|---|
| CF Shorter version for FM.CF. | All 14.1 |
✅ Server |
| FM.AddErrorMessage Adds a custom error to the error list used by the plugin. | All 15.5 |
✅ 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 Deprecated 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.LastParameters New in 16.2 Queries parameters from last failed SQL command. | All 16.2 |
✅ 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 Queries statistics on a field. | All 14.4 |
✅ Server |
| FM.Get Queries a Get() function by ID. | All 15.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 Deprecated 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.ModifyTableView Triggers the button to modify a table view and pick fields. | Mac/Win 15.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 Deprecated 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.InsertOrUpdateRecords New in 16.1 Insert or updates a lot of records queried from a database. | All 16.1 |
✅ Server |
| FM.SQL.InsertOrUpdateRecordsToSQL New in 16.1 Insert or updates a lot of records queried from a database. | All 16.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 Deprecated 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.UpdateRecord4 Updates existing records in a table in one line. | All 14.5 |
✅ Server |
| FM.UpdateRecord5 Updates existing records in a table in one line. | All 14.5 |
✅ 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.UpdateRecords4 Updates existing records in a table in one line. | All 14.5 |
✅ Server |
| FM.UpdateRecords5 Updates existing records in a table in one line. | All 14.5 |
✅ 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 |
120 functions shown.
These functions require a license (57%).
Release notes
- Version 16.1
- Added FM.SQL.InsertOrUpdateRecords and Matrix.InsertOrUpdateRecords functions.
- Added FM.SQL.InsertOrUpdateRecordsToSQL and Matrix.InsertOrUpdateRecordsToSQL functions.
- Deprecated FM.GetSQLBatchMode and FM.SetSQLBatchMode.
- Fixed a problem with FM.TableStatistics function not counting JPEGs in container correctly.
- Improved Matrix.InsertRecordsToSQL and FM.SQL.InsertRecordsToSQL functions to pass NULL if a number or date field is empty. Otherwise SQL would complain about passing invalid date or number.
- Rewrote FM.InsertOrUpdateRecordQuery to use newer code base.
- Rewrote FM.InsertRecordQuery and FM.InsertRecordQueryIgnoreDuplicates to use newer code base.
- Rewrote FM.SQL.InsertRecords and Matrix.InsertRecords functions to use same code internal.
- Rewrote FM.SQL.InsertRecordsToSQL and Matrix.InsertRecordsToSQL functions to use same code internal.
- Version 16.0
- Changed FM.SQL.InsertRecordsToSQL and related functions to use backtick to quote table names for ODBC connections.
- Fixed a text encoding problem for FM.AddErrorMessage function.
- Fixed an issue with FM.InsertOrUpdateRecord and field names containing double colon.
- Version 15.5
- Added FM.AddErrorMessage function.
- Added newer error codes for FileMaker 2025 to the FM.ErrorMessage function.
- Version 15.4
- Added DetectJSON flag to FM.SQL.JSONColumn, FM.SQL.JSONRecord and FM.SQL.JSONRecords.
- Added FM.Get function.
- Version 14.5
- Added CurrentTimeStamp field to the JSON for FM.TableStatistics, FM.RecordStatistics and FM.FieldStatistics functions.
- Added FM.UpdateRecord4, FM.UpdateRecord5, FM.UpdateRecords4 and FM.UpdateRecords5 functions.
- Improved FM.QueryBaseTableNames to use newer API in FileMaker 21.0 and newer.
- Improved FM.TableStatistics function to ignore summary fields.
- Improved type detection for FM.InsertRecordCSV function.
- 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
Blog Entries
- MBS FileMaker Plugin 16.1 News
- MBS FileMaker Advent calendar - Door 15 - Information about tables and base tables
- New in MBS FileMaker Plugin 14.4
- New in MBS FileMaker Plugin 12.0
- MBS FileMaker Plugin 3.0 for OS X/Windows - More than 1300 Functions In One Plugin
FileMaker Magazin
- Ausgabe 2/2025, Seite 23 bis 24
- Ausgabe 2/2022, Seite 29
- Ausgabe 1/2021, Seite 29 bis 31
- Ausgabe 6/2020, Seite 25 bis 26
- Ausgabe 5/2020, Seite 20
- Ausgabe 3/2020, Seite 40
- Ausgabe 6/2019, Seite 33
- Ausgabe 4/2019, Seite 32 bis 35
- Ausgabe 4/2019, Seite 27
- Ausgabe 3/2019, Seite 30
Example Databases
- CURL/Email/Email Client
- CURL/Email/IMAP Email List
- CURL/WebViewer Download Images with CURL
- Drag and Drop/for Mac/Text drag from one database to other/Text drop
- Mac and iOS/Events/Events Sync
- SQL in FileMaker/Custom Functions to Log Scriptcalls
- SQL in FileMaker/Insert or Update Tests
- Text functions/TSV Import
- Third Party/FileMaker Snippet Storage
- Utility functions/Global Variables
