function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Praveen Kumar 94Praveen Kumar 94 

Workflow for Field update

Because my Multi-Select field hits the 5K or 3,900 Limit of SFDC. I have arrived at this thing. I split the big formula(Multi-Select List) (Hard-Coded) into two fields (Field_B & Field_C).
I have this Scenario :
Two Objects : "Application" & "Contact"
I want to Update a Formula field "(Field_A = Field_B + Field_C)" in "Application" object when there is a change in fields "(Field_D)" of "Contact" Object. A look-up relationship exists between both the objects.

So i want to achieve this Using Workflow rule written on "Application".
Something like this should happen Field_A = Field_B + Field_C.

I know there is an alternative for Trigger for Cross-object field Updation. But i would like to achieve this using WFR.
sachin kadian 5sachin kadian 5
Hi Praveen,
There are few things.

1) You cannot update a formula field using workflow or trigger. It is calculated automatically and is read only and calculated at the run time (When you see the record)
2) If you will write a workflow on "Application", it wont fire when there is a change in "Field_D of contact" Object.
3) You can change this formula field to text field and write the trigger on contact to calculate it.
4) I am not sure but i think you can also use the Process builder for this.