Calculation widget is not working correctly in the form

  • Profile Image
    sloughbottom
    Asked 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

  • Profile Image
    Welvin
    Answered 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
    Welvin
    Answered 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
    Welvin
    Answered 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
    sloughbottom
    Answered 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
    Welvin
    Answered 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.