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: 10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4   11.5    Statistic    FMM    Blog  

Component: FM

Functions for FileMaker core functions like running scripts.

Version macOS Windows Linux Server iOS SDK
1.2 / 11.3 ✅ 97% ✅ 94% ✅ 83% ✅ 83% ✅ 81%

Item Details 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
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.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
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.ExecuteSQL
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
This is similar to FM.ExecuteSQL, except that it waits until idle to execute.
Mac/Win
1.2
  ✅ Server
FM.GetDictionary
Queries current dictionary.
Mac only
9.4
  ❌ Server
FM.GetDictionaryList
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.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.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.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.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.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.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.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

108 functions shown.

Release notes

Blog Entries

FileMaker Magazin

Example Databases

Videos

Feedback: Report problem or ask question.




Links
MBS FileMaker blog

Start Chat