Perhaps add a case statement to your field c auto-entry, so that if the "user" is a script, the old value in field c is reentered?
There's two ways...
1) Use an additional field that references C, but not when the script is running and use that instead of C to display the modified by.
2) Change C so it references all the fields you want to trigger the name change on and put an exception in for when the script runs.
See, FileMaker's "Modification" options are pretty unique within FileMaker. You can't auto-enter whatever you want on any field modification, only the timestamp, account name, user name, etc. options.
So, you can either reference that feature in another field, or recreate it.
Referencing it, means create a new field, C_Real . Have C_Real auto-enter this:
Let( trigger = C ; Case ( $script.running ; Self ; Get ( AccountName ) )
Add a Set Variable [ $script.running ; 1 ] to the start of your update script.
You can replace that function by moving the "modification" checkbox ability into the auto enter calculation box.
Let ( trigger = FieldA & FieldB & FieldD & FieldD ;
Case ( $script.running ; Self ; Get ( AccountName ) )
Hope that helps!
Thanks for your clearly explained options, that both worked perfectly!
I've opted for the first (referencing) one, since there's a lot of fields in this layout, but the auto-enter calculation is an option for other uses.
Much appreciated your help! Thanks
Thanks Chris for your help too!