How do auto field entry calculations behave?
I assume the calculation is done upon the creation of each record. But some calculations will depend on the value(s) of other field(s) in that record. How then are the auto entry calculations prioritized, and are they invoked once only.
Also, are there circumstances whereby an existing record, with an auto entry field, might have that calculation triggered by some other operation, although the field with the auto entry routine is not being explicitly changed.
For example, if I run a replace field contents command in a script, and the replacement value is itself a calculation, does this process affected in any way by the existence of auto entry calculations related to other fields.
Here I am referring to the replacement of values via a calculation in already existing records, but not the values of fields with an auto entry routine associated with them.