Validation Rule for Phone Number that should only contain numbers and +

Question

I'm trying to create a validation rule for Phone Numbers. Say, I have three Phone Number fields that should be checked if the values meet the following requirements:

1. phone numbers should be 10-12 digits in length
2. only numbers are accepted
3. "+" symbol in the beginning of the number is still acceptable

I came up with a rule using REGEX but it only accepts numbers that start with +. Clearly not the requirement since putting + in the beginning is just optional.

This is my rule so far:

NOT( 
AND( 
OR( 
LEN(Phone) = 0, 
REGEX(Phone, "\\+[0-9 ]+") 
), 
OR( 
LEN(MobilePhone) = 0, 
REGEX(MobilePhone, "\\+[0-9 ]+") 
), 
OR( 
LEN(OtherPhone) = 0, 
REGEX(OtherPhone, "\\+[0-9 ]+") 
) 
) 
)

I'm hoping if you can spare some time to help me with my validation rule. I'm still new to Salesforce so I'm still figuring things out. Thank you.

Answer 1

There is already another answer with shorter solution but I still wanted to answer. Below validation rule should work for your situation, too.

OR( 
OR( 
LEN( Phone ) <= 9 , 
LEN( Phone ) >= 13 
), 
NOT( 
OR( 
REGEX(Phone, "[0-9 ]+"), 
REGEX(Phone, "\\+[0-9 ]+")) 
) 
)

Answer 2

You can use following RegEx for making sure the phone number has 10 to 12 digits and starts with a + sign,

REGEX(<Phone Field Name>, "\\+{0,1}[0-9]{10,12}")

Hope this helps.

Best Regards!

Answer 3

not(isnumber(your phone number field))||len(your phone number field)<>**10**)

As I'm an Indian My mobile number should be equal to 10 you can add any number over there

Answer 4

Here's my short rule, allowing for:

• Blank Fields
• Numbers
• Spaces, Plus Sign, ( ), period

This means that your existing fields don't throw a validation error if your users used a . or space as is common!

AND(
  NOT(ISBLANK(MobilePhone)),
  NOT(REGEX(MobilePhone, "^([0-9+\\-\\s\\(\\)\\.])*$"))
)