During synchronizing Acoustic Campaign and Salesforce the same custom validation rules apply. Often when there are custom validation rules in effect, the Acoustic Campaign integration will be unable to update or save the Salesforce record because of a validation rule conflict. It may be advantageous to bypass some validation rules for the integration user only. To put this into perspective, the Acoustic Campaign integration may be attempting to provide the Acoustic Campaign RecipientID during the initial sync with Salesforce or trying to update or opt-out the Salesforce record. A validation rule could prevent these updates from occurring if the record is in a state that would generate a validation rule error if re-saved
The following sample code is an example of a custom validation rule taken from Salesforce's online help and then altered slightly so that it will not be enforced when a specific User ID is updating the record. By adding the last line of code, the validation rule will not be triggered if Salesforce user
00540000000XXXX is attempting to save the Lead record.
OR( LEN(Country) = 1, NOT( CONTAINS( "AF:AX:AL:DZ:AS:AD:AO:AI:AQ:AG:AR:AM:" & "AW:AU:AZ:BS:BH:BD:BB:BY:BE:BZ:BJ:BM:BT:BO:" & "BA:BW:BV:BR:IO:BN:BG:BF:BI:KH:CM:CA:CV:KY:" & "CF:TD:CL:CN:CX:CC:CO:KM:CG:CD:CK:CR:CI:HR:" & "CU:CY:CZ:DK:DJ:DM:DO:EC:EG:SV:GQ:ER:EE:ET:FK:" & "FO:FJ:FI:FR:GF:PF:TF:GA:GM:GE:DE:GH:GI:GR:GL:" & "GD:GP:GU:GT:GG:GN:GW:GY:HT:HM:VA:HN:HK:HU:" & "IS:IN:ID:IR:IQ:IE:IM:IL:IT:JM:JP:JE:JO:KZ:KE:KI:" & "KP:KR:KW:KG:LA:LV:LB:LS:LR:LY:LI:LT:LU:MO:MK:" & "MG:MW:MY:MV:ML:MT:MH:MQ:MR:MU:YT:MX:FM:MD:MC:" & "MC:MN:ME:MS:MA:MZ:MM:MA:NR:NP:NL:AN:NC:NZ:NI:" & "NE:NG:NU:NF:MP:NO:OM:PK:PW:PS:PA:PG:PY:PE:PH:" & "PN:PL:PT:PR:QA:RE:RO:RU:RW:SH:KN:LC:PM:VC:WS:" & "SM:ST:SA:SN:RS:SC:SL:SG:SK:SI:SB:SO:ZA:GS:ES:" & "LK:SD:SR:SJ:SZ:SE:CH:SY:TW:TJ:TZ:TH:TL:TG:TK:" & "TO:TT:TN:TR:TM:TC:TV:UG:UA:AE:GB:US:UM:UY:UZ:" & "VU:VE:VN:VG:VI:WF:EH:YE:ZM:ZW", Country))) && (NOT($User.Id="00540000000XXXX"))
Please sign in to leave a comment.