On Dec 4, 3:21m, Chris Brown < XXXX@XXXXX.COM >
FM has two options for auto-enter calcs...replace existing values or
not. That means the calc is evaluated at either record creation,
which is pretty helpful, or whenever any of the stored referenced
fields in the calc (including the field itself) are modified which is
also pretty helpful.
It sounds like what you're looking for is a way of having the calc
trigger when the field is modified the first time after record
creation. That can be done in a variety of ways.
One that comes to mind is to have a second field, Name Modified which
has the auto-enter Data checked and empty (for duplicating records)
and the auto enter calc box checked. That calc would be:
trigger = Name Field;
Then the calc in the Name Field would be:
Case(not Name Modified ; SmartProper(Name Modified); Name Modified)
Both auto calcs should be unchecked to always replace.
On record creation, Name Modified would be null. When a name is put
in the Name field for the first time, it would enter the SmartProper()
result. That entry triggers the Name Modified calc which becomes 1
and suppresses the SmartProper() from occurring again.