longshore consulting
  • Home
  • Contact
  • About
    • Clients
    • Resources
    • Prices & Services
  • Blog
  • #AdminHour
  • Products

Why I Never Use Multi-Select Picklists in Salesforce

1/7/2017

2 Comments

 
I often encourage the nonprofits I work with to avoid using multi-select picklists, and I always get the same question back: Why? Here are a two of my many reasons why I personally advise against using multi-select picklists whenever possible, why do you use or not use them?

1. They are really difficult to work with in formulas. Example: I wanted to use values from a multi-select picklist field as part of a naming convention for cases. There's not an easy way to do this. In fact, Salesforce help points out there are very few formulas where multi-select picklists can be used. Here they are:
Picture
2. They are hard to work with in reporting. Example: I wanted to use race as a multi-select picklist field to allow people to self identify in whatever way they choose. This is great, until I realized that to accurately capture people and that myriad ways to self-identify, I'd have to create a report for each picklist value (e.g., African American, Asian, Latinx, etc.) and then people would be double counted across the reports (e.g., someone who multi-selected African American and Latinx). I would then also need to create reports with all of the possible permutations or report on each person individually to allow for their full individual expression. Instead, I opted to use checkboxes which make reporting much more clear. Also, to be clear, to be able to report on one option in a multi-select picklist requires a super annoying workaround! Ugh! Read how to do that here. How this makes me feel:

via GIPHY

So, what are your thoughts? Are there times when you don't need to report on multi-select picklists so you just use them anyways? Are there times when you've used one only to realize later you would have preferred checkboxes? Let me know!
2 Comments

Admin Hour #2: Configuration Basics & Beyond!

4/22/2016

2 Comments

 
2 Comments

Salesforce Tip: Number Field Gotcha and How To

3/3/2016

0 Comments

 
0 Comments

    Author

    Missy (@missylongshore on Twitter and Periscope) writes this blog just for you!

    Archives

    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015

    Picture

    Categories

    All
    Dreamforce
    Girlforce
    Gotcha
    How To
    Lightning
    Nonprofit
    NPOCRM
    Salesforce
    Tip
    Trailhead

    RSS Feed

    View my profile on LinkedIn
Proudly powered by Weebly
Photo used under Creative Commons from Axisworks
  • Home
  • Contact
  • About
    • Clients
    • Resources
    • Prices & Services
  • Blog
  • #AdminHour
  • Products