Ask Search:
Lakshmi KumarLakshmi Kumar 

multi-select picklist vs checkbox

Hello all,

I have a question regarding multi-select picklists and checkbox. I need to know the pros and cons of using either multi-select picklist and checkbox. My client does not recommend using multi-select picklist as they are worried of reporting. Hence they are sticking to checkboxes because of reporting. 

I recently heard that in Spring/Fall 2016 there were few updates that were implemented to multi-select picklist. I am not quite sure though. My client has asked me regarding the best practices either to implement multi-select picklists and checkbox. 

Can anybody suggest me based on the above scenario what must be implemented either the multi-select picklist or checkbox?

Thanks a lot !!!  
Best Answer chosen by Lakshmi Kumar
Mayank SrivastavaMayank Srivastava
Lakshmi, whatever updates were made to the MSP's wouldn't make them any better or qualify them for use. A few cons of using them:
  • ​MSP's suck for reporting
  • Pose challenges for merges
  • Pose challenges for automation like workflow rules, process builder
  • Pose challenges for formula writing
The checkbox approach would be much better because then you get proper reporting and flexibility with automation as well. You coud always use the following article to come up with a good case for not using the MSP's and going with checkboxes or a custom object instead:
http://cloud4good.com/announcements/evils-multi-select-picklists-salesforce/

Good luck!

All Answers

Mayank SrivastavaMayank Srivastava
Lakshmi, whatever updates were made to the MSP's wouldn't make them any better or qualify them for use. A few cons of using them:
  • ​MSP's suck for reporting
  • Pose challenges for merges
  • Pose challenges for automation like workflow rules, process builder
  • Pose challenges for formula writing
The checkbox approach would be much better because then you get proper reporting and flexibility with automation as well. You coud always use the following article to come up with a good case for not using the MSP's and going with checkboxes or a custom object instead:
http://cloud4good.com/announcements/evils-multi-select-picklists-salesforce/

Good luck!
This was selected as the best answer
Steve DoddSteve Dodd
Hi Lakshmi,

I try to avoid multi-select picklists whenever possible...here is a good article that offers more information...hope you will find it useful:

http://cloud4good.com/announcements/evils-multi-select-picklists-salesforce/

 
Lakshmi KumarLakshmi Kumar
@mayank: Thanks a lot :) 
@Steve: Thank you!! 
Steve MolisSteve Molis
I'm just gonna leave this right here... 

The Admin - Episode 1.0​
https://success.salesforce.com/0693A000006IbUM

PS.  Multi-Select Picklist fields are good at 3 things:

1. Allowing a User to select one or more things from a list of options.
2. SUCKING 
3. I forget the third one...
Lakshmi KumarLakshmi Kumar
@Steve Molis: lol, that was a funny one :P .. Thanks again :)