+ Start a Discussion
Navneeth RajNavneeth Raj 

Validation rule error1

User-added image
Scenario when user enter numbers other than ten digits error should arise.
But above error oscurs
(use this validation WITHOUT REGEX function)
JLA.ovhJLA.ovh
You are comparing a phone number value with the number 10. You should check the length of the field instead
Such as
LEN(Phone_Number__c)  <>10

 
Raja Bipin Chandra  M BRaja Bipin Chandra M B
Did you try 

OR(
  AND (Phone_Number__c <> '10' , Alternate_Phone_Number__c <> '10'),0)


Regards,
Raja
Vijay NagarathinamVijay Nagarathinam
Hi Navneeth,

Can you try the following validation rule,
 
AND(LEN(Phone_Number__c) <> 10 , LEN(Alternate_Phone_Number__c) <> 10)