0

Hi everyone, I thought that no matter what, a decimal will be saved in the database with 8 digits. This is also a requirement. We need to show 4 digits on screen, but when a user enters >4 digits, we want to save it with 8 digits and do calculations with 8, only to round on screen. Now I figured that when on screen you say decimal mode is fixed with a precision of 4, the decimal will be saved with 4 digits. Is it possible to show something different than is saved? Thanks in advance.

asked

Lisa van de Put

1 answers

1

Hi Lisa,

Yes, it is possible to store the decimal in 8 digits behind the decimal point.

When displaying the decimal that is stored, you will define the format it is shown.

When creating the input field I would use auto, not fixed to 4:

Cheers,

Marco

answered

Marco Spoel