CNS Audit

This free example demonstrates how to create an extremely flexible audit system to log field changes in your records. The bulk of the work is done through Custom Functions. Once the custom functions are set up, you can add logging to a table easily by creating two or three fields in your table and a layout with the fields that you would like to log. You can track any type of field including repeating fields and container fields.

• Uses custom functions to do 99% of the work
• Ability to log repeating fields
• Ability to log container field changes
• Fields can be created in any order
• Log is triggered via a modified timestamp field
• Ability to log related fields or not
• Uses a user defined layout to add/remove fields from logging
• Uses text formatting to aid in readability
• Adds a date banner to the log between different days
• Custom functions include comments
• Includes a white paper explaining how to recreate the example in your own solution

What is new in this release:

• Fixed a bug with the ListSiblingIDs function not working correctly.
• Consolidated internal code for the main logging functions to help in fixing many issues spread out across the functions.
• Updated the file caching code to take advantage of FileMaker Pro 11 features, including the ability to track schema changes and reload automatically. The FileMaker Pro 11 code also does not rely on the FieldIDs function anymore, alleviating the need to keep Layout names distinct from TO names.
• Renamed the Record function to RecordChange.
• Added RecordView and RecordOpen functions to better handle those actions without creating extraneous records in the CNS Access Log table.
• Reworked the SuspendFile feature to make sense with the new functions.
• Fixed issues with loading/saving the Preferences from/to the CNS Audit Prefs table under FileMaker Pro 11.
• Added support for multi-file/data separation databases.
• Fixed several issues related to FileMaker Pro 11's new internal SQL interface.
• Imported core plug-in updates from other CNS Plug-ins.
• Added significant speed improvements throughout the plug-in, especially in the Init code and in processing the audit cache.
• Fixed some internal FileMaker calculations the plug-in was evaluating to use semicolons instead of commas, fixing issues with non-English locales.
• Added "Create Audit Tables" and "Check for Layout Conflicts" buttons to the Configuration Dialog to make it easier to set up a database for use with the plug-in.
• Fixed a bug in the Rollback function where it couldn't duplicate the record's history.
• Fixed a bug dealing with locating the record to audit and causing "New Portal Record" to show up in the CNS Audit Trigger field.

Requirements: