Skip to main content
tom_gerth
Gainsight Employee ⭐️⭐️
August 1, 2018
Question

MDA dropdown values show GSID when exported

  • August 1, 2018
  • 41 replies
  • 1326 views
We've noticed that when including an MDA dropdown list field in a report, we get the GSID values when we export said report, versus the value's display name.

We show the display name in the report itself, but as soon as it's exported, we get the GSID that we are unable to decode and understand the text value.

41 replies

sai_ram
Expert ⭐️⭐️
December 23, 2020

@Nalin and @Justin Bills  acknowledged your request. I am checking on it. 

Justin Bills
Helper ⭐️
December 23, 2020

As an update - I did open a ticket on this.  It was something that was fixed with flipping something on the backend.  I’m not entirely sure if that opens all up all pick list fields to show the value instead of the ID, or just the one I was writing in about. 

rakesh
Gainsight Employee ⭐️
Lets put your data to work!
December 24, 2020

I see multiple product areas being discussed here: 

  1. Reporting → When you export a report which has a dropdown value we are currently showing labels only, not GSID’s. If anyone is getting GSID’s in any scenarios, I recommend raising a ticket.
  2. Rules S3 export → We have a backend flag which when changed will also send the label in addition to the GSID. This should be on for newer customers by default, for our older customers who might have already created some data flows using GSID’s we could not automatically do this change for all customers. Please reach out to support if you want this for your org

Hope this covers everything

sai_ram
Expert ⭐️⭐️
January 4, 2021

@Nalin and @Justin Bills did you get a chance to see the comments here?

Contributor ⭐️⭐️⭐️
January 6, 2021

@sai_ram : Yes, I did check the comments. I have raised a support case for this issue.

spencer_engel
Expert ⭐️
January 11, 2021

This is a pretty major issue in my opinion. I see that I can ask support for including the name too, which I will do. But the issue still remains that we can’t use MDA picklists in string formulas at all in the Rules Engine - i.e. you can’t do a LEFT formula, you can’t convert them as a string using Case Expressions, etc.

 

This is especially frustrating considering you can do all of the above with SFDC picklists. Why would our MDA picklists not function the same way?

Helper ⭐️
January 13, 2021

Yessss! Agree with all of the above comments. This and BOOLEAN field limitations have been super frustrating for me recently.

Anastassia Goidina
spencer_engel
Expert ⭐️
January 13, 2021

Here’s another scenario where storing the picklist values as GSIDs leads to frustration 

 

darkknight
Expert ⭐️
May 25, 2021

@rakesh The ability to leverage the actual Picklist values throughout GS is becoming more crucial.  I just added this question in another post.

Jeff Kirkpatrick
Expert ⭐️
May 25, 2021

Came across this issue just yesterday and had to push to a new object string field just to work with it.