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,358 Points
Posted 1 year ago
 31,678 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,338 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,338 Points
Got it, thanks. It worked, I was calculating on the assumption length =10.
Related Categories

App builders
 894 Conversations
 45 Followers

APIs & custom code
 1462 Conversations
 57 Followers

Errors
 101 Conversations
 5 Followers

Forms
 3262 Conversations
 134 Followers

Formulas & functions
 2912 Conversations
 74 Followers

Tips & tricks
 360 Conversations
 31 Followers

Ask about Quick Base functionality
 925 Conversations
 66 Followers