Record failed to sync to SFDC-FIELD VALIDATION EXCEPTION

[Emma_Wu]

Hi everyone!

Here is the situation: we have a validation rule in SFDC to prevent Marketo sync user to update an "Override" field if "Lead Status" is not MAL. However, when we run list upload in Marketo, sometimes we need to set a value for this "Override" field, but this way some pre-exist records (Lead status is not MAL) "Override" field will get updated in Marketo, and it causes the record failed to sync with Salesforce:

"FIELD_CUSTOM_VALIDATION_EXCEPTION: Marketo Sync User has access to change Override only for MAL leads"

There is not really a way for me to add condition(Lead Status has to be MAL) to Block Field Update on "Override" field. But we can't have this record out of sync due to future list uploads. I was thinking if there is a way in Salesforce to change the validation rule to something else just so the record can still be sync'd but this field won't get overridden if status is not MAL by Marketo sync user. Is there such thing?

Any ideas/thoughts/recommendations? Thank you in advance!!!

[SanfordWhiteman · Accepted solution]

Sounds like you should have a Marketo-only field (e.g. proxy field) that you map in your list uploads instead of the real Override. Then you can trigger and determine whether the real field should be updated based in other criteria.

[Emma_Wu]

Thanks Sanford! That's one great idea.