Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.0   7.1   7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3    Statistic  


Same as Audit.Changed, but here you pass the list of fields to check.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
Audit 3.1 Yes Yes Yes Yes Yes

MBS( "Audit.Changed2"; timestamp; TableName; FieldsToCheck )


Parameter Description Example value
timestamp Pass here the timestamp field you added for auditing to the table. AuditTimeStamp
TableName The name of the table. "Firma"
FieldsToCheck A list of field names to check. "myField"


Returns 1.


Same as Audit.Changed, but here you pass the list of fields to check.
With plugin version 4.4 you can use * on the end of the name to match all names starting with same text.


Log record on changes:

MBS( "Audit.Changed2"; MyTable::AuditTimeStamp; "MyTable"; "firstName"; "lastName"; "age" )

Run Audit.Changed2 with list of fields in a global field in the table:

Evaluate("MBS(\"Audit.Changed2\"; GetAsTimeStamp(\"" & Events::AuditTimeStamp & "\"); \"Events\"; \"" & Substitute(Events::AuditFields; "¶"; "\"; \"") & "\")")

Run Audit with GetFieldName with v8.3 or newer:

MBS("Audit.Changed2"; // call with positive list
AuditTimeStamp; // the timestamp field to trigger this
"Audit"; // the name of table
GetFieldName ( SomeText); // the fields to check
GetFieldName ( SomeNumber);
GetFieldName ( SomeTime);
GetFieldName ( SomeTimeStamp);
GetFieldName ( SomeContainer);
"InsideScript|" & $$InsideScript) // and we pass an extra field with global variable

See also

Example Databases

Audit.Changed   -   Audit.ClearCaches

Feedback: Report problem or ask question.

MBS FileMaker Plugins