• Sinan Bunni 24
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
Hi All,
I know this quesiton has been asked by many and answered in many different way, however, I am still not able to fix the issus in the Lead State validation rule... I am getting this error:

Challenge Not yet complete... here's what's wrong: 
There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Only valid US states are allowed: []

My validation rule is as below:
 
OR( 
   LEN(State) <> 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:PR", State))
   )

any help is highly appreciated. Thanks
 
Hi All,
I know this quesiton has been asked by many and answered in many different way, however, I am still not able to fix the issus in the Lead State validation rule... I am getting this error:

Challenge Not yet complete... here's what's wrong: 
There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Only valid US states are allowed: []

My validation rule is as below:
 
OR( 
   LEN(State) <> 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:PR", State))
   )

any help is highly appreciated. Thanks