JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Calculation widget is not working correctly in the formAsked 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.
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.
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:
You can edit the items and reduce the number of available quantity based on your current inventory.
Let us know if you have questions.
By the way, you can hide the calculation in the form view. Just set it to hide from its properties:
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!
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.