-
association_parentsAsked 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!
Page URL: https://form.jotform.com/241056075500143 -
Mafe_M JotForm SupportReplied 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:
- At the top of the Form Builder page, click on the Timestamp under the title of the Form to open the Revision History.
- Choose the version you want to restore the form to in the menu on the right side of the page.
- Now, just click on Revert next to the version you want to revert it to. That’s it.
Give it a try and let us know if you need any help.
-
association_parentsReplied 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 SupportReplied 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.
- 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.
- Now set up the formula like the ones below and click Save once done.
Here is the result:
Give it a try and let us know how it goes.
-
association_parentsReplied 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!