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

Component: Matrix

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 / 14.0 ✅ 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.IndexOfFirstValueMatching   New in 14.0
Finds index of first value matching value.
All
14.0
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
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

54 functions shown.

These functions require a license (94%).

Release notes

Blog Entries

FileMaker Magazin

Example Databases