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.

Features include:

• 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
• It's free. ;-)

The example solution can be found in the "Tips" section of the CNS website.