+ Start a Discussion
Rahul S.ax961Rahul S.ax961 

Setting Account Region Based on Country

Hi,

 

Consider a scenario, Account has a Country field.

Depending on the value in Country field, values will be populated to Account Region (Custom Picklist Field).

Picklist Values - NAM, SAM, EMEA & APAC.

The values must be set dynamically, so is there any app or webservice for doing the same.

Any help is Appreciated.

 

 

Best Answer chosen by Admin (Salesforce Developers) 
Imran MohammedImran Mohammed

If the country field is of Lookup type, then Dependent Picklist won't work.

The best practice in this scenario will be to make Country field a Picklist to maintain Data Integrity.

All Answers

Imran MohammedImran Mohammed

You should try Dependent Picklists to get this.

Here the Account Region will be Dependednt Picklist and Country will be Controlling Picklist.

Click  Dependent Picklist to know  more about it.

Rahul S.ax961Rahul S.ax961

Thanks Imran for the quick reply,

I also thought the same but, the problem is the Country field is String. so here will have to take all country names.

This would work if user enters the Country value which is specified in some formula.

But if user enter value which is not present in the lookup then, what will be the solution?

Also if user misspells the Country Value?

Imran MohammedImran Mohammed

If the country field is of Lookup type, then Dependent Picklist won't work.

The best practice in this scenario will be to make Country field a Picklist to maintain Data Integrity.

This was selected as the best answer
Rahul S.ax961Rahul S.ax961

Ya, it seems to be best solution,