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: 10.0   10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3    Statistic    FMM    Blog  


Log record.

Component Version macOS Windows Linux Server iOS SDK
Audit 8.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Audit.Backup"; timestamp; TableName { ; FieldsToIgnore... } )   More


Parameter Description Example Flags
timestamp Pass here the timestamp field you added for auditing to the table. AuditTimeStamp
TableName The name of the table.
With 10.2 optionally as second value the name of the audit log table unless you take the default AuditLog.
FieldsToIgnore... A list of field names to ignore.
Global fields and those set with Audit.SetIgnoredFieldNames are always ignored.
"myField" Optional


Returns OK or error.


Log record.
Same as Audit.Changed, but uses Backup for the action field.
You can call this function before loading a record to make sure all data from the record are logged. Then you are sure to have old values for an undo.

In the fields to ignore parameters you can pass extra values "FieldName|Value" to assign special values automatically to your fields. As this parameter can be build with a calculation, you can query variables or other tables for information you want to log.

This function takes variable number of parameters. Pass as much parameters as needed separated by the semicolon in FileMaker.
Please repeat FieldsToIgnore parameter as often as you need.


Run Backup and set a custom field with a special value:

MBS("audit.Backup"; Audit::AuditTimeStamp; "MyTable"; "Reason|Backup")

See also

Release notes

Blog Entries

Created 27th October 2018, last changed 5th June 2021

Archive.Verify - Audit.Backup2

Feedback: Report problem or ask question.

MBS FileMaker tutorial videos

Start Chat