You need to sign in to do that
Don't have an account?
SUNETRA DEY
Stuck in the Automate Accounts challenge of Process Automation Specialist Superbadge
I am unable to complete the second chllenge on Automate Accounts in Process Automation Specialist Superbadge.I'm getting this error-
*
Challenge Not yet complete... here's what's wrong:
A validation rule did not prevent a new Account from being saved when Shipping Country is blank and Shipping State has three characters.
*
I have used the following Validation Rules on Accounts object-
(1)Billing_Country_Validation_Rule-------------------------------------------
Validation Formula: --------------------------------------------------------------------------------------------------- NOT(OR(BillingCountry = "US", BillingCountry = "USA", BillingCountry = "United States", ISBLANK(BillingCountry))) ------------------------------------------------------------------------------------------------------
(2).Billing_State_Validation_Rules -----------------------------------------------Validation Formula-------------------------------------------------------
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:PR", BillingState)) ) ------------------------------------------------------------------------------------------------------- (3).For_Customer_Channel ----------------------------------------------------------Validation Formula--------------------------------------------
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Channel') -------------------------------------------------------------------------------------------------(4).For_Customer_Direct -------------------------------------------------------------Validation Formula-----------------------------------------
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Direct' ) ----------------------------------------------------------------------------------------------------- (5).Shipping_Country_Validation_Rule ----------------------------------------Validation Formula----------------------------------------------------------- NOT(OR(ShippingCountry = "US", ShippingCountry = "USA", ShippingCountry = "United States", ISBLANK(ShippingCountry))) ---------------------------------------------------------------------------------------------- (6).Shipping_State_Validation_Rule----------------------------------
Validation Formula---------------------------------------------- OR(LEN(ShippingState) != 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", ShippingState)) )
Please help me to complete this challenge...
*
Challenge Not yet complete... here's what's wrong:
A validation rule did not prevent a new Account from being saved when Shipping Country is blank and Shipping State has three characters.
*
I have used the following Validation Rules on Accounts object-
(1)Billing_Country_Validation_Rule-------------------------------------------
Validation Formula: --------------------------------------------------------------------------------------------------- NOT(OR(BillingCountry = "US", BillingCountry = "USA", BillingCountry = "United States", ISBLANK(BillingCountry))) ------------------------------------------------------------------------------------------------------
(2).Billing_State_Validation_Rules -----------------------------------------------Validation Formula-------------------------------------------------------
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:PR", BillingState)) ) ------------------------------------------------------------------------------------------------------- (3).For_Customer_Channel ----------------------------------------------------------Validation Formula--------------------------------------------
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Channel') -------------------------------------------------------------------------------------------------(4).For_Customer_Direct -------------------------------------------------------------Validation Formula-----------------------------------------
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Direct' ) ----------------------------------------------------------------------------------------------------- (5).Shipping_Country_Validation_Rule ----------------------------------------Validation Formula----------------------------------------------------------- NOT(OR(ShippingCountry = "US", ShippingCountry = "USA", ShippingCountry = "United States", ISBLANK(ShippingCountry))) ---------------------------------------------------------------------------------------------- (6).Shipping_State_Validation_Rule----------------------------------
Validation Formula---------------------------------------------- OR(LEN(ShippingState) != 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", ShippingState)) )
Please help me to complete this challenge...
For all the Trailhead issues please report it here,
https://trailhead.salesforce.com/help?support=home#
So that our trailhead support engineers will look into it and get back to you.
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Regards,
Salesforce Support.