Decimal value become Zero after submission

Forms
1

Hi,

I updated the number field with the value (0.000001) and saved the form. After the initial submission, the value correctly appeared as (0.000001) in the list and remained (0.000001) when I reopened the form.

However, when I saved the form without making any changes, the number field values in both the list and the form changed to zero.

There are no issues with other values such as (0.001), (0.0001), or (0.00001).
Maybe it automatically rounds off to 5 decimal places.

Attached are screenshots of the form and field configuration for your reference.

image
image588×565 10.8 KB

image

Thanks in advance
Pannir Veloo

2

Hi @Margo,

Can you help me with this issue? Thanks.

3

Hi @Pannir,

Try using this code:

fd.rendered(() => {
    fd.field('Number1').widgetOptions = {
        decimals: 8,
        format: 'n8'
    }
});
4

Hi @IliaLazarevskii

After using the code above, the results are still the same.

Step 1: I have entered "0.00000110" and saved the form (1st save). The value is captured in the list view as well.
image image
Step 2: Select the record and open with editing mode, the value is shown as expected. Then, simply save the form (2nd save) without any change. After saving, the value in the list view changed to "0".
image image
Step 3: Re-open the record in editing mode, the value shows "0.00000000".
image

I already tried the code with and without "Round: True / False". Still the same.
image

The number field is automatically rounded to 5 decimal places after the submission.

Thanks.

5

Hi @Pannir,

Could you make sure that New and Edit forms are the same? You can check which one you're saving here:
image

6

Hi @IliaLazarevskii,

For this list new & edit form layouts are different. This number field is mainly used in the edit form.

I tested the field in the edit form.

image

7

Hi @Pannir,

I still can't reproduce the issue. Could you export the form and send it to support@plumsail.com?