Skip to main content
tom_gerth
Gainsight Employee ⭐️⭐️
Aug 1, 2018 3:07 PM UTC
Question

MDA dropdown values show GSID when exported

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 ⭐️⭐️
Dec 23, 2020 11:52 AM UTC

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

Translate
Justin Bills
Helper ⭐️
Dec 23, 2020 2:22 PM UTC

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. 

Translate
rakesh
Gainsight Employee ⭐️
Lets put your data to work!
Dec 24, 2020 10:02 AM UTC

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

Translate
sai_ram
Expert ⭐️⭐️
Jan 4, 2021 10:41 AM UTC

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

Translate
Contributor ⭐️⭐️⭐️
Jan 6, 2021 3:24 PM UTC

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

Translate
spencer_engel
Expert ⭐️
Jan 11, 2021 5:58 PM UTC

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?

Translate
Helper ⭐️
Jan 13, 2021 2:50 AM UTC

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

Translate
Anastassia Goidina
spencer_engel
Expert ⭐️
Jan 13, 2021 6:06 PM UTC

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

 

Translate
darkknight
Expert ⭐️
May 25, 2021 2:10 PM UTC

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

Translate
Jeff Kirkpatrick
Expert ⭐️
May 25, 2021 2:16 PM UTC

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

Translate