Validation of form input

hello i have a form input field that’s meant to capture a 6 digit number. whats the validation code for this .please see image attached

I also need help on specifying input patterns for this “123 UAX4” (3 digits space 3latters and a digit at the end)

0 7 1,204
7 REPLIES 7

LeventK
Participant V

@gilbert_mwesigwa
What’s your validation for that [IMEI] column?

i want it to only except 6 numbers example 123456

Can it began with “0” (zero) for example? If not and it’s a mere number type; than you can set the Display Mode of your Number columns as Label and use a validation of:

[IMEI] <= 999999

hi LaventK i tried
[IMEI] <= 999999

but this allow even inputs that donot make 6 digits .yet i want it to allow only 6 digits not less not more

Logic is the same…To allow exactly 6 digits, the valid if shall be:

LEN(CONCATENATE([IMEI])) = 6

let me try it out

Steve
Participant V

Please post a screenshot of the expression. From the error message, it appears you’ve improperly included a leading = and enclosed the remainder of the expression in quotes.

Top Labels in this Space