JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Limits submissions based on sum of a field in the formAsked by athdept on April 21, 2016 at 04:32 PM
Is it possible to limit the number of submissions based on the sum of a field in a form? Let's say a field's total/sum reaches 400. I want to be able to not allow any more entries. Is that possible?
The Form Limits Submission Limits work differently as it counts only per submission of the form...
But I think what you can use is the Inventory Widget https://widgets.jotform.com/widget/inventory
The Inventory widget have a number(starting count) that diminished until all used up.
So for example, if you set the inventory to 400, you can trap the submission of the form once all quantity were used.
Hope this help. Let us know how we can be of further assistance.
If I use the inventory widget how can I disable the form at 400?
Let me see if I can get some code for you to prevent the submissions. However, I'm not sure if it works for you, but another alternative can be hiding the Submit the button when there is no quantity is selected in inventory widget. Please see the screenshot below:
When the inventory widget is selected with a quantity, the Submit button will be displayed. When the quantity in the widget is completed, the Submit button will not be displayed.
Hope this information helps!