| 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 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
- 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.
- Version 13.1
- Added flags parameter to Matrix.Text function and a flag for Matrix.CSV and Matrix.Text to include column names in first row.
- Fixed FM.SQL.InsertRecords, FM.SQL.InsertRecordsToSQL, Matrix.InsertRecordsToSQL and Matrix.InsertRecords to quote the table name for the SQL used internally.
- Version 13.0
- Added new flags parameter to FM.SQL.CSV and Matrix.CSV.
Blog Entries
- MBS @ dotfmp 2024
- ISO FileMaker Magazine: Copy, Paste & Import Spreadsheet Data
- New in MBS FileMaker Plugin 14.0
- Neues MBS Plugin 13.3 für Claris FileMaker
- 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
- MBS FileMaker Plugin, version 9.2pr3
FileMaker Magazin
Example Databases
