Announcement

Collapse
No announcement yet.

new field filling with formula

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • new field filling with formula

    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

  • #2
    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

    Comment


    • #3
      worked fine, thank you.

      Comment

      Working...
      X