Skip to main content
On the opportunity object, once a new opportunity is created - 

 

I have a field that is a picklist with several cities, once a city is selected, I need a separate field to populate automatically with the appropriate region.  I am not sure how to accomplish that. #.newbie. 

 

I was looking at process builder, but when I select the picklist field to choose from, I am only able to choose one specific item off of the picklist. I will need the system to see which region it belongs to, then update with the correct region. I hope that makes sense. I'm guessing I will need a table of some sort to reference...

 

Please let me know if I can provide  more information for clarity. 

 

Image attached - cities that match to each region. 

 

Update one picklist field with another picklist field

 

 
2 réponses
  1. Forum Ambassador Coby Press (Black Cloud)
    18 févr. 2021, 19:04
    Wrote a blog similar to this the other week

     

    https://www.coby.press/post/how-to-change-a-field-based-on-criteria-on-a-related-record

     

    i would create a criteria (blue diamond) for each region, and then in the critera, I would do the following (for examle I will take region5)

     

    City = City7

     

    City = City8

     

    City = City9

     

    then at the bottom, select the custom logic thing, and do

     

    1 OR 2 OR 3

     

    also at the bottom in advanced options make sure you select the checkbox

     

    Then in the action select to update the region to region5