Monkeybread Software - MBS FileMaker Plugin: Matrix.SetValue

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 10.6 Statistic FMM Blog

Matrix.SetValue

Sets a single value in the matrix.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
Matrix	9.2	Yes	Yes	Yes	Yes	Yes

MBS( "Matrix.SetValue"; MatrixRef; Row; Column { ; Value } ) More

Parameters

Parameter Description Example Flags

MatrixRef The matrix reference number. $matrix

Row The zero based row number. 2

Column The zero based column number. 2

Value The new value. "Hello" Optional

Parameter	Description	Example	Flags
MatrixRef	The matrix reference number.	$matrix
Row	The zero based row number.	2
Column	The zero based column number.	2
Value	The new value.	"Hello"	Optional

Result

Returns OK or error.

Description

Sets a single value in the matrix.
The original data type is retained.

Examples

Test set and get:

Set Variable [ $m ; Value: MBS ("Matrix.New"; 2; 2) ]
Set Variable [ $r ; Value: MBS( "Matrix.SetValue"; $m; 0; 0; Contacts::Company ) ]
Set Field [ Contacts::Job Title ; MBS( "Matrix.GetValue"; $m; 0; 0 ) ]
Set Variable [ $r ; Value: MBS ("Matrix.Release"; $m) ]

Sets a value:

Set Variable [ $r; Value: MBS("Matrix.SetValue"; $matrix;1;1;40) ]

Blog Entries

Matrix functions for FileMaker

FileMaker Magazin

Ausgabe 4/2019, Seite 30, PDF

Created 8th April 2019, last changed 2nd November 2020

Matrix.SetRowName - Matrix.Sum

Feedback: Report problem or ask question.