| 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 / 16.1 | ✅ 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.Append Appends second matrix to first one. | All 15.3 |
| 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.CopyContent Copies the content of a matrix into another matrix. | All 15.3 |
| 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 Queries column name. | All 10.2 |
| Matrix.GetColumnNames Queries column names. | All 10.2 |
| Matrix.GetRow Queries text of a whole row. | All 9.2 |
| Matrix.GetRowName Queries 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 Finds index of first value matching value. | All 14.0 |
| Matrix.InsertColumn Inserts one column into a matrix. | All 15.3 |
| Matrix.InsertOrUpdateRecords New in 16.1 Insert or updates a lot of records queried from a database. | All 16.1 |
| Matrix.InsertOrUpdateRecordsToSQL New in 16.1 Insert or updates a lot of records queried from a database. | All 16.1 |
| 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.InsertRow Inserts one row into a matrix. | All 15.3 |
| 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 |
60 functions shown.
These functions require a license (92%).
Release notes
- Version 15.4
- Added DetectJSON flag to Matrix.JSONRecord and Matrix.JSONRecords.
- Version 15.3
- Added Matrix.Append function.
- Added Matrix.InsertRow and Matrix.InsertColumn functions.
- Version 14.4
- Fixed a bug with Matrix.Text function where it would skip some columns if they were constants in SQL used to create the matrix.
- Version 14.3
- Added header row flag for Matrix.CSVSplit to put first row into column names.
- Changed Matrix.CSVSplit to handle CSV with multi line values better.
- Changed Matrix.JSONRecord and Matrix.JSONRecords to take field names from column names, if you have some and you don't pass field names.
- Version 14.2
- Added firstRow and lastRow parameter to Matrix.JSONRecords function.
- Added flag 16 for Matrix.JSONRecords to include field names as first row if outputting arrays.
- Improved Matrix.HTML and JSON.ToHTML to use CSS for right alignment.
- Version 14.0
- Added CSS parameter for Matrix.HTML function.
- Added Matrix.IndexOfFirstValueMatching function.
- Fixed a problem in Matrix.CopyRow when using row names.
- Version 13.5
- Added Flags Parameter for Matrix.HTML function.
- Added Flags Parmeter for Matrix.Evaluate. Pass 2 to continue after error.
- Added Matrix.Lookup function to get a value without error for invalid parameters.
- Improved Matrix.Evaluate and Matrix.Current to work better in multi threading environments.
- Version 13.3
- Added Matrix.HTML function.
- Version 13.2
- Changed field quoting for FM.SQL.InsertRecordsToSQL and Matrix.InsertRecordsToSQL to handle non ANSI quotes for MySQL/MariaDB.
Blog Entries
- MBS FileMaker Advent calendar - Door 4 - FM.SQL.Executeand life in the matrix
- MBS Plugin 15.3 for Claris FileMaker
- MBS @ dotfmp 2024
- ISO FileMaker Magazine: Copy, Paste & Import Spreadsheet Data
- New in MBS FileMaker Plugin 14.0
- MBS Plugin 13.3 for Claris FileMaker
- MBS Plugin 12.5 for Claris FileMaker - More than 6800 Functions In One Plugin
- MBS FileMaker Plugin 10.2 - More than 6200 Functions In One Plugin
- MBS FileMaker Plugin, version 10.2pr2
- MBS FileMaker Plugin 9.2 - More than 5800 Functions In One Plugin
FileMaker Magazin
Example Databases
