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:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
Statistic
FMM
Blog
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.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.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 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.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.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 |
46 functions.
Release notes
- Version 10.5
- Added Matrix.CSVSplit function.
- Added Matrix.ReleaseAll and renamed Matrix.Free to Matrix.Release.
- Version 10.4
- Deprecated MatrixDongle functions.
- Version 10.3
- Added Matrix.Multiply function.
- Version 10.2
- Added column and row names for Matrix functions.
- Added Matrix.Add function.
- Added Matrix.CopyColumn and Matrix.CopyRow functions.
- Added Matrix.Evaluate function.
- Version 9.2
- Added Matrix functions for a two dimensional list with FileMaker native data types.
Blog Entries
- MBS FileMaker Plugin, version 10.4pr2
- MBS FileMaker Plugin 10.2 - More than 6200 Functions In One Plugin
- MBS FileMaker Plugin, version 10.2pr2
- Was gibt es neues bei MBS Version 9.2
- Neues MBS FileMaker Plugin 9.2
- MBS FileMaker Plugin 9.2 - More than 5800 Functions In One Plugin
- MBS FileMaker Plugin, version 9.2pr3
- MBS FileMaker Plugin 5.2 for OS X/Windows - More than 3200 Functions
Feedback: Report problem or ask question.

Links
MBS Xojo tutorial videos