Skip to main content

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

10 Antworten
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    26. Juli 2022, 08:04

    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)