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.
2 respuestas
Coby Press (Black Cloud) Forum Ambassador
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