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 the Length() function like so in a formula check box field.
if(
length([phone number])<10,true,false
)
- 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.
