Multi-Picklist values into separate line items in MDA table

  • 1
  • Idea
  • Updated 2 months ago
Don't know if this is more of a question or an idea, but putting this out there as I don't know if this is possible in Gainsight already.

I have a multi-picklist field for selection of product names that can have a variety of combined selections.

I want to try and capture those values as multiple rows in a single column, and write out to an MDA table. (for any Linux geeks, kind of like you can do with an AWK statement in a shell script)

Anyone know if this is already possible in Gainsight?

If not, then would be great if it could accomodate such a use case.
Photo of Jeff Kirkpatrick

Jeff Kirkpatrick, Champion

  • 23,868 Points 20k badge 2x thumb

Posted 3 months ago

  • 1
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 9,308 Points 5k badge 2x thumb
Hi Jeff, 

Mapping of Multi-Picklist to string is possible via rules. This might help in solving your use case. Can you provide more details about the use case(example if possible), so that we can explore more.
Photo of Jeff Kirkpatrick

Jeff Kirkpatrick, Champion

  • 23,868 Points 20k badge 2x thumb
II know you can write out the multi picklist values into a single stream separated by commas for example but I need the values in the multi pick list to be split out onto separate rows
Photo of Jeff Kirkpatrick

Jeff Kirkpatrick, Champion

  • 23,868 Points 20k badge 2x thumb
Sai - this has become a really big pain point for us.  

We have 3 multi-picklist fields, each with 10-15 options to choose from.  This results in somewhere around 256 different possible combinations that can be chosen.   Without the ability to parse out the multi-picklist values into separate lines, I would have to write @256 rules in order to account for all the possible combinations.   

Instead, our Salesforce team is looking into building a custom object for us with a trigger script to parse it out and store in SF.  But this really takes a core chunk of the processes we're trying to build out of Gainsight's control.