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:
12.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
13.4
13.5
Statistic
FMM
Blog
Matrix functions
Two dimensionals lists.
Use Matrix.New or Matrix.NewWithSQL to create the matrix objects.
Version | macOS | Windows | Linux | Server | iOS SDK |
9.2 / 13.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Item | Details |
---|---|
Matrix.Add Adds a value to cells in matrix. | All 10.2 |
Matrix.AddColumn Adds one column to a matrix. | All 9.2 |
Matrix.AddColumns Adds columns to a matrix. | All 9.2 |
Matrix.AddRow Adds a row to the matrix. | All 9.2 |
Matrix.AddRows Adds rows to the matrix. | All 9.2 |
Matrix.Avg Calculates average value in a matrix column. | All 9.2 |
Matrix.CSV Queries text of matrix for CSV export. | All 9.2 |
Matrix.CSVSplit Splits CSV text. | All 10.5 |
Matrix.Clear Clears the matrix. | All 9.2 |
Matrix.ClearValues Clears all values in the matrix. | All 9.2 |
Matrix.Clone Creates a copy of a matrix. | All 9.2 |
Matrix.ConvertDataType Converts the data types. | All 12.5 |
Matrix.CopyColumn Copies a column from one (or same) matrix to another column. | All 10.2 |
Matrix.CopyRow Copies a row from one (or same) matrix to another row. | All 10.2 |
Matrix.DataType Queries data type of a value. | All 9.2 |
Matrix.Evaluate Evaluates an expression for each cell. | All 10.2 |
Matrix.GetColumn Queries text of a whole column. | All 9.2 |
Matrix.GetColumnName Queres column name. | All 10.2 |
Matrix.GetColumnNames Queres column names. | All 10.2 |
Matrix.GetRow Queries text of a whole row. | All 9.2 |
Matrix.GetRowName Queres row name. | All 10.2 |
Matrix.GetRowNames Queries row names. | All 10.2 |
Matrix.GetText Queries text of whole matrix. | All 9.2 |
Matrix.GetValue Queries a single value. | All 9.2 |
Matrix.HTML Queries html of matrix. | All 13.3 |
Matrix.Height Queries height of matrix. | All 9.2 |
Matrix.InsertRecords Inserts records in FileMaker database from records in memory. | All 9.2 |
Matrix.InsertRecordsToSQL Inserts records in SQL database from records in memory. | All 9.2 |
Matrix.JSONRecord Returns a row as JSON object. | All 9.2 |
Matrix.JSONRecords Returns rows as JSON array. | All 9.2 |
Matrix.List Lists all IDs of current Matrix objects. | All 12.5 |
Matrix.Lookup New in 13.5 Queries value without errors. | All 13.5 |
Matrix.Max Queries max value in a matrix column. | All 9.2 |
Matrix.Min Queries min value in a matrix column. | All 9.2 |
Matrix.Multiply Multiplies a value with cells in matrix. | All 10.3 |
Matrix.New Creates a new matrix (2D array). | All 9.2 |
Matrix.NewWithSQL Execute the SQL Statement against a FileMaker database. | All 9.2 |
Matrix.Release Frees the matrix object. | All 9.2 |
Matrix.ReleaseAll Releases all matrix objects. | All 10.5 |
Matrix.RemoveColumn Removes a column. | All 9.2 |
Matrix.RemoveRow Removes a row. | All 9.2 |
Matrix.Resize Resizes matrix to given height and width. | All 9.2 |
Matrix.Rotate Rotates a matrix. | All 12.4 |
Matrix.SetColumn Sets a column to the given texts. | All 9.2 |
Matrix.SetColumnName Sets column name. | All 10.2 |
Matrix.SetColumnNames Sets column names. | All 12.5 |
Matrix.SetRow Sets a row to the given texts. | All 9.2 |
Matrix.SetRowName Sets row name. | All 10.2 |
Matrix.SetRowNames Sets row names. | All 12.5 |
Matrix.SetValue Sets a single value in the matrix. | All 9.2 |
Matrix.Sum Calculates sum value in a matrix column. | All 9.2 |
Matrix.Text Queries text of matrix. | All 9.2 |
Matrix.Width Queries width of matrix. | All 9.2 |
53 functions shown.
These functions require a license (94%).