SOLVED

Record failed to sync to SFDC-FIELD VALIDATION EXCEPTION

Go to solution
Emma_Wu
Level 1

Record failed to sync to SFDC-FIELD VALIDATION EXCEPTION

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!!!

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Record failed to sync to SFDC-FIELD VALIDATION EXCEPTION

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.

View solution in original post

2 REPLIES 2
SanfordWhiteman
Level 10 - Community Moderator

Re: Record failed to sync to SFDC-FIELD VALIDATION EXCEPTION

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.

View solution in original post

Emma_Wu
Level 1

Re: Record failed to sync to SFDC-FIELD VALIDATION EXCEPTION

Thanks Sanford! That's one great idea.