Apex Code Development You need to sign in to do that
Don't have an account?
nihar Validation Rule for Phone Numbers Country Code and Number
Hi all,
I'm trying to create a validation rule for our phone numbers. Every number has 2 parts:
Country Code (numerical, 1 digit starts with '+') --> +1
Number (numerical, no digit limit, cannot start with 0)
Examples:
+12019841724
Thanks for help.
I'm trying to create a validation rule for our phone numbers. Every number has 2 parts:
Country Code (numerical, 1 digit starts with '+') --> +1
Number (numerical, no digit limit, cannot start with 0)
Examples:
+12019841724
Thanks for help.
Try using this formula
AND( NOT(ISBLANK(Phone)),NOT(REGEX( Phone , "[+][0-9]{1}[1-9]{1}[0-9]*?")) )Hope this helps you
If this helps kindly mark it as solved so that it may help others in future.
Thanks and Regards
All Answers
Usually, country codes vary some might have 0ne and some will have 2 or 3.
Secondly do you separate country code and phone by - or any space.
The best way is to use the Regex function.
Have you tried using regex ,
form the regex such that it will suit your requirement, add it into validation rule.
for example : to allow only +1 1 +12 12 +123 1234
use regex like :
/^(\+?\d{1,3}|\d{1,4})$/
Thanks,
Aman
Try using this formula
AND( NOT(ISBLANK(Phone)),NOT(REGEX( Phone , "[+][0-9]{1}[1-9]{1}[0-9]*?")) )Hope this helps you
If this helps kindly mark it as solved so that it may help others in future.
Thanks and Regards