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: 12.1   12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4    Statistic    FMM    Blog  

Audit.Delete2

Same as Audit.Delete, 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.Delete2"; timestamp; TableName; FieldsToCheck... { ; ExtraFields... } )   More

Parameters

Parameter Description Example Flags
timestamp Pass here the timestamp field you added for auditing to the table.
This field is passed here to trigger the calculation, but the value is not used. Must be a timestamp.
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.
"Firma¶MyAuditLog"
FieldsToCheck... A list of field names to check. "myField"
ExtraFields... Custom fields to set.
Pass in field name followed by "|" character and a value.
Field type can be text or number.
"ScriptName|" & $ScriptName Optional

Result

Returns 1.

Description

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

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

Examples

Log record on delete:

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

See also

Release notes

Blog Entries

This function checks for a license.

Created 18th August 2014, last changed 12nd May 2023


Audit.Delete - Audit.FieldIDForName

💬 Ask a question or report a problem