new field filling with formula

[MicKress]

Hi, I‘ve created a new field in contact entity which is filled with a formula. Is there a possibility to fill this field for the existing data automaticly , e.g. with a workflow or do I have to do this with a query directly in the mysql database. (I don‘t want to change manually all existing datas). Regards Michael

[tanya]

Yes.
You can create a report for your entity with records, where this field is not filled.
After create a workflow
- Trigger Type - Scheduled
- Target Entity - your entity
- Target Report - your just created report
- Scheduling - set what you want, for example - 0 * * * * - at 0 minute each our

Actions
Update Target Record - set your formula here as well.

After all record will be updated, remove/inactivate this workflow

[MicKress]

worked fine, thank you.