I have a picklist field for Sales Territories in the Accounts object and upon creating a new Account, I would like the picklist field to dynamically update based on another value (i.e., State, Region, etc...) and only show the relevant Sales Territories in the picklist based on that value. For example, if a user is creating a new Account and they enter San Francisco, CA in the address section....is there a way to parse the address and since the account is located in CA to only show CA Sales Territories in the picklist field?
Thanks.
1 answer
You can easily do this with dependent picklist, but you have to use the Address action as a Picklis Field, or you have to create another picklist to populate the state, because in order to dinamically show value in another picklist you have to put the exact value in the other field/picklist.
Let's say in this case you select "CA", the Sales Territories picklist will show all fields associated with the value "CA". Depends on what are your requirements
