Forum Discussion
ChrisChris
8 years agoQrew Assistant Captain
You can use the Length() function like so in a formula check box field.
if(
length([phone number])<10,true,false
)
- RajHelaiya8 years agoQrew CaptainI 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.
- ChrisChris8 years agoQrew Assistant Captain
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.
- RajHelaiya8 years agoQrew CaptainGot it, thanks. It worked, I was calculating on the assumption length =10.