Skip to main content
shiv_kumar_katiyar
Gainsight Employee ⭐️⭐️
May 11, 2020
New Idea

Access Dropdown Values in Rule transformation.

  • May 11, 2020
  • 15 replies
  • 539 views

I understand that we can enable Bionic pickplist labels which exposes dropdown list values in the rule export or execution results. But what if, I need to do some transformation like concatenation -- framing a Product name using concat( Opportunity Name, Product Type) where Product Type is a Dropdown item. Now the result is coming like this -

ABC Opportunity 1I0054W9FAKXZ0H26HOVC484TSFM5160JI8N.

As a workaround I am using Case expression. But would like to if there is any future enhancement with regard to this? 

15 replies

andybuchanan
Contributor ⭐️⭐️⭐️⭐️
January 28, 2022

Definitely +1 here and voted.  I have a situation where I need to compare a picklist value in MDA vs the current fiscal quarter (string) another value, and the IDs do not help as I can’t use a filter to say where String Field’s value is == Picklist Field Value.  The only way to do this is with a really annoying long Case expression since there are a bunch of Picklist options.

Andy
anirbandutta
Expert ⭐️
January 31, 2022

Definitely +1 here and voted.  I have a situation where I need to compare a picklist value in MDA vs the current fiscal quarter (string) another value, and the IDs do not help as I can’t use a filter to say where String Field’s value is == Picklist Field Value.  The only way to do this is with a really annoying long Case expression since there are a bunch of Picklist options.

@rakesh for the latest.

It's an opportunity for engagement
rakesh
Gainsight Employee ⭐️
Lets put your data to work!
February 7, 2022

Hi everyone,

We have released an improved picklist handling in Data Designer in our Nov release. Gainsight NXT Release Notes 6.29 October/November 2021 - Gainsight Inc.. As far as I can see, if we bring similar capability in Rules, all the problems listed here will be solved. Can you confirm if there are any usecases that will be unsolved if we bring similar capability to Rules?

HollySimmons
Helper ⭐️
February 8, 2022

It looks okay to me, but I don’t use DD that often (at all recently) so would prefer someone else confirm :no_mouth:

benwanlessmenlo
Contributor ⭐️⭐️⭐️⭐️⭐️
December 16, 2022

Hi everyone,

We have released an improved picklist handling in Data Designer in our Nov release. Gainsight NXT Release Notes 6.29 October/November 2021 - Gainsight Inc.. As far as I can see, if we bring similar capability in Rules, all the problems listed here will be solved. Can you confirm if there are any use cases that will be unsolved if we bring similar capability to Rules?

@rakesh  This option/ability would be awesome.

 

I just ran into this problem today, comparing a picklist/dropdown from Salesforce to Gainsight (but gainsight dropdowns use GSIDs not the label.).