Form Calculation Results Not Clearing When Inventory Widget Quantity is Removed

  • FPAUSA
    Asked on May 20, 2025 at 1:37 AM

    It seems like there's a really annoying bug with the Form Calculation Widget used with the Inventory Widget.

    I've created a GIF to show the issue: https://litter.catbox.moe/rqvv8z.gif

  • FPAUSA
    Replied on May 20, 2025 at 1:38 AM

    Form Calculation Results Not Clearing When Inventory Widget Quantity is Removed Image 1 Screenshot 20

    I'm realizing the GIF might expire, so hopefully this doesn't. I hope it's self-explanatory with the title, and there can be a solution.

    This is the test form: https://www.jotform.com/build/251391031624044?iak=7dd62f0ed7f418aff37fe350c2f26af1-6ae3ca9857fc838f

  • Eliza JotForm Support
    Replied on May 20, 2025 at 4:51 AM

    Hi FPAUSA,

    Thanks for reaching out to Jotform Support. I understand the issue, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

    Thanks for your patience, we appreciate it.

  • Eliza JotForm Support
    Replied on May 20, 2025 at 5:09 AM

    Hi FPAUSA,

    When I cloned and tested your form, the same thing happened for me, so I created a ticket about it and escalated this to our Developers. As soon as we have an update from them, we’ll let you know on this thread. In the meantime, I have a workaround for you. You can change the Quantity Input Type from Dropdown to Number Input, and change the Clear Hidden Field Values settings on your form.

    As for the input limits per submission, we can use Paragraph elements to show an error when the form filler enters a quantity that is greater than what's allowed. Then, use Conditions to hide the Submit button, unless they enter the allowed quantity. Let me walk you through it:

    1. In Form Builder, click on the Inventory widget, and select the Wand icon to open the Widget Settings panel.

    2. Under the General tab, change the Quantity Input Type from Dropdown to Number Input.

    3. Click on Update at the bottom.

    4. Do the same for the rest of the Inventory widgets.

    Form Calculation Results Not Clearing When Inventory Widget Quantity is Removed Image 1 Screenshot 70

    5. Click on Settings in the orange navigation bar at the top part of the page.

    6. Under Form Settings, click on Show More Options, and scroll down to see the Clear Hidden Field Values dropdown.

    7. Select Clear when hidden from the Clear Hidden Field Values dropdown.

    Form Calculation Results Not Clearing When Inventory Widget Quantity is Removed Image 2 Screenshot 81

    8. Click on Add Element in the upper-left corner of the page, and select Paragraph under the Basic tab.

    9. Enter an error message as desired to inform them that they can only enter a maximum of what number.

    10. Modify the text font, color and so on, and click on the Check icon on the right side of the element to save it.

    11. Add Paragraph elements to the form for the rest of the Inventory widgets.

    Form Calculation Results Not Clearing When Inventory Widget Quantity is Removed Image 3 Screenshot 92

    Once done, we can now set up conditions to show the Paragraph elements when they enter a number that's over the limit entry, and hide the Submit button as well. Let's do it:

    1. Go to Settings again, and select Conditions from the menu on the left.

    2. Select Show/Hide Field from the options.

    Form Calculation Results Not Clearing When Inventory Widget Quantity is Removed Image 4 Screenshot 103

    3. Set the conditions as shown in the screenshot below, and click on Save at the bottom.

    Form Calculation Results Not Clearing When Inventory Widget Quantity is Removed Image 5 Screenshot 114

    4. Set additional conditions for the rest of the Inventory widgets.

    Form Calculation Results Not Clearing When Inventory Widget Quantity is Removed Image 6 Screenshot 125

    You can also test and clone my Demo Form if you like.

    Let us know if you have any other questions.

  • FPAUSA
    Replied on May 20, 2025 at 8:13 PM

    Hi Eliza,

    Thank you for responding. I'm not sure if you understood the actual problem, so let me actually type it out and try to explain it.

    In the test form I made, there are various "rooms" and I can reserve any number or combination of them. These are all inventory widgets. The last box (which is a form calculation widget) is supposed to show the current total daily rate of what I've selected for reservation.

    For example:

    I select one room type 1 ($10/night) and one room type 3 ($30/night).

    The last box should show $40.

    But then if I change my mind and unselect the one room type 3, the last box still shows $40. Further, if I select room type 2 ($20/night), the last box now shows $60.

    However, it seems this bug does not exist when I switched to using "Number Input" for inventory widgets instead of "Dropdown", so I will just have to do that.

    - Yoshi

  • Frédéric JotForm Support
    Replied on May 21, 2025 at 4:04 AM

    Hi Yoshi,

    I confirm that my colleague properly escalated your issue, which was clear enough. A workaround would be to use the Product List, which might fit your needs, and if you don't need to proceed to a payment, as in your actual form, you can use it to create an invoice from order forms.

    Thanks for your patience and understanding while we're working on the widget update.

Your Reply