Skip to main content
Topics#Data ManagementPregunta de Jonathan White
Jonathan White (Salesforce) preguntó en #Data Management
19 jul 2018, 09:01

Auto Populate region based on Country

Hello I would like to auto Populate the region drop down based on the country that is listed for a contact.

 

I have created a workflow that updates the field but unsure if my formula is correct.

 

Country is Text Field

 

MailingCountry = "Australia, Laos,Malaysia, Cambodia,Micronesia,China,Myanmar,Fiji,New Zealand,French Polynesia,Pakistan,Guam,Singapore,Hong Kong,Taiwan,Thailand,Japan,Vietnam,North Korea,South Korea"

 

 
1 respuesta
  1. Sunil Sarilla (M&G Investments)
    19 jul 2018, 09:52
    Hi Jonathan,

     

    I am not sure a Workflow is best suitable (unless you are writing a separate workflow rules for each region)

     

    I would recommend using Process Builder for this.

     

    Anyways, the criteria will be

    CASE(MailingCountry,
    "Australia",1,
    "Laos,Malaysia",1,
    "Cambodia",1,
    "Micronesia",1,
    "China",1,
    "Myanmar",1,
    and so on.....
    "South Korea",1,
    0)=1

    Under the field update action, select Region field and select the specific region value

     

     
Escribir una respuesta...
0/9000