I can't see where to define decimal point in numerical field. Please let me know if there is such option.
I'm now working to bypass this limitation. Has somebody wrote a JS code to bypass this elementary feature ? e.g., input/output as text field like "3.5" & saving it as 35 for example in the collection.
I need a numeric user input with 1 or 2 decimals. I also need to save the value in the collection with decimals because I need to filter or query with decimal values.
Unfortunately, the collection doesn't support numeric fields with decimal values.
So, I was thinking to make the user data input as text with some pattern validation or drop down list and moving the data entry into a integer numeric fields.
So, in the collection I will have 2 fields one numeric e.g., 35 and when as text "3.5".
If this will work, I will be able to do the query using the numeric fields.
It will be a lot of work, because I will need to do this exercise in several data entry and query pages.
Your above solution doesn't work for me because when I saved for example 35 in the numeric field in the collection, it displayed 35.0 in the text field, where I expected "3.5".
See the toFixed() function.