Hello everybody,
I could write validation rule to prevent half entry of address...But it is not accepting when it is completely blank.
The validation rule I have written is
OR(OR(Billing_Street__c<>null,ISBLANK( Billing_City__c ),ISBLANK( Billing_State__c ),ISBLANK( Billing_Country__c ),ISBLANK(Billing_Zip_Code__c )),
OR(Billing_City__c<>null,ISBLANK( Billing_Street__c ),ISBLANK( Billing_State__c ),ISBLANK( Billing_Country__c ),ISBLANK(Billing_Zip_Code__c )),
OR(Billing_State__c<>null,ISBLANK( Billing_City__c ),ISBLANK( Billing_Street__c ),ISBLANK( Billing_Country__c ),ISBLANK(Billing_Zip_Code__c )),
OR(Billing_Country__c<>null,ISBLANK( Billing_City__c ),ISBLANK( Billing_State__c ),ISBLANK( Billing_Street__c ),ISBLANK(Billing_Zip_Code__c )),
OR(Billing_Zip_Code__c<>null,ISBLANK( Billing_City__c ),ISBLANK( Billing_State__c ),ISBLANK( Billing_Country__c ),ISBLANK(Billing_Street__c )))
Can you please tell me what is the mistake?? By the way I am new to sfdc.
Thanks.
