You need to sign in to do that
Don't have an account?
uHaveOptions
Contact groups using multiple multipicklist fields. How can I all populate in 1 field
Hello All,
Can you guys help me solve a problem or suggest any ideas?
Scenario:
-John Doe (contact)
-5 different users can access the contact
-Database has 5 different multi picklist field in Contact for each user so they can assign them based on group.
-Example: Adams Group, Janes Group, Mikes Group, Tonys Group, Master Group... in contact layout
-Each group has different multipicklist information
Question 1;How can I combine all the groups into 1 field?
Fact: there's about 25 groups. it will be hard to do it in formula
Can you guys help me solve a problem or suggest any ideas?
Scenario:
-John Doe (contact)
-5 different users can access the contact
-Database has 5 different multi picklist field in Contact for each user so they can assign them based on group.
-Example: Adams Group, Janes Group, Mikes Group, Tonys Group, Master Group... in contact layout
-Each group has different multipicklist information
Question 1;How can I combine all the groups into 1 field?
Fact: there's about 25 groups. it will be hard to do it in formula
It's not pretty, but you could set up one multipicklist field with values like this:
Adams Group - Adam Value 1
Adams Group - Adam Value 2
Adams Group - Adam Value 3
Janes Group - Jane Value 1
Janes Group - Jane Value 2
Janes Group - Jane Value 3
etc
I was going to suggest a hierarchical picklist, but I don't think that is available with multipick lists.
Deb
whats hierarchical picklist?
I misspoke - it's a Dependent Picklist. You can configure fields to have a hierarchical relationship, so if I pick a specific value in the controlling field I only have specific selections in the dependent field. Docs:
https://help.salesforce.com/HTViewHelpDoc?id=fields_defining_field_dependencies.htm
Multi-select picklists can be dependent picklists but not controlling fields