[FMP Tip-n-Trick] FileMaker Pro 13 Easy-Bake Audit Trail
FileMaker Pro 13 Tip-n-nTrick: Easy-Bake FileMaker Pro 13 Audit Trail
There are many ways to implement audit logs in FileMaker Pro 13, but I’m always on the lookout for the method with the least overhead. If you don’t need separate records in another table for every field change, then you can keep track of field changes using FileMaker 13’s new Get(ModifiedFields) command and the following:
- A custom function to handle the heavy-lifting
- A text field to call the custom function and store our change log
- A script step to set a list of ignored field names in a script that runs when the file opens
- A modification timestamp field to trigger the log
There’s a good chance that you already have a modification timestamp in your solutions, and the field to store the log itself would be required with any approach. So that means our “overhead” is limited to one custom function and one script step. That makes it quite easy to implement this FileMaker Pro 13 audit trail in any solution.
OK, so maybe that was a little too easy! The only problem I’ve found with this approach is that the initial values entered on a new record won’t get tracked unless we commit the record right after it’s created. This file has a custom menu set to override the New Record menu command with a script to take care of this nuance for us. If you already script the new record creation process in your solution, then you can incorporate this additional step into your existing script(s).
What do you think? Can we make this any easier while maintaining the simplicity, performance, and flexibility?
About eXcelisys, Inc.: Founded in 2001, eXcelisys (www.excelisys.com) is an FBA Platinum Partner and FileMaker Certified developer organization specializing in the designing, developing, customizing, supporting, consulting, migrating, upgrading, tweaking, fixing, and integrating of FileMaker Pro solutions, FileMaker Go solutions, MySQL, PostgreSQL, QuickBooks-FileMaker Pro Integration, Excel and MS Access FileMaker Pro conversions/migrations, iPhone and iPad business solutions, and other various database technologies and frameworks that automate your organization’s data solution needs for use on the web, mobile, and desktop platforms. Contact eXcelisys today for a free estimate and consultation about your business software automation needs @ 866-592-9235.