Skip to main content
New Idea

Easy way to access the GSIDs of dropdown values

Related products:CS Data Management & Integrations
spencer_engel
jared_block
lisa.mirth
diana_luo
  • spencer_engel
    spencer_engel
  • jared_block
    jared_block
  • lisa.mirth
    lisa.mirth
  • diana_luo
    diana_luo

romihache
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 431 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,

 

benwanlessmenlo
Forum|alt.badge.img+4
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 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

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 ⭐️⭐️⭐️⭐️⭐️
  • 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 ⭐️⭐️⭐️⭐️⭐️
  • 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 ⭐️⭐️⭐️⭐️⭐️
  • 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
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • September 6, 2024

Thanks for attaching Wayne’s workaround @benwanlessmenlo


benwanlessmenlo
Forum|alt.badge.img+4
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 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



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