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

    Calculation widget is not working correctly in the form

    Asked by sloughbottom on October 21, 2016 at 02:03 PM

    I have been using my form for quite a while with many seamless submissions.

    However the past 4 or 5 submissions have been completely wonky with the addition in the calculation widget.
    I have gone over the formulas dozens of times and I think I have fixed it - and then the next submission it comes in all wrong again.

    The way the numbers are set up all bubbly and colourful is really hard for my brain to process so maybe that is part of the reason. I can't see a mistake but maybe someone else can.

    Please help!
    Justine

    Page URL:
    https://form.jotform.com/62046058461251

    calculation widget
  • Profile Image
    JotForm Support

    Answered by Welvin on October 21, 2016 at 04:33 PM

    The calculation results to 3 even though no option is selected yet. I'm looking at this now, I'll let you know later what can be done. 

  • Profile Image
    JotForm Support

    Answered by Welvin on October 21, 2016 at 05:19 PM

    I'm not sure why, but adding all the items in single calculation won't work. You have to get the total for each item first before getting the total. 

    Here's a cloned version of your form: https://form.jotform.com/62946011301949. You'll see, I have calculated each item. You can do the same to make it work while I am investigating this. Feel free to clone my form back and use it, here's how:

    https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    You can edit the items and reduce the number of available quantity based on your current inventory. 

    Let us know if you have questions.

  • Profile Image
    JotForm Support

    Answered by Welvin on October 21, 2016 at 05:26 PM

    By the way, you can hide the calculation in the form view. Just set it to hide from its properties:

  • Profile Image

    Answered by sloughbottom on October 26, 2016 at 11:04 AM

    Thank you Welvin! that is indeed quite bizarre - it was working so well before.

    I will try your cloned form - thanks for doing that work for me. We have a slow internet connection and it would have taken me forever to add all of those fields.

    I will definitely hide the additional calculation fields. Thanks for that tip!

  • Profile Image
    JotForm Support

    Answered by Welvin on October 26, 2016 at 12:23 PM

    You're welcome. I understand and I think the issue is with the equation, I just can't find it. I will bookmark this thread and investigate it further then let you know my findings.