You need to sign in to do that
Don't have an account?
Anil Chundu
Validation rule for address fields are not empty
Hi all,
I have two different addresses in Contact .
OR(
ISBLANK( OtherCountry ) ,
ISBLANK( OtherState ),
ISBLANK( OtherPostalCode ) ,
ISBLANK( OtherStreet ) )
((ISBLANK(BillingCountry) ),
(ISBLANK(BillingState) ),
(ISBLANK(BillingPostalCode) ),
(ISBLANK(BillingStreet) ))
If user entres one of those addresses then validate all the values are filled or empty.
suppose if user enters billing city then remaining billing fields are empty that time validation rule should fire and shows the error message billing address fields should be filled. In this case other address fields shouldn't be validated.
If user enters both addresses then both validations should chck for both addresses.
If he enters only other addresses that validation should check for other address fieldsonly not for billing addresses fields.
Please let me know for clarification.
Thanks
I have two different addresses in Contact .
OR(
ISBLANK( OtherCountry ) ,
ISBLANK( OtherState ),
ISBLANK( OtherPostalCode ) ,
ISBLANK( OtherStreet ) )
((ISBLANK(BillingCountry) ),
(ISBLANK(BillingState) ),
(ISBLANK(BillingPostalCode) ),
(ISBLANK(BillingStreet) ))
If user entres one of those addresses then validate all the values are filled or empty.
suppose if user enters billing city then remaining billing fields are empty that time validation rule should fire and shows the error message billing address fields should be filled. In this case other address fields shouldn't be validated.
If user enters both addresses then both validations should chck for both addresses.
If he enters only other addresses that validation should check for other address fieldsonly not for billing addresses fields.
Please let me know for clarification.
Thanks
Use 2 formula field to set True or false based on any of the address, for example if all blank then true and if all populated then also true otherwise false it will look like something You can add other fields also and you can use this formula field in your validation rule. If the value is false then show error for respective address.
(no need to create extra formula fields)
IF( OR(AND( ISBLANK(TEXT(picklist1)), ISBLANK(TEXT(picklist2)), ISBLANK(text1) , ISBLANK(test2) ),AND( NOT(ISBLANK(TEXT(picklist1))), NOT(ISBLANK(TEXT(picklist2))), NOT(ISBLANK(text1)) , NOT(ISBLANK(test2)) )), FALSE,TRUE )
PLease let me know if it worked out.
You can always mark it as the best answer if it helps.:-)