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: 11.4   11.5   12.0   12.1   12.2   12.3   12.4   12.5   13.0   13.1    Statistic    FMM    Blog  


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

Component Version macOS Windows Linux Server iOS SDK
Audit 3.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Audit.Changed2"; timestamp; TableName; FieldsToCheck )   More


Parameter Description Example
timestamp Pass here the timestamp field you added for auditing to the table. AuditTimeStamp
TableName The name of the table.
Or the table occurrence if needed.

With 10.2 optionally as second value the name of the audit log table unless you take the default AuditLog.
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.
The Audit.Changed2 function with passing field list is quicker than the Audit.Changed function as we skip querying the field list from FileMaker.


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

Do Audit and set custom TransactionUUID field with UUID:

MBS( "Audit.Changed2"; MyTable::AuditTimeStamp; "MyTable"; "firstName"; "lastName"; "age"; "TransactionUUID|" & Get(UUID) )

See also

Release notes

Example Databases

Blog Entries

This function checks for a paid license.

Created 18th August 2014, last changed 16th February 2023

Audit.Changed - Audit.ClearCaches

💬 Ask a question or report a problem

Start Chat