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.0
12.1
12.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
Statistic
FMM
Blog
Component: Audit
Log all changes to your database.
For FileMaker Pro.
We define fields in each table which trigger our Audit function, so with any change in a record, the plugin can keep track of changes.
| Version | macOS | Windows | Linux | Server | iOS SDK |
| 2.8 / 13.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
| Item | Details |
|---|---|
| Audit.Backup Log record. | All 8.5 |
| Audit.Backup2 Log record. | All 8.5 |
| Audit.BaseTableNameForID Looks up the Audit cache for the base table name for a given table occurrence ID. | All 13.1 |
| Audit.Changed Log record change. | All 2.8 |
| Audit.Changed2 Same as Audit.Changed, but here you pass the list of fields to check. | All 3.1 |
| Audit.ClearCaches Clears internal caches for audit functions. | All 3.1 |
| Audit.Delete Log record deletion. | All 2.8 |
| Audit.Delete2 Same as Audit.Delete, but here you pass the list of fields to check. | All 3.1 |
| Audit.FieldIDForName Looks up the Audit cache for a field name. | All 8.2 |
| Audit.FieldNameForID Looks up the Audit cache for a field ID. | All 8.0 |
| Audit.GetDateAndTimeAsNumbers Queries state for this option. | All 12.3 |
| Audit.GetEnabled Queries enable status. | All 7.1 |
| Audit.GetIgnoreCalculations Queries whether stored calculations are audited. | All 4.4 |
| Audit.GetIgnoreRepetitions Queries whether repetition fields should be ignored. | All 10.3 |
| Audit.GetIgnoreSummaryFields Queries whether summary fields are audited. | All 5.4 |
| Audit.GetIgnoreUnderscoreFieldNames Queries the state of the underscore ignore setting. | All 5.3 |
| Audit.GetIgnoredFieldNames Queries list of ignored field names. | All 7.3 |
| Audit.GetLogAccess Queries whether plugin logs access. | All 4.1 |
| Audit.GetUUIDField Queries UUID field name. | All 7.3 |
| Audit.Hash Hashes the field/value. | All 11.1 |
| Audit.SetDateAndTimeAsNumbers Sets whether time values are stored as numbers. | All 12.3 |
| Audit.SetEnabled Turns audit globally on or off. | All 7.1 |
| Audit.SetIgnoreCalculations Set whether stored calculations are audited. | All 4.4 |
| Audit.SetIgnoreRepetitions Whether to ignore repetitions. | All 10.3 |
| Audit.SetIgnoreSummaryFields Set whether summary fields are audited. | All 5.4 |
| Audit.SetIgnoreUnderscoreFieldNames Sets whether to ignore all field names whose name starts with underscore character. | All 5.3 |
| Audit.SetIgnoredFieldNames Sets the ignored field names. | All 2.8 |
| Audit.SetLogAccess Sets whether access is logged. | All 4.1 |
| Audit.SetUUIDField Sets the UUID field name. | All 7.3 |
| Audit.Statistics Queries statistics for Audit functions. | All 12.1 |
| Audit.TableIDForName Looks up the Audit cache for a table name. | All 8.2 |
| Audit.TableNameForID Looks up the Audit cache for the table name for a given table occurrence ID. | All 8.0 |
32 functions shown.
9 functions require a paid license (28%) and 23 functions are free to use.
Release notes
- Version 13.2
- Changed Audit.Delete and Audit.Delete2 to record new fields found before deleting with Delete instead of Create.
- Version 13.1
- Added Audit.BaseTableNameForID function.
- Version 12.3
- Added Audit.GetDateAndTimeAsNumbers and Audit.SetDateAndTimeAsNumbers to log dates, times and timestamps as numbers instead of text.
- Version 12.2
- Added SchemaCacheFlushed counter for Audit.Statistics function to show how often we flushed the table cache.
- Version 12.1
- Added Audit.Statistics function.
- Fixed bugs in Audit.Changed when using repetition fields.
- Version 12.0
- Fixed handling of PageNumber field for Audit.Changed functions.
- Version 10.4
- Changed Audit.SetIgnoreSummaryFields and Audit.SetIgnoreCalculations to clear field cache, so the setting is applied sooner.
- 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.
- Fixed an issue where Audit.Changed would rebuild the table cache too often.
- Improved Audit.Changed and related to only query table list once per call.
- Version 10.3
- Added Audit.GetIgnoreRepetitions and Audit.SetIgnoreRepetitions functions.
- Added support for non global repeating fields to Audit functions.
- Removed older code paths for Audit functions for FileMaker 10 and older. Now FileMaker 11 is minimum.
- Rewrote Audit functions to use SQL parameters, so we can log emojis and avoid SQL injections.
- Version 10.2
- For Audit.Changed and Audit.Changed2 you can now customize AuditLog table name. The table name parameter can be a list and include first the table name for the table to check and second the name of the audit table name. If second is empty, we default to AuditLog.
Blog Entries
- Configure Audit functions in MBS Plugin
- New in MBS FileMaker Plugin 12.1
- MBS FileMaker Plugin 12.1 - More than 6700 Functions In One Plugin
- MBS FileMaker Plugin, June 2021 News
- MBS FileMaker Plugin 10.4 - More than 6300 Functions In One Plugin
- Perform Script on Server with Audit for FileMaker Go
- MBS FileMaker Plugin 10.3 - More than 6200 Functions In One Plugin
- MBS FileMaker Plugin, version 10.3pr1
- MBS FileMaker Plugin, version 10.2pr4
- MBS FileMaker Plugin 8.3 released
FileMaker Magazin
Example Databases
