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.


  • Profile Image

    Calculated field won't go to zero value

    Asked by AA_C on July 16, 2014 at 11:27 AM

    Hi

    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.

    Thanks, Bob

     

    Page URL:
    http://form.jotformpro.com/form/41955860830965

    new form Calculated Value test form thanks
  • Profile Image
    JotForm Support

    Answered by BDAVID on July 16, 2014 at 12:53 PM

    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?

  • Profile Image

    Answered by AA_C on July 16, 2014 at 03:32 PM

    Hi,

    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?

     

    Thanks  

  • Profile Image
    JotForm Support

    Answered by BDAVID on July 16, 2014 at 04:19 PM

    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.

  • Profile Image

    Answered by AA_C on July 16, 2014 at 07:24 PM

    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

    Bob

  • Profile Image
    JotForm Support

    Answered by ashwin_d on July 17, 2014 at 03:36 AM

    Hello AA_C,

    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.

    Thank you!