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

Dropdown list item with single quote

Related products:CS Connectors
  • May 14, 2020
  • 20 replies
  • 542 views

Hi There,

 

Currently, when you create a dropdown-list item with a single quote, the following message pops-up. 

 

 

Although one understands the validation but this becomes a problem when you have mapped this field in SFDC connector sync job and in SFDC picklist value contains single quotes etc. So are there any thoughts to allow dropdown value with single quotes because in SFDC picklist, we can have values with single or double quotes.

 

For now the only work-around is to have a String type in MDA mapped to such picklist.

 

 

20 replies

ssamarth
Gainsight Employee ⭐️
Gainsight Employee ⭐️
April 15, 2021

@bradley Thanks for the feedback. Will keep it in consideration.

bradley
Expert ⭐️
April 15, 2021

@bradley Thanks for the feedback. Will keep it in consideration.

Thanks - I’m sure it isn’t an easy fix but it’s a very important one especially as talks of more bi-directional syncing between GS and SF are under way.

bradley
Expert ⭐️
March 29, 2022

@anirbandutta can we get some new thoughts on this?

anirbandutta
Expert ⭐️
March 31, 2022

@anirbandutta can we get some new thoughts on this?

@bradley , @gunjanm , we admit that we are limited by what is possible to be achieved here technically, and wouldn't be able to include this usecase. It’s a technical blocker.

It's an opportunity for engagement
bradley
Expert ⭐️
March 31, 2022

@anirbandutta can we get some new thoughts on this?

@bradley , @gunjanm , we admit that we are limited by what is possible to be achieved here technically, and wouldn't be able to include this usecase. It’s a technical blocker.

Does that mean stripping out unsupported characters that cause failures is not being considered either? We are just stuck with the inability to use an extremely common and generally supported character in other platforms?

johntrask_bt
Helper ⭐️
July 12, 2022

Added in my use case as well. We use a picklist/dropdown to map the Billing Country at the account level. If you look at ISO 3166 and 3166-1 there are countries with a single quote. EG: Côte d'Ivoire .

This is becoming more and more of an issue for us. Can wse revisit this please?

JohnTrask
bradley
Expert ⭐️
July 22, 2024

@revathimenon Can we get some 👀 on this? This is an old request with sort of a vague “not something we can do about it” handwave but this is a vexing issue that really limits interoperability between Gainsight and SFDC. @pgeorge any insight?

aaronhatton
Helper ⭐️⭐️
October 29, 2024

We have had this cause us a number of issues. PLEASE can we get this fixed so special characters can be imported. My organization is European and the number of special characters we have is very high to support the different languages we operate in.

Aaron Hatton | Head of Digital Customer Success (PVcase)
joseph_siudzinski
Helper ⭐️
November 19, 2024

Bumping this thread as it is small but a huge pain. As Bradley said, since SFDC allows this, and Gainsight does not have parity, it creates a massive headache. In our case, we cannot go back and change picklist values to not have a single quote in them...so I am forced to do case statements for every item that has a single quote. 

Parity with SFDC is a must...

saltamash
Helper ⭐️⭐️
June 23, 2025

This continues to be a pain for everyone even today. Would love to have an updated on this. It's pretty sad that just because you have workarounds this request/idea has been pushed under the carpet.