Skip to main content
Topics#Salesforce DeveloperDeveloper Forums User (Inactive)'s Question
Developer Forums User (Inactive) (Salesforce Developer Forums) asked in #Salesforce Developer
Aug 12, 2016, 2:04 AM

Is there a way to check phone number format?

If I try the phone format in the field, it can provide a phone format.However, even I type in character, the system still accept it. If I use the number format, it can restrict users only to type number. However, the outlook of data will become a number format with this sign (","). How can I solve this problem? Thank you.
2 answers
  1. Onesh Reddy (Solunus Inc)
    Aug 12, 2016, 6:31 AM
     Hi Alex,

    Yes, there is a way to check phone number format.

    The below Validation Formula checks the phone number format as 999-999-9999.

    1) Create a Validation rule for the PHONE Field.(Validates the Format of Data before saving)

    2) Under Error Condition Formula add the syntax : NOT(REGEX(Phone, "[0-9]{3}-[0-9]{3}-[0-9]{4}"))

    3) Give a Error message to display.

    4) Save.

    or 

    The below Validation Formula that the Phone number is in (999) 999-9999 format.

    This works by using the REGEX function to check that the number has ten digits in the (999) 999-9999 format.

    Formula: NOT(REGEX(Phone, "\\D*?(\\d\\D*?){10}"))

    Error Message:US phone numbers should be in this format: (999) 999-9999.

    Let me know if it helps you,

    Best Regards,

    Onesh.K

     
Loading
Write an answer...
0/9000