I’m trying to find a way to make a Zap search (1) one field that contains several email addresses or (2) multiple email fields in Salesforce before adding a new contact. We have several email fields (personal, work, alternative) that we would like to search on in addition to our primary one. We also have a field that consolidates all emails into one field, separated by a comma.
I have this:
SELECT Email, Alternate_Email
FROM Contact
But it does not return any results.
Many thanks for any help!
+14
Hi
Check the field description for guidance about how to use the Salesforce SOQL.
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql.htm
Hi
Check the field description for guidance about how to use the Salesforce SOQL.
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql.htm
Hi
I’ve checked the documentation and tried the options offered but the query still doesn’t bring any results.
I’ve used:
Neither query works.
This one works successfully:
This one works successfully:
Separating all fields also works successfully:
However, the All_Emails__c field captures all the emails in one field so I would like to use that one to search by. Would just like some help with the syntax.
+14
Did you try asking ChatGPT for help writing the SOQL?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
