Skip to main content
will_watkinson
Contributor ⭐️
December 9, 2016
Open

Add ability to monitor for and insert values into picklist field that are not available in the picklist

Related products:CS Rules Engine
  • December 9, 2016
  • 18 replies
  • 261 views
Sometimes automation, or dataloading is used to insert values into picklist fields that do not exist in the picklist field. It would be useful to have the ability to monitor for and insert values into picklist fields that do not exit there by adding the option to write in when reading from, or writing to a picklist instead of just being able to select one of the available picklist options.

    18 replies

    sundar
    Expert ⭐️
    January 5, 2017
    Will - Had a discussion with the team on this. We feel that this might get tricky when there is a data issue or configuration issue the picklist might get bloated with Junk values and make this tedious to clean up.
    We need to build some more sophistication on the limits / controls  before we allow this feature in Rules Engine.
    Helper ⭐️
    April 29, 2021

    We are running into this with our Industry field in Salesforce constantly having new values being added to it that are not matched in Gainsight. While yes, some control would be great, please give us the option to determine that as admins. Right now we have entire records not updating with data from Salesforce via the Connector due to this issue. I want the ability for Gainsight to autodetect and add new values so we’re not constantly having to do this manually. 

    Anastassia Goidina
    keith_mattes
    Helper ⭐️⭐️
    April 29, 2021

    Part of the monitor could use picklist field ID’s to find unmatched between the two systems.  I believe this is doable from a hypothetical perspective as we have implemented this “unmatched” logic for duplicate account issues based on our underlying system “challenges” and were able to rapidly move invalid accounts to inactive status.

    You would need the ability to sync/store the id value in GS as well.

    Sr. Customer Success Operations Analyst/Gainsight Admin/Data Nerd
    bradley
    Expert ⭐️
    April 29, 2021

    I think this is would also need to be solved if GS wants to move to a more universal bidirectional sync anyways. It would certainly cut down on headaches between SFDC and GS admin teams as field values update and change.

     

    Shameless plug for character parity in picklist values, which can also be a failure cause between systems 

     

    darkknight
    Expert ⭐️
    May 4, 2021

    +1

    Jeff Kirkpatrick
    bradley
    Expert ⭐️
    October 12, 2021

    @Cornelia any idea why this has died in committee?

    Cornelia
    Contributor ⭐️⭐️⭐️⭐️⭐️
    October 13, 2021

    Hey @bradley let me quickly check with the Product Manager and check if they could revert here to give you an update on the same. 

    bradley
    Expert ⭐️
    October 18, 2021

    Would love a way to keep picklists up to date without manual intervention every time

    Helper ⭐️⭐️⭐️
    October 22, 2021

     

    @darkknight @bradley Is the use case for this ask same as what the original poster had mentioned? Or there are more use cases where this functionality will be useful?

    bradley
    Expert ⭐️
    October 22, 2021

     

    @darkknight @bradley Is the use case for this ask same as what the original poster had mentioned? Or there are more use cases where this functionality will be useful?

    @Bhawya are you asking if there are more use cases for syncing picklist values between systems than just syncing picklist values between systems? I don’t know, data integrity? Product stickiness? Data type alignment between systems? Can you clarify what you’re asking?