Ask Search:
Todd MillerTodd Miller 

best alternative to multi-picklist

Hi, 

I need to create some new fields under accounts where the user may need to list several items as the answer. 
I had initially considered a Multi-picklist but I know that reporting for them is awful. Are there some better options? 

Thank you. 
Best Answer chosen by Todd Miller
Mayank SrivastavaMayank Srivastava
So, the Agency Focus will be your custom object as a replacement for the Multi Select Picklist.

You can then create records underneath it with one record each for:
  1. Luxury
  2. Family
  3. Groups
  4. Wellness
  5. other
You would then create another custom object as a junction object between your primary object and the Agency focus object.
Now if your users wish to select multiple (or one) of these records, they will have to select these records from the junction object related list on the primary object.

All Answers

Mayank SrivastavaMayank Srivastava
Todd, my favorite workaround for multi select picklists are the following:
  1. Custom object on the detail side of the parent object (where the MSP was supposed to reside)
  2. Checkboxes (only well suited when the number of MSP options aren't too many
All of it is really well explained in this blog post here:
http://cloud4good.com/announcements/evils-multi-select-picklists-salesforce/

A similar response from me on another question:
https://success.salesforce.com/answers?id=9063A000000DhuwQAC
Todd MillerTodd Miller
Mayank, 
I like the idea of the custom object but having trouble visualizing it. Could you provide some additional detail? 
Ideally, for one of them the custom object would be something like: Agency Focus and then the response options would be: Luxury, Family, Groups, Wellness, other

Thanks!
Mayank SrivastavaMayank Srivastava
So, the Agency Focus will be your custom object as a replacement for the Multi Select Picklist.

You can then create records underneath it with one record each for:
  1. Luxury
  2. Family
  3. Groups
  4. Wellness
  5. other
You would then create another custom object as a junction object between your primary object and the Agency focus object.
Now if your users wish to select multiple (or one) of these records, they will have to select these records from the junction object related list on the primary object.
This was selected as the best answer
Todd MillerTodd Miller
Hi Mayank, 

Account is the primary Object. 
I created a custom object for Agency Focus. I then created record types for Luxury, Family, Groups, Wellness, Other under the Agency Focus custom object. 

I then created a custom object to act as the junction object called What is the Agency Focus. I tried to create field with a Master-Detail for the Agency and then I created another field for for the Agency Focus as a Master Detail but it is showing up like this and then when I click on the Agency Focus, it pops up the options as Record Type and I can only select one. Please help. 
User-added image