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
• Question
• Updated 1 year ago
How do I make sure that the phone number entered in my form is 10 digits and throw an error if it is wrong?
• 1,450 Points Posted 1 year ago

• 0
• 31,698 Points 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.
• 4,430 Points 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)
• 1,450 Points 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.
• 4,430 Points 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)
• 1,450 Points Got it, thanks. It worked, I was calculating on the assumption length =10.