What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Calculated field won't go to zero valueAsked by AA_C on July 16, 2014 at 11:27 AM
I am trying to use the calculation widget on a new form. It appears to function properly as long as a zero is not entered into a field where a value greater then zero was before. Any new value greater then zero is calculated correctly if you change it to zero it is not recalculated properly.
How do I get it to calculate zero so field has no value without resetting the complete form?
Do I need some java script function?
I have provided a link to the test form. So for example if you enter a value of 10 for FEO runs and then realize there were 0 FEO runs you can't enter a 0 and and get 0 dollars it stays at the first calculated value, why????, if you enter .01 it calculates a new value.
I hope I'm clear with my question.
new form Calculated Value test form thanks
I was not able to reproduce the issue, when I entered a zero value after entering a 10 value in the "FEO" field, everything goes back to zero. Of course it will not zero if a value is entered on the "Total Runs" field. Could you let us know if this is happening on a specific browser?
I tried it with IE and Chrome.
I should be able to zero total runs also.
I wounder if the browser is not clearing properly...Although the new values appear if anything other the a 0 is entered. You say "Of course it will not zero if a value is entered in the 'Total Runs' field", why not I ask?
I see what happens now, I entered some random values, and close the window, when loading the form again, the "Calculate amount" fields was still filled with the previous result, I zero the "Total Runs" and "FOE" fields, but the previous result was still there.
This is happening because the auto fill option on the form is enabled, in order to disable it, please do the following:
1)Click on Setup&Embed
2)Click on Preferences
3)Click on Advance Settings
4)Then on Edit Auto Fill Settings
5)Select the Disable option
Let us know if you have more questions, we will be glad to assist you.
BRAVO! ... Working now... Thank you
Another question... How do I make the calculated fields display as currency with a $ sign?
I don't see the option in properties
On behalf of my colleague, you are welcome.
On your question related to displaying the "$" sign in the calculated value, there is no built in feature to achieve your requirement. You will have to manually add the "$" in the formula of the "Form Calculation" widget. Please check the screenshot below:
Hope this helps.
Do get back to us if you have any questions.