How do I limit a numeric field

erez1964 · February 23, 2021, 11:57am

Hi Bubblers
How do I limit a numeric field to be exactly 9 digits
Thank you

cmarchan · February 23, 2021, 12:04pm

The dB needs to be feed data via inputs

Set the input to integer and its character count to 9

erez1964 · February 23, 2021, 12:31pm

Dear Cmarchan
Thanks for replying so quickly.

I have no choice “number of characters is 9”.

cmarchan · February 23, 2021, 12:41pm

Sorry my bad

Consider making it a text and when you save it to the dB convert it to a number

erez1964 · February 23, 2021, 1:44pm

Dear Cmarchan
Sorry, I didn’t explain myself well.

I need to be able to type in exactly 9 numbers, neither less nor more.

I know how to limit the number of characters, but not the minimum.

cmarchan · February 23, 2021, 1:53pm

Yeap that us the idea. Check the expression that I suggested. It requires them to be 9. You can add other conditions as well.

system · May 4, 2021, 11:57am

This topic was automatically closed after 70 days. New replies are no longer allowed.