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
 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 popup 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
)
(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) 0000000.
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.
Related Categories

App builders
 929 Conversations
 45 Followers

APIs & custom code
 1493 Conversations
 61 Followers

Errors
 106 Conversations
 6 Followers

Forms
 3297 Conversations
 138 Followers

Formulas & functions
 2973 Conversations
 79 Followers

Tips & tricks
 379 Conversations
 31 Followers

Ask about Quick Base functionality
 936 Conversations
 66 Followers