Format that should accept only positive numbers

[anuja.dalal]

Servoy version: 6.1.4 i1.

We are applying format over a field so that it should only accept numbers of length 8. Format is applied on table level. Data type of column is number in database.
Display/Edit format that has been used is ########. Now the problem is, it allows user to input -, % and $ sign. In order to prevent user from inputting negative number we also used NumberRangeValidator on the same field. Although we prevented -ve numbers but problem comes when user tries to input something like '123-456'. It truncates string '-456' leaving just '123' behind. Is there format mask available that will not let user input something like this at first place. Is there a way we can force user to input only numbers in the field using format.

Thanks,
Anuja

[david]

Write your own column converter. It's not hard—example template you can refer to: https://www.servoyforge.net/projects/fractions/wiki

[chaitanyas]

HI @anuja ,

Follow this post for accept only positive numbers,

viewtopic.php?f=2&t=15937

Thanks
Chaitanya s