Skip to main content

Hello everyone,

 

I’m trying to find a way to automate a Contact lookup of solely the domain of the submitted email address to see if there are any Contacts that match the domain.

 

I’m using Formatter to extract the email (ex. @walmart.com) and then using the Salesforce “Find Record” to look for the email itself, and then just the domain. The problem is that SFDC is not picking up anything with just the domain search, despite testing with email domains that I know exist in our system - I’m assuming it’s because it’s looking for an exact match, not a “Contains” match. 

 

Anyone have any ideas how I could accomplish this? Not sure if there’s a workaround for this, but figured I’d ask the community.

 

Thanks!
Brad

 

 

Hi ​@b943863 

Unless there is a domain field to use to search, that type of search would likely require using a Salesforce Object Query (SOQL).

 

Help links for using Salesforce in Zaps: https://zapier.com/apps/salesforce/integrations#help 

 

 


Hi there ​@b943863 👋

Have you been able give that Find Record by Query action Troy suggested a try yet?

Keep us posted on how it goes when you do, want to make sure you’re all set here!