Recording modification history in FMP 9

[luggerite]

Forgive me if this is self-evident or I've missed the answer trawling through the forum....

Is there any way to intercept the automated "Save changes to this record?" dialog in FMP9 to get it to trigger a script? Yes I know this would be easy in FMP10 with script triggers, but upgrading isn't an option currently.

I need to be able to automatically record and track all changes/edits made to data in a database. Specifically, I need to:

1. Have a record of who has made a change

2. When they made it

3. What the change was....

I can set up a related table linked by the Record ID to create a new record when changes are made using a Commit Record script step manually triggered by a "Save changes" button which saves the modifiers account name and timestamp. However ideally I'd like it to do it automatically when the record is committed, and importantly, to record the change made, or at least the fields which were changed (up to 20 possible fields).

Any ideas?

[comment]

You could make the layout commit by button only:

http://fmforums.com/forum/showtopic.php?tid/190810/post/269884/#269884

or use an event-triggering plugin.

But you don't really a script for this - see:

http://www.fmforums.com/forum/showpost.php?post/251865/