August 2, 200718 yr Is there a way to re-perform Auto-enter field operations on records that already exist, in fields that already exist?
August 2, 200718 yr 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 )
August 9, 200718 yr 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.
August 10, 200718 yr Unfortunately the fields that the calculation references are related. Any ideas on a way around that?
August 10, 200718 yr 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).
Create an account or sign in to comment