Hello,
I am trying to accurately store very small decimal numbers but the numbers are automatically changed to "#.#" format.
i.e.
0.000000123 becomes 1.23
Decimal needs at least 6 0's
The database stores the modified value (1.23)
Below is a gif of it happening.
https://puu.sh/JlwVy/2d8d01d8cd.gif
To Replicate the problem:
1) Create a number field in an attribute
2) format is #.############### (other formats may have the same problem)
3) Make sure number field is in the form
4) run test version and open form
5) input small decimal with 6 or more 0's after the decimal point
6) Save form
Is there a way for me to handle this behavior?
Another problem is aware im seems to handle numbers with a precision of 16. Is there a way to increase that?