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
EvanMartinez's avatar
EvanMartinez
Moderator
8 years ago
Hi Raj,

That formula Alex post does a more in depth look at the Length portion in order to do the Counting. It still needs the If statement that does the check for true and false. So something like

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,".-)( ");

If(Length($partOne & $partTwo & $partThree & $partFour & $partFive) = 10, True, False)

I believe should not just check the length of the number but check or uncheck that box for the form rule.