Jump to content

Sublime Audit Log

This topic is 2905 days old. Please don't post here. Open a new topic instead.

Recommended Posts

No Access? Watch the preview video here. SublimeAudit_Pre.mp4
Attachment Size
SublimeAudit1.0.zip 216.05 KB
By Matt Petrowsky

Over my many years of FileMaker Pro development, I’ve often heard the following, “Why can’t they just build that feature in?”. This type of request pretty much applies to everything you can think of.

I can even recall wishing personally that simply flipping a switch for automatic audit logging would be nice. While having that wish come true would still be a nice convenience, it would take away from the learning and understanding one can have when implementing such a feature. It may also rob us of the flexibility we so often enjoy when working with FileMaker.

I’ve seen a lot of audit logging solutions and they all have their various approach. Some use a plug-in in order to access the full set of FileMaker’s SQL support. Others take a native approach and simply try to account for all fields on the layout and replicate the data into a single table. I’ve seen complex systems which add a lot of extra fields to a dedicated audit log table where they track the layout, the table occurrence, the base table and more data than may be necessary.

With some solutions, those provided for purchase, you’ll get the full suite of features. These include creates, deletes, changes and rollback support. However, in many cases, you may just need something simple which keeps track of the changes made to records.

In this video, I showcase an advanced level of knowledge wrapped around a very simple approach to audit logging. If you’ve never considered, or even avoided implementing an audit log to your solution, then you may be surprised at how easy it can actually be. This video will provide you with the insight and know-how in order to implement a powerful audit log in a quick and easy fashion.

External links

FMEasyAudit Wikipedia Audit Trail

View the full article

Link to comment
Share on other sites

This topic is 2905 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.