Detect Record Change

[Tyra]

I have a database of approximately 10,000 records. Users do seaches for individual records and input changes to various fields. Need to figure out a way to detect when/if a change is made then call a script to export that individual record. Was focusing on the last modified field, but still not sure how to make it work. There is no script that currently runs to process record updates, so can't work it into that. Any thoughts would be appreciated.

[Jalz]

Hi Tyra,

It sounds like you want to trigger a script(export) of some sort when a record is modified. You can't do this natively, however you can do it using some of the available script triggering plugins like EventScript and ZippScript

[The Big Bear]

tyra

There are some excellent audit log function that do this beautiful.

do a search on audit log and you will find a couple web site.

One is Nightwing.com.aufilemaker

Lionel

[Tyra]

Thanks guys, I did see an example of using script paremiters and contanier names that although intensive, would work. I have decided to go about it a different way and add another script into my automated server scripts to check each record against the last time it was modified. Wont give me that instant update, but will work. Now, just trying to figure the best way to export each record idividually once I have the record set found. Thank for the input.