I need to repopulate a helper field every time the calculated field is updated. So that I can rollup that helper field.
Unfortunately the "On Update" triggers will not work for calculated fields.
What is the easiest workaround?
- Business Rule (Entitiy) to update the helper field: this brings ugly "Unsaved Changes" popups when users open the records. Also it should run in the backend, not sure if this runs only when the record is opened.
- Schedule once a day and iterate through ALL records and update the helper fields