You need to sign in to do that
Don't have an account?
Nae 88101
help needed with Validation rule in Accounts
I have set up the following formulla in Accounts:
AND (
OR(BillingCountry = "US", BillingCountry="USA", LEN(BillingCountry)=0),
OR(
LEN(BillingState) < 2,
NOT(
CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" &
"IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" &
"NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" &
"WA:WV:WI:WY", BillingState)
)))
OR(BillingCountry = "US", BillingCountry="USA", LEN(BillingCountry)=0),
OR(
LEN(BillingState) < 2,
NOT(
CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" &
"IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" &
"NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" &
"WA:WV:WI:WY", BillingState)
)))
My problem is when my users attempt to convert a lead (company is non existant) it gives the following error:
Error: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, A valid two-letter state code is required.: [BillingState] (System Code)
Which is triggerd by the formula above. Is there any way to leave the formula in place but still be able to convert the lead?
AdminisaurusRex
If you use the same exact validation rule on your Lead page, it will ensure that there is enough data on the record before it is converted.