Hello,
I need to update one field with the value of another. Field X is a picklist field and according to its value field Y must have a certain value. I have a lot of data and I am limited with a formula field.
For example:
Field X = test in this case Field Y = Test1
ischanged Field X with value Test36 in this case Field Y = Test12
How can I do this?
Thanks
Forum Ambassador Eric Praud (Activ8 Solar Energies)
I don't have an example, but you could simply create a text field on the object (Field Y).
Now, create a record triggered flow on the object on creation and update. As the entry criteria, change it to a formula and go with:
OR(AND(ISNEW(), NOT(ISBLANK({!$Record.FieldX__c}))),
ISCHANGED({!$Record.FieldX__c}))
Now, add an update record element that will update the record triggering the flow and set FieldY to a "+New Resource">Formula returning text with the CASE formula. Make sure you click on Insert a Resource to get the right field name ($Record>FieldX)