-
skilltechstoresAsked on September 16, 2024 at 9:51 PM
This form https://form.jotform.com/240737610146856 - working fine except for the last to selection options under section "Items for Xcover6 Pro Only". If you enter 20 or 40 into these number properties boxes the calculation is multiplying by .2 or .4 instead of 20 or 40. For any other value the calculation works correctly. For every other number property entry the calculation works correctly (even if it is 20 or 40). Very strange, it appears only on these two values. I have reentered the formula for the calculated field several times without success. What am I missing here?
-
Jessica JotForm SupportReplied on September 17, 2024 at 2:28 AM
Hi skilltechstores,
Thanks for reaching out to Jotform Support. We’ll need a bit of time to look into this. We'll get back to you as soon as we can.
We appreciate your patience and understanding in this.
-
Jessica JotForm SupportReplied on September 17, 2024 at 2:44 AM
Hi skilltechstores,
After more checking, this issue occurs due to Masked Input's Number Precision is set to 2. Therefore, since the calculation of 20, 40 quantity received a round number without comma ($41.00), Masked Input still convert the number precision to 2.
You might want to consider removing Masked Input, and add $ string at the beginning of your Form Calculation. Let me walk you through the steps:
- In Form Builder, click on Calculate Value.
- Click on wand icon beside the blue border.
- Add $ at the beginning of calculation. Make sure it's colored gray.
- Scroll down and click on Save.
When it's a round number, your Form Calculation will not show the decimal, such as below:
But when it's decimal number, your Form Calculation will show it as per usual:
Let us know if you need more help.
-
skilltechstoresReplied on September 17, 2024 at 3:39 AM
Ok that's a much neater solution by putting the mask on the calculated field.
I also found that by using the options on the Calculation Widget the decimals can be shown and by making it read only I've eliminated the other two fields (which was not very elegant) and just make Calculation Widget display the value for approval and drive the visibility of the submit button.
-
Silvano JotForm SupportReplied on September 17, 2024 at 3:57 AM
Hi skilltechstores,
Just to confirm, this is now resolved, and you're fine with the resolution provided by my colleague and the minor changes you made. Right?
Reach out again if there’s anything else we can help you with.
-
skilltechstoresReplied on September 17, 2024 at 4:04 AM
Yes all resolved.