+ Start a Discussion
uHaveOptionsuHaveOptions 

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

 
debdubdebdub
Hi Jon,
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
uHaveOptionsuHaveOptions
debdub

whats hierarchical picklist?
debdubdebdub
Hi Jon,
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