You need to sign in to do that
Don't have an account?
SUNETRA DEY
Unable to solve the Automate Accounts challenge of Process Automation Specialist Superbadge
I am stuck in 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.
Visit below links and find your solution:
https://trailheadbaby.blogspot.com/2017/09/process-automation-specialist_19.html
https://www.salesforce-devops.com/p/process-automation-specialist.html
https://jayakrishnasfdc.wordpress.com/2018/08/05/process-automation-super-badge/
https://techforceservices.com.au/salesforce/process-automation-specialist-superbadge/
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks and Regards,
Sachin Arora
www.sachinsf.com
Please help me to resolve the error.