Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 9.0   9.1   9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3    Statistic  

Component: Matrix

Matrix functions

Two dimensionals lists.

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.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.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.Free
Frees the matrix object.
All
9.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
Queres 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.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.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.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.SetColumn
Sets a column to the given texts.
All
9.2
Matrix.SetColumnName
Sets column name.
All
10.2
Matrix.SetRow
Sets a row to the given texts.
All
9.2
Matrix.SetRowName
Sets row name.
All
10.2
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

44 functions.

Release notes

Blog Entries

Feedback: Report problem or ask question.




Links
MBS FileMaker blog