Apex Code Development You need to sign in to do that
Don't have an account?
Validating multiple number formats in one validation rule
Hi,
I am trying to validate the phone number on the contact according to multiple formats. I want users to be able to enter phone numbers that match one of three formats, one starting with "+" , another starting with "00" and finaly one starting with "(".
I can create all of the these as single validation rules, but when I try to combine two or more, I am struggling wiht the logic even if the syntax of the formula is correct.
Any suggestions?
I am trying to validate the phone number on the contact according to multiple formats. I want users to be able to enter phone numbers that match one of three formats, one starting with "+" , another starting with "00" and finaly one starting with "(".
I can create all of the these as single validation rules, but when I try to combine two or more, I am struggling wiht the logic even if the syntax of the formula is correct.
Any suggestions?
NOT( OR(Begins(Phone,"+"),Begins (Phone, "("),Begins (Phone, "00") ))This did the job!
All Answers
So this work for both "00" and "(" as individual rules, but as a combination... I get a bit lost as I can't seem to be able to get an OR logic.
I have also tried with a LEFT function and it also works for individual rules.
I tried REGEX, but since I only need the first character(s) to of a specific kind, regardless of how many digits follow, I am not sure how to use it.
NOT( OR(Begins(Phone,"+"),Begins (Phone, "("),Begins (Phone, "00") ))This did the job!