How do I make sure that the phone number entered in my form is 10 digits and throw an error if it is wrong?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
How do I make sure that the phone number entered in my form is 10 digits and throw an error if it is wrong? 
Photo of Raj Helaiya

Raj Helaiya

  • 1,450 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
You can use a formula field to 'count' the number of digits in the field, and then use a form rule that will show a pop-up if it is not equal to 10.
Photo of Chris

Chris

  • 4,430 Points 4k badge 2x thumb

You can use the Length() function like so in a formula check box field.

if(

length([phone number])<10,true,false

)


I'm not sure if the function would consider the counting of hyphens. Experiment around with it.
(Edited)
Photo of Raj Helaiya

Raj Helaiya

  • 1,450 Points 1k badge 2x thumb
I tried doing that, it does not work. Can you tell me what is the field type that you select for formula? Phone number is of field type PHONE. 
Photo of Chris

Chris

  • 4,430 Points 4k badge 2x thumb

Length will be 14 for a phone data type. It will be in this format (000) 000-0000.

You can make just a formula number field like this:

[formula number field]

length([phone number])


You will likely get 14 as that is what a normal 10 digit phone number will return, 14 characters total.

Then use a form rule to see if this number is at least 14.


(Edited)
Photo of Raj Helaiya

Raj Helaiya

  • 1,450 Points 1k badge 2x thumb
Got it, thanks. It worked, I was calculating on the assumption length =10.