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

- ...?

 

Cheers

Serf