Greetings,

I have a large database I maintain for a company I work for. They have asked me to keep track of changes on one particular field. I have a good idea how to accomplish this with script triggers on that field, the problem I am facing is that this field could be on hundreds of layouts, and it is always possible someone could add it temporarily to a layout through the "modify layout" button.

My changelog script would simply be another table with Key Index, Time Stamp, User ID, Before, and After. I think a script trigger would be easy enough to do it.. I think a on modify trigger?

But, is there a way to apply this script to that one field in the database on all layouts? Otherwise, I just don't see how I can do it.

Unless I am missing some blatantly obvious way to do this without Script Triggers.

Any advice would be most welcome.

Thanks!

Edward

You could almost do what you want with an auto-enter calculation, but to store the before and after values would require a script trigger AFAIK. One option is to use a plugin, which can trigger a script at the calculation level, i.e. it's not dependent on layouts. For example: http://www.myfmbutler.com/index.lasso?p=416

Would that plugin work on Filemaker Pro 10 Advanced Server? I couldn't find anything information about server edition on the site you sent.

I had considered using an auto-Calculation, but couldn't wrap my head around it, since it would require new records to be populating another table... but then again.. with a timestamp as one of the join criteria which would always be different, would ensure unique records, but and the before and after part is a little tricky.

Still trying to think of something... seems like a changelog should be pretty easy.. I just don't see how to make it available to all layouts without doing them one by one.

Thanks,

I think that a simple solution could be to use a ( free ) script trigger plugin like this:

http://www.softs4hum...ro_Plugins.html

Edit: didn't see Fitch's post.

Not sure about running a script trigger plugin server-side, you'd have to ask the vendor.

If you opt to go with an auto-enter calc instead, it would have to be in the same table.

Now I remember there is a great demo of this, and it does capture before and after values:

http://www.nightwing.com.au/FileMaker/demos8/demo809.html

Maybe you could run a nightly script that saves the log data to a different table, if you're worried about deleted records, or whatever your concern is about having the field in the same table.