Certain Rows in Table not Calculating

  • association_parents
    Asked on April 15, 2024 at 3:40 PM

    Hello! Why aren't the last three rows in my table not calculating in the widget? Previously those last 3 rows were calculating the total, and then they stopped. I can't find anything different in their set up than the prior rows. Thanks!

  • Mafe_M JotForm Support
    Replied on April 15, 2024 at 6:50 PM

    Hi Trish,

    Thank you for reaching out to Jotform Support. I checked the revision history of your form and looks like there were changes or updates on the calculation field and input table. You can revert the form back to its previous version where the input table was working correctly. Let me show you how to use it:

    1. At the top of the Form Builder page, click on the Timestamp under the title of the Form to open the Revision History.
    2. Choose the version you want to restore the form to in the menu on the right side of the page.
    3. Now, just click on Revert next to the version you want to revert it to. That’s it.

    Certain Rows in Table not Calculating Image 1 Screenshot 20

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

  • association_parents
    Replied on April 15, 2024 at 7:29 PM

    Hello- I reverted it, however I'm still having the problem that the last 3 books listed in the table are not being calculated by the widget. (Plus, it didn't seem like the last revision on April 9 had anything to do with the problems I am facing.) This issue occured recently. Any attempts to look into, all happened today. On my end, it appears that those 3 rows of info are similarly set up as the initial rows are within the widget. So I'm hoping that you can see something on your end that I am not seeing. Thanks in advance for your help!

  • Mafe_M JotForm Support
    Replied on April 15, 2024 at 8:23 PM

    Hi Trish,

    Thanks for getting back to us. When I cloned and tested your form, the same thing happened for me. After investigating it a bit, I found out that there are missing formulas on the form calculation widget, that is why the last three books are not calculating when they are selected. You will need to update the formula for the total field. Let me show you how:

    • In Form Builder, click the Total Amount Due field and click the wand icon
    • Click Add Field and select Books Available for Purchase.

    Certain Rows in Table not Calculating Image 1 Screenshot 60

    • Scroll down to the bottom of the calculation widget and put a check mark on the first two check boxes, which is Select the Books you'd like to buy and Choose the Quantity of each book.
    • Click Done to apply the changes.

    Certain Rows in Table not Calculating Image 2 Screenshot 71

    • Now set up the formula like the ones below and click Save once done.

    Certain Rows in Table not Calculating Image 3 Screenshot 82

    Certain Rows in Table not Calculating Image 4 Screenshot 93

    Here is the result:

    Certain Rows in Table not Calculating Image 5 Screenshot 104

    Give it a try and let us know how it goes.

  • association_parents
    Replied on April 15, 2024 at 9:32 PM

    Thank you for your recent update. I actually found my problem. Since I was using my keyboard to input *, (, ), etc., it didn't calculate properly. Once I went back in and clicked on each of the functions, the function turned darker and ironically, the widget then worked. So maybe it was a fluke, or there's something about using keystrokes vs selecting the functions within the widget, either way, thank you so much for your time!

 
Your Answer