Not Planned

Dropdown list item with single quote


Userlevel 6
Badge

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.

 

 


12 replies

Userlevel 6

@shiv_kumar_katiyar 

Thank you for letting us know.

I will look into this and see if we can revisit the validations we have set for Dropdown items.

 

 

Userlevel 6

Hi @shiv_kumar_katiyar 

We currently use Single, Double quote and Semicolon as separator characters and hence cannot be included into the special characters involved.

Is it possible to rename the picklist item name from SFDC and do a sync?

Userlevel 7
Badge

@shiv_kumar_katiyar did u get a chance to view the comments posted by @pgeorge 

Userlevel 6
Badge

thanks @pgeorge for taking a look! Client was already aware of that, so I suggested him to take the rule approach-

 

create the value without quotes inside Dropdown and via rule you can actually map it and populate. Something like below-
?name=inline-684535656.png

Userlevel 6
Badge

this is becoming challenging with other integration as well -

 

Userlevel 7
Badge

Great idea @shiv_kumar_katiyar ! 

@sai_ram - can we change this to a product idea?

Userlevel 7
Badge

Great idea @shiv_kumar_katiyar ! 

@sai_ram - can we change this to a product idea?

@jean.nairon changed to idea.

@All, please leave your vote here!

Userlevel 7
Badge

@sai_ram I realize this appears to be a dead idea, but I feel it is my duty to reiterate how big of a problem this is and why mapping a dropdown to a string picklist is not an acceptable workaround.

 

Why mapping a Picklist>String data type is not a workaround:

The obvious problem is that they are two different data types. In case I need to explain why that’s a problem consider this: If you have a dashboard looking at MDA and SFDC objects, you are going to have to use one filter for your MDA objects and one for your SFDC objects. Terrible end-user experience not to mention it looks bad.

 

Why dropping any ‘, ‘’ etc., is not a workaround:

If you are trying to do any type of equivalency match between data, GS does not seem to trim the data and exclude characters it doesn’t support, or even give you that option. So even if you used a rule to map Children’s to Children and think it will work, try using a Global filter with your new MDA field with both SFDC and MDA objects. You’ll get this error message.

 

The “solution” is to go back to your SFDC instance and change the values to remove any punctuation. This, quite frankly, is in most cases not a viable alternative nor should it be. People are very tied to their SFDC deployments and you may have to deal with multiple levels to get a change approved, and then wait for it to happen.

 

I see two viable solutions to this. The first would be just to allow additional characters. Since you know by now Salesforce is used quite a bit with GS, characters should be supported at parity with what Salesforce allows. This would result in the best user experience and show that the platform has maturity. Another alternative would be to strip non-supported values before doing equivalency checks, so that you don’t punish users for having used Salesforce first.

 

I don’t know if I’m the only one who feels strongly about this, but it seems like this should have not been an issue a couple of years ago. @gunjanm or @darkknight have any thoughts on this? Am I off base or would getting this resolved be a huge boon for customers and the platform?

 

Userlevel 7
Badge +1

@bradleymcg I think you’ve put this together very nicely. This is definitely one of those admin nuances that seems small and petty at first but has immense value and should be prioritized and considered by the team. 

  
End Proctoring-
 
Userlevel 7
Badge

@gunjanm Thanks for the sanity check. It seems pretty fundamental but I also realize I can be a bit biased on what I think the impact is :)

 

edit: @sai_ram just bubbling this to the top

Userlevel 3

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

Userlevel 7
Badge

@bradleymcg 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.

Reply