Skip to main content
New Idea

Easy way to access the GSIDs of dropdown values

Related products:CS Data Management & Integrations
cameron_wright
kate_green
  • cameron_wright
    cameron_wright
  • kate_green
    kate_green

romihache
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 429 replies

I’m having trouble with a rule, the values of a dropdown are shown as GSIDs and I have to use that field as source for a case statement.  But the issue is, that field has 12 possible values and only 8 are used, so there’s no “straightforward” method to get them.
 

Is it possible to provide a simple way to get those collections of key-value pairs? (e.g, being accessible in report builder,  download a CSV from data management with the GSID and value)

 

Thanks,

 

7 replies

benwanlessmenlo
Forum|alt.badge.img+4
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 115 replies
  • September 5, 2024

Hello, 

I am looking for an easy way to just export picklist values, with or without the GSIDs (although with GSIDs would be more useful)

This is an important step when managing a large list of picklist values, otherwise I have to manually scroll through values to determine which are present and which are missing.


spencer_engel
Forum|alt.badge.img+4
  • Expert ⭐️
  • 670 replies
  • September 5, 2024

Yes! This has been a frustrating thing for a long time. You have to be very knowledgeable in the dark arts of Gainsight to even begin to know where to look for said GSIDs, and even then I feel like I have to carefully re-learn how to find them every time it comes up. Please make this easier!


benwanlessmenlo
Forum|alt.badge.img+4
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 115 replies
  • September 5, 2024

I’ll just add for reference, this is the current method to get the list of picklist / dropdown options with GSIDs:

Which requires both the use of APIs and parsing JSON.


dayn.johnson
Forum|alt.badge.img+6
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 647 replies
  • September 5, 2024
benwanlessmenlo wrote:

I’ll just add for reference, this is the current method to get the list of picklist / dropdown options with GSIDs:

Which requires both the use of APIs and parsing JSON.

 


alizee
Forum|alt.badge.img+12
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 659 replies
  • September 6, 2024
benwanlessmenlo wrote:

Hello, 

I am looking for an easy way to just export picklist values, with or without the GSIDs (although with GSIDs would be more useful)

This is an important step when managing a large list of picklist values, otherwise I have to manually scroll through values to determine which are present and which are missing.

Especially as there is a lot of whitespace in dropdown management which makes it very cumbersome to scroll through...


romihache
Forum|alt.badge.img+8
  • Author
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 429 replies
  • September 6, 2024

Thanks for attaching Wayne’s workaround @benwanlessmenlo


benwanlessmenlo
Forum|alt.badge.img+4
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 115 replies
  • September 6, 2024

Another little bit of massive frustration with managing long picklists:

When you add a new item to a picklist.

And want it to appear at the top.

And not rearrange the whole list.

You have to click and drag the bottom most item to the top. Because there are 20,30,40+ items and a scroll bar, it can’t be done in one “click and drag” motion. It takes several if not tens of several ‘click and drags’.

Then, you have another new item to add, repeat.

Ben


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings