[SalesForce] Validation rule for phone number

how to write validation rules for phone number in below format

+()-

Example : +(91)-1234567890

When end user entering value for phone number it should only allow mentioned special characters + () – and numeric numbers.

exiting validation rule

IF( ISBLANK(End_User_Contact_Phone__c) , false, NOT(REGEX(End_User_Contact_Phone__c, "\D*?(\d\D*?){10}")))

Best Answer

This should do the trick given the requirements:

NOT(REGEX(Phone, "[0-9+\\-\\(\\)]*"))

But it will allow for some funky phone numbers that are definitely not valid, e.g. "+123-+()()()"

Related Solutions

[SalesForce] Regex in the validation rule

Try this RegEx [0-9]{6}(;[0-9]{6})*

[SalesForce] Phone Field in Custom Object

As @crmprogdev mentioned, I would recommend to use RegEx. See this example for US Phone number has 10 digits in (999) 999-9999 format: NOT(REGEX(Phone, "\\D*?(\\d\\D*?){10}")) in UsefulValidationRules

If you don't like RegEx, you can use an alternativly an onion-like SUBSTITUTE. If you need other characters excluded, you'll have to add more SUBSTITUTEs. TRIM removes white space and LEN counts the cleaned results:

 LEN(
   SUBSTITUTE(
     SUBSTITUTE(
       SUBSTITUTE( 
         TRIM(YourFieled__c) 
       , "+", "")
     , "(", "")
   , ")", "")
 ) < 10

Best Answer

Related Solutions

[SalesForce] Regex in the validation rule

[SalesForce] Phone Field in Custom Object

Related Topic