Skip to main content
January 28, 2015
Question

SFDC Question on Filtering Contact Records

  • January 28, 2015
  • 3 replies
  • 1116 views
I am currently setting up synchronization of our Salesforce data (Leads and Contacts) with Marketo. We have created a special profile and account to filter fields of data that synch with Marketo. For example, the profile hides fields in Salesforce which we don't want to synch to Marketo.

The other way we need to filter data is by row or record. We don't want to sync leads or contacts which are missing an email address or where the customer/prospect has "Unsubscribed" from email.

With the Lead object, this is straight-forward. Under Security Controls>Sharing Settings, I create a Lead Sharing Rule where the profile/account can't even see records that have blank email address. However, Contacts inherit their permissions from the parent, Account. The parent Account object has Private access.

Because of that, I don't even have a Contact Sharing Rules feature available to me. I don't want to filter by Account; rather, I want to filter the Contact record where the email address is blank.

How can I create a sharing rule or some kind of filtered view for Contact when Contacts inherit permissions from the parent Account object?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Josh_Hill13
Level 10
January 28, 2015
Are you an SFDC Admin or developer?

One way is to set a field that says "Ok to Sync=T/F". An apex trigger sets T/F if those two conditions exist, then set Ok to Sync=F.

You could also invert it - Do Not Sync=T, but I prefer clear language.

Not sure how else you would do this with the profile and permisisons, but you might be able to do this.
January 28, 2015
Hi Josh! I am a SFDC admin. Unfortunaetly we can't go down that route because we cannot create a Contact sharing rule in SFDC. We must create the sharing rule on the Account object. Any ideas how we could do this?
Jep_Castelein2
Level 10
January 28, 2015
Michelle, please contact Marketo support to set up an SFDC Sync Filter. If you can create a check box "sync to Marketo" which you populate with a Workflow, then Support can set up a filter that only lets those records sync to Marketo.