You need to sign in to do that
Don't have an account?
Praveen Bonalu
Compare the Phone numbers and display the errors when they match
Hi experts,
I have 5 phone fileds
1)home phone
2)cellphone
3)work phone
4)reference1phone
5)reference 2 phone.
None of the filelds should have the same number .Is it possible to display the error through the validation rule if the fileds have same number
Thanks
Praveen
I have 5 phone fileds
1)home phone
2)cellphone
3)work phone
4)reference1phone
5)reference 2 phone.
None of the filelds should have the same number .Is it possible to display the error through the validation rule if the fileds have same number
Thanks
Praveen
You have to create a new validation rule and add logical condition in OR operator like
OR( Home_phone__c == cellphone__c,Home_phone__c == work_phone__c,..... )
Thanks and Regards,
Ajay Rawat
Just copy and paste the rule and let me know this is fine for your problem and i did test in my org also.
OR( Home_phone__c == cellphone__c,Home_phone__c == work_phone__c,Home_phone__c == reference1phone__c,Home_phone__c==reference2phone__c )
Thanks
Gyanender Singh
http://www.mirketa.com