FileMaker SQL Audit Trail
This solution uses the free BaseElements Plugin and uses SQL SELECT/INSERT/UPDATE/DELETE to generate an audit trail that requires very little setup to get it up and working. This solution will work with FileMaker Pro/Pro Advanced and Web Direct. (Plugin required on FMS for WebDirect).
PLEASE email me with any bug reports, suggestions, criticisms, etc! The sooner you tell me, the sooner I can get a fix put in place which in turn will benefit everyone else using this solution! Thank you!
I will provide announcements via my Twitter account: @FileMakerGeek when I make any updates.
NEWS
3/20/2017
- I have been working on an update to the SQL Audit Trail solution which squashes many bugs in the separation model version as well as the single file solution. I will be posting the update soon so please check back. I have also updated the documentation which will make implementation much more clear.
LIMITED VERSION: This version only tracks Creates and Edits. Transactions, delete tracking and rollbacks are NOT available in this version.
Sample File Download: fmSQL_AuditTrail-v104L.zip - SEE NEWS ABOVE
FULL VERSION: This version includes transactions, create/edit/delete tracking, and rollbacks.
Sample File Download: fmSQL_AuditTrail-v104.zip - SEE NEWS ABOVE
Slide Show Download: fmSQL_AuditTrail_Slides.zip
Search Results By Account Name
This solution file shows you how you can use custom menus and scripts to take control of searches so that users will only see the records that they are supposed to see.