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.
See the toFixed() function.
Thanks, I will try to make use.
@shimonsuissa1954 I don’t think it answers your question. But your question wasn’t clear enough and it’s hard to understand what exactly you wanted to do.
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”.
"Unfortunately, the collection doesn’t support numeric fields with decimal values. " Why not?
You can save a numeric value with decimal.
@jonatandor35 I saw that I c’a save decimal in the collectio, but the user data input can’t be with decimal if the fields is of numeric type.
@shimonsuissa1954 That’s also not true. A numeric user input can contain a value like 1.5 etc…
@jonatandor35 Who, great how I can do that? When I define a user input an number it allows only integer. It even display arrows which increment only by integer.
I feel stupid, so you can just send me to a reference.
Thanks, in advance.
@shimonsuissa1954 the arrows are for +1 and -1, so if you currently have an integer in the user input (or nothing which is equivalent to 0), then clicking the arrow will give you an integer as well.
But if the user types “3.7” it’ll accept it.
You can also push a certain value to the user input by code if you want.
@jonatandor35 Thanks, you are right again. My last issue now, is how to save it in the collection with decimal digits. Currently, I use: “rooms”: parseInt($w(“#input5”).value, 10),
That way the decimal digits are omitted. I’m sure the parseInt function has a parameter for that, but I can’t find it.
Or maybe I should use the NumberOf().
Please help.
Number($w("#input5").value)
@jonatandor35 Thanks, it works. There is a small issue, which I can ignore, but I would appreciate if you know a solution.
When the users enter a number with decimal, the field frame become red and there is also a warning that the nearest integer values should be entered. But, as you said the decimal digits are accepted and saved correctly in the collection.
In any case, I would like to tank you again for you great help. Thanks.
@shimonsuissa1954 I don’t know. Maybe you have a regex pattern validation that limits it to integers. Click the element > Settings > scroll down and turn off the pattern validation.