Incorrect Form Calculation

  • kmcquarr
    Asked on March 27, 2025 at 2:59 PM

    Hello,

    I created an input table (contains numeric values). Under the table I created a form calculation widget to add the values that were entered in the table. Then, on a new page, I created another input table similar to the first one but which serves a different purpose (still requires numeric input). I also added a form calc widget under the 2nd table. However the sum from the calculation widget on the first page carries over to the calc widget on the 2nd page even when there are no values in the 2nd table. I would like each page and the calc widget to function independently so that the form calc widget references the table on the same page. How do I accomplish that?


    Thanks.

  • Eliza JotForm Support
    Replied on March 27, 2025 at 7:57 PM

    Hi Ken,

    Thanks for reaching out to Jotform Support. When I cloned and tested your form, the same thing happened for me. After investigating it a bit, I found that the fields selected for the calculation are for the Input Table field on page 1. Let me show you how to fix this:

    1. In Form Builder, click on the Form Calculation widget on page 2, and select the Wand icon on the right.
    2. On the Widget Settings panel, remove the formula you have, and click on the Add Field button.
    3. Select field #8 for the calculation.
    4. Once done, click on Save at the bottom.

    Incorrect Form Calculation Image 1 Screenshot 30

    Here's a screenshot of the correct calculation:

    Incorrect Form Calculation Image 2 Screenshot 41

    You can do the same for the other Form Calculation widget on Page 2.

    Give it a try and let us know if you need any other help.

Your Answer