| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Matrix.Lookup
Queries value without errors.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| Matrix | 13.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "Matrix.Lookup" { ; MatrixRef; Row; Column; Default Value } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| MatrixRef | The matrix reference number. | $matrix | Optional |
| Row | The zero based row number. Default is zero. |
2 | Optional |
| Column | The zero based column number. Default is zero. |
2 | Optional |
| Default Value | The default value to return in case of an error. | Optional |
Result
Returns value or default value.
Description
Queries value without errors.Retains original data type.
See also Matrix.GetValue function.
Examples
Try without parameters:
MBS("Matrix.Lookup")
Try with invalid row and column value:
let([
m = MBS("Matrix.New"; 3; 3);
r = MBS("Matrix.Lookup"; m; 5; 5; "test")
]; r)
Example result: test
Try with correct row and column:
let([
m = MBS("Matrix.New"; 3; 3);
s = MBS("Matrix.SetValue"; m; 2; 2; "value");
r = MBS("Matrix.Lookup"; m; 2; 2; "test")
]; r)
Example result: value
See also
Release notes
- Version 13.5
- Added Matrix.Lookup function to get a value without error for invalid parameters.
Blog Entries
- New in MBS FileMaker Plugin 13.5
- Data structures in MBS Plugin
- Neues MBS Plugin 13.5 für Claris FileMaker
- MBS Plugin 13.5 for Claris FileMaker
- MBS FileMaker Plugin, version 13.5pr1
This function checks for a license.
Created 24th September 2023, last changed 24th September 2023
