Forum Discussion

RajHelaiya's avatar
RajHelaiya
Qrew Captain
8 years ago

How to limit a field ""Phone Number"" to only contain 10 digits?

I have a field "Phone Number", I need the user to enter 10 digit phone number in the field. If the user enters digits less than or more than 10, it should display an error message. Is this possible us...
APIs and custom code
App builders
Errors
AlexWilkinson's avatar
AlexWilkinson
Qrew Assistant Captain
8 years ago
Also, you may want to use a more elaborate check-box formula to handle entries containing non-digit characters and extraneous spaces. Something like the following, which handles up to five instances of a period, dash, parenthesis, or space entered as a separator between digits:

var text p=ToText(Trim([Phone Number]));
var text partOne=Part($p,1,".-)( ");
var text partTwo=Part($p,2,".-)( ");
var text partThree=Part($p,3,".-)( ");
var text partFour=Part($p,4,".-)( ");
var text partFive=Part($p,5,".-)( ");

Length($partOne & $partTwo & $partThree & $partFour & $partFive) = 10
RajHelaiya's avatar
RajHelaiya
Qrew Captain
8 years ago
Can you please elaborate on the execution of the formula? As to, which formula field to use? I tried using the formula check box field and create the abort save option but it did not work. The formula field does not check when a 10 digit phone number is entered.