I am working with a customer that is pushing SFDC contacts out into the MDA. Natively in SFDC, when a new contact is added to the database, SFDC will convert the email to all lowercase. (i.e. STEVE@GAINSIGHT.COM -> steve@gainsight.com).
For this particular use case, we need to do an update operation into an MDA table pre-loaded with email addresses. We are trying to match them with records existing in SFDC and pull the "Contact ID" field to update the table in the MDA.
The issue? Our MDA email field doesn't convert the text to lowercase, therefore we can't reliably use the "email" field as an identifier because quite a few records get skipped because we classify it as "not meeting the identifier criteria".
Because SFDC behaves this way, is it possible for us to create an "SFDC email" field type in the MDA that will convert this text to all lowercase?
New Idea
MDA Email field case sensitivity
+5With Gainsight being built on Force.com platform and being as dependent on SFDC as it is, there are fields such as email that can be synced to SFDC or need to be used for mapping Gainsight should default to the way SFDC uses the field.
We are having difficulties with this, as well. Any option to 'ignore' the case sensitivity when matching or counting email values in a rule would be greatly appreciated.
+5Ashok, I've assigned this to you for visibility.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.