Hi there we have some records with the modified name / date / time etc fields set up to autoenter so we can track who last modified a record... thats fine.

 

We also have a script that runs which loops through all the records every so often performing various tasks.

 

The problem is that the modified fields now are updated because the script has modified the record! Is there anyway to prevent this from happening? I want the modified fields updated only when a user has modifed the record, not the scheduled script.

 

 

 

 

Try auto-entering a calculated value (replacing`existing value) =

Case ( IsEmpty ( Get ( ScriptName ) ) ; Get ( AccountName ) ; Self )

Note that this assumes there are no paused scripts during manual data entry.

One way would be to build a script that sets a $$global variable flag to turn on/ off recording.... in your script that does the modifications turn the flag to off.... and change your auto enter fields to calculation with If ( autoentermodificationtimestampfield ; "" ) & if ( $$flag is on ; Get (Timestamp) ; Self ) . The autoenter calc will fire everytime the field is modified and it will stored the last modification timestamp only if the $$flag is set to on.

I'm sure their are other ways to do this but its thd first to come to mind.

Another option would be to simply record what method caused the modification and leave the autoenter field alone. Alot depends on what reason you have for wanting to not record a modification to a field's data.