Field Modification Flag

[Mr. Bungle]

I want to have a calculation that will look at a series of fields and set a flag if any one of them has been modified. I would then create a script that would find all the records that has this flag set, then export them and clear the flag.

 

Sounds simple, but I'm at a loss as how to go about it...

[comment]

Try a number field with an auto-entered calculation (replace existing) of:

 

Let (

watchFields = Somefield & Anotherfield & YetAnotherfield

;

1

)

 

Perhaps using a timestamp field with Get (CurrentTimestamp) instead of the "1" flag would be better: then you can find records that were modified since last export, and you don't need to clear anything.

[Mr. Bungle]

Comment:

 

Thank you, thank you, thank you. Not only did you solve my problem, but your advice gave me valuable insight in to the LET function.