I have a Lookup field "Assigned To" On child and "Assigned To" text field on Parent.AS soon as the "Assigned To" is populated on child object , "Assigned To" on parent is also updated with the id of "Assigned To" on child using workflow with formula
Now I have a requirement to show the name on parent instead of id.So i changed my formula to
Assigned_To__r.FirstName + " " +Assigned_To__r.LastName which is working fine.The only problem is I had to edit every record to to meet the criteria to see the change.
So my question is do i need to update every child record so the id get replaced with Name or is there some other alternative.
Evaluation Criteria for workflow is Evaluate the rule when a record is created, and every time it's edited