How can I make a limit to the ‘integer’ data type?

TanzilHuda · October 31, 2019, 3:10am

My limit will be 01-99. No one can enter ‘1’. The user has to input ‘01’. That means in the integer (Number) data types users must have to input always 2 digit numbers.

2%20digit

Thanks in Advanced

Grzesiek2010 · October 31, 2019, 7:23am

Hi @TanzilHuda

you need to use regex something like just 0[1-9]|[1-9][0-9] maybe?

TanzilHuda · October 31, 2019, 9:00am

Thanks, @Grzesiek2010, I have tried just like your suggestion. But it's not working. Would you show me the exact code?
regularexpre

Grzesiek2010 · October 31, 2019, 9:54am

Hmmm I'm not an regex expert I just tested it using an online tool like https://regexr.com/ and it was fine.

TanzilHuda · October 31, 2019, 11:32am

It works on string data type. But not working on 'numeric' data type

Andrea_Martin · October 31, 2019, 2:58pm

Hi @TanzilHuda

01 is technically not an integer, but a string.

I suggest you use the text data type, setting the constraint="regex(.,'^[0-9]{2}$')"
You can also select appearance="numbers" to ensure the right keyboard is shown to the enumerators.

Reference: https://docs.opendatakit.org/form-regex/#tips-on-using-regular-expressions

I hope this helps!

Best,
Andrea

Xiphware · November 1, 2019, 2:54am

Unfortunately, this permits "00", whereas the requirement was 01-99 [D'oh! ] This seemingly minor nit makes a solution rather messy...

Have a play around (eg here) with this regex instead:

regex(.'^(?!00)[0-9]{2}$')

0-9 ↩︎

TanzilHuda · November 1, 2019, 1:01pm

Thanks everyone. I got the answer. It is: