How do I make sure that the phone number entered in my form is 10 digits and throw an error if it is wrong?
How do I make sure that the phone number entered in my form is 10 digits and throw an error if it is wrong?
Forum Discussion
- 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.
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.- 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.
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.
- Got it, thanks. It worked, I was calculating on the assumption length =10.
