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

    Spreadsheet widget: It is not updating the total calculation if you change input values

    Asked by OranjeVaal on September 02, 2016 at 08:00 AM

    Hi,

     

    https://form.myjotform.com/OranjeVaal/gewasopname

     

    Check out my form. I'm using Spreadsheet plugin. My problem is that totals are not refreshing if you change input values. 

     

    If user enters 1 and 1 total should be 2.

    But if they change it to 1 and 2 the total remains 2, instead of 3.

     

    How can I beat this?

    Page URL:
    http://www.northernweb.co.za/oranje/forms.html

    Screenshot
    problem check myJotForm refreshing
  • Profile Image
    JotForm Support

    Answered by beril on September 02, 2016 at 10:29 AM

     

    I've checked your form and I have also encountered the same issue on my side. It is not updating the total value if I change the value as you see below:

     

    I have forwarded this to our developers to have it checked and fixed. Apologies for the inconvenience and thank you for your patience on this matter. We will update you on this thread as soon as this has been fixed.

  • Profile Image
    JotForm Support

    Answered by TitusN on September 10, 2016 at 12:14 AM

    We've fixed the issue. The calculations should be working as expected, and the spreadsheet performance improved. 

    Please check and let us know.