I’ve build a form that submits data to a table.
One element is a Data Input element which I use to collect numbers (weights of material).
I’ve checked that the Data Input element validates if it is a number (not a text).
But it doesn’t accept negative numbers. So if I’m entering -4 and not 4 it runs into an error.
It seems it is the same with decimals. So 2 is okay as a number but 2.5 or 2,5 don’t work?
Any solution for that?
Sorry, my fault: the column in the database wasn’t set to “allow negative numbers”. I’ve changed that and now it works.
Nevertheless the problem with decimals like 2.5 or 2,5 is still relevant.
Unfortunately I’m not able to edit the title of this topic anymore.
Good morning @be_Berlin,
It seems it is the same with decimals. So 2 is okay as a number but 2.5 or 2,5 don’t work?
Have you tried setting the decimal places in your number field? This came up recently in another topic, you should find that “2.5” will be stored in your database table, but unfortunately, we have an issue with storing commas. We have an open issue for this, hopefully, we’ll get it resolved soon.
I hope this helps!
Cheers,
Peter Evans