Force Auto-Enter

[Meetloaf]

Is there a way to re-perform Auto-enter field operations on records that already exist, in fields that already exist?

[Vaughan]

Yes.

Cgange the auto-enter to include a trigger field, then update the trigger field. This could be as simple as replacing the trigger field value with itself.

To create a trigger field, use Let() functiom:

Let(

trigger = somefield ;

therealcalculation

)

[mcyrulik]

Vaughan,

Will that work if the trigger field is a calculaton?

[Vaughan]

Include the fields that the calculation is based upon as the trigger fields.

Note that AFAIK auto-enter doesn't work for related fields, only local fields.

[mcyrulik]

Unfortunately the fields that the calculation references are related.

Any ideas on a way around that?

[Vaughan]

Why use an auto-enter then? If it doesn't need to be indexed make it into an unstored calculation field.

If it does need indexing then the field will need a scripted update process. This is either done through the interface as the data is changed (force the user to run a script as part of the data entry) or on a regularly timed basis (say getting FM Server 9.0 to run the update script every morning or whatever).