Skip to main content
romihache
romihache
VIP ⭐️⭐️⭐️⭐️⭐️
August 12, 2022
New Idea

Easy way to access the GSIDs of dropdown values

Related products:CS Data Management & Integrations
  • August 12, 2022
  • 7 replies
  • 188 views

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
    benwanlessmenlo
    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
      spencer_engel
      Expert ⭐️
      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
        benwanlessmenlo
        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
          dayn.johnson
          VIP ⭐️⭐️⭐️⭐️⭐️
          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.

           

          Staff CS Content & Comms Manager, 2x Gainsight CS Ops Product Council Member
            alizee
            alizee
            VIP ⭐️⭐️⭐️⭐️⭐️
            September 6, 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.

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

            The most expensive part of building is the mistakes. That's true in construction. Not so much in CSOps. So ask questions, make mistakes and learn. All views expressed here are my own.
              romihache
              romihacheAuthor
              VIP ⭐️⭐️⭐️⭐️⭐️
              September 6, 2024

              Thanks for attaching Wayne’s workaround @benwanlessmenlo! 

              Continuous improvement is better than delayed perfection
              benwanlessmenlo
              benwanlessmenlo
              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

              Terms & ConditionsAccessibility statement