| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
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
- Version 13.2
- Changed Audit.Delete and Audit.Delete2 to record new fields found before deleting with Delete instead of Create.
- Version 10.4
- Fixed a crash in Audit functions when querying GetFieldID internally. Affects Audit.Backup, Audit.Backup2, Audit.Changed, Audit.Changed2, Audit.Delete and Audit.Delete2 functions.
Blog Entries
- MBS FileMaker Plugin, version 13.2pr2
- MBS FileMaker Plugin, version 10.4pr1
- MBS Filemaker Plugin, version 3.1pr6
This function checks for a license.
Created 18th August 2014, last changed 12nd May 2023
