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. 
  • 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.
  • RajHelaiya's avatar
    RajHelaiya
    Qrew Captain
    8 years ago
    This definitely worked. Thank you