What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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.
Turn form off based on # of responses?Asked by moberempt on November 30, 2015 at 04:26 PM
I understand that conditions can be used for calculations and passed to other field(s) on a form, but is there a way to have an "external" calculation? E.g., 20 people submit a form, when I get 10 "Yes" responses I can turn the form off and display a "Full" message or similar?
You may want to check the Submission Limit feature of the form.
user guide: -How-to-Limit-Submissions-in-a-Form
You can set 10 as the Submission Limit so the form can only be submitted 10x.
Hope this help. Let us know if you need further assistance.
Hi, thanks for your response. I did see that option, but I don't think it will work in my scenario. I don't want to limit the total number of submissions, only turn off future submissions after # of submissions of a certain type. E.g., if they have two options (yes and no), I want to limit based on 10 yes responses, even if I had 15 submissions (5 of them No and 10 Yes). On the 10th yes (even if it was the 15th submission), the form would not allow future Yes submissions (or just turn off completely and display a message such as "Full" or "No More Submissions Allowed)
My form is a bit different, it is a check-in form with "In" and "Out" but the concept is the same as Yes/No.
JotForm Support Manager
I think limiting the maximum number of selections could help in your scenario, like on this example:
This is another demo form https://form.jotform.com/53274797698983
And here is the general guide :
I will take a look at that, thanks. Right now I'm using a radio button, but I can switch that to two checkbox fields if it is the only way for it to work the way i would like it to.
Unfortunately it would not be possible to do what you are after directly because if I understood you correctly you want to:
- accept up to 10 Ins
- accepts up to 10 Outs
When looking at the submissions, this is easy, just limiting the number of submission to 20 would be all that we need, or if you need to accept only one In and one Out, but the tricky part is those 10 of the same kind.
This would require that the form on its load is aware of how many of each are selected.
It is however possible by using a bit different setup:
1. Limiting your submissions to 20
3. Adding In and Out both with limits to 10 and setting the widget to accept only 1 selection at a time.
4. Marking the widget as required
that is it :)
Now if you want to hide the counter, you can do that with ease by adding this CSS into the widgets Custom CSS code field:
Also, check out a quick demo here: https://form.jotform.com/53345895803969
Do let us know if that is what you were after and if you have any additional questions and we would be happy to assist you with the same.
Thanks for the additional info, I will work on it with your suggestions.
Just to clarify, the scenario I asked about was just an example. My actual scenario is I have a group/pool of about 30 basketball players, and every Monday they "check-in" whether they are going to play that night or not. My form asks for "In" or "Out" (basically yes or no) - I don't care how many Outs (no's) I get, but I only want 12 "Ins" (yes's) then the game is full, so I don't want to accept any more entries at all, basically turn the form off and/or display a message that says "Game Full".
To summarize, I want to close entries once I reach 12 "In" (yes) - I don't care how many total submissions, how many No's, only that I can stop the form at 12 Yes responses.
Again thanks for all of your help thus far - I am going to explore the suggestions you have provided and see what I can do!
I am attempting to test your suggestion above of using the Ticket Purchase widget, however it does not seem to be operating properly on my form. If you view the form you will see where I added the widget, entered the API key, set the ticket types, along with the available numbers in brackets - yet the options don't show up on the form, only the field label itself.
If you can provide more assistance I would appreciate it.
I think it is working now. I made 2 test submissions using your jotform http://www.jotform.us/form/53285812710150 and I see the remaining Spots had decreased by 2 already for "In".
Please test/check again also on your end. Let us know if still not working.
Yes it is working, but in Internet Explorer and Firefox. It is not displaying in Chrome which is my default browser, I guess that is why I didn't see it?
This is very strange. I have multiple problems with this form, as you can see from several other posts I've made (a couple of which were "elevated to L2" but I haven't received a response yet).
This ticket purchase widget doesn't display properly in Chrome, but works in IE and Firefox. Another field that I have (Subs) does not work properly with the conditional logic when viewed in IE, but it works in Chrome and Firefox. And the report page that I direct to after clicking submit doesn't work properly in IE, but works in Chrome and Firefox (for whatever reason, the bar graph on the top doesn't show in IE).
Will I somehow get to the point where all of this stuff works in all three browsers? If I can't be sure that it works properly for all users, then I can't use it at all. Sorry to be a pain but this is frustrating. If I could just tell my users "don't use IE" that would be OK - but I can't even do that because some stuff doesn't work in the other browsers either.
Thanks for your help so far...
I checked your form and did a test submission and I was able to see what you are reporting. After I submitted the form, the counter in the ticket purchase widget still displays 12 instead of 11 or lesser. I have tested it on Chrome and Firefox.
Can you try to do the following to refresh the setup of your ticket purchase widget?
1. Open widget Wizard.
2. Click Finish without changing anything.
3. Save the Form.
I have refreshed the setup of the ticket purchase in your form and it seems to be working now. I have tested it in Chrome, Firefox, Microsoft Edge and Internet Explorer 11.
Do let us know if you still encounter the issue on your Ticket Purchase Widget.
The ticket purchase widget is once again not working in Chrome. I just tried it tonight and it does not show up. I don't understand why this keeps happening? It was working fine when I received your most recent response (above) - nothing has changed, yet now it does not work again. Can this be fixed permanently?
Based on your last reply, I think the widget is now working for you. But if the issue persists to your end, I would suggest creating a new thread for that. Please do the following to determine if there's an error that is causing the problem:
1. While viewing the form, press F12 in your keyboard to open the developers tool.
2. In the developers tool, find and click the "Console" tab
3. From there, you'll see some logs. Errors are colored red. Please take a screenshot and include it in the new thread. Here's how to upload a screenshot to this support forum: http://www.jotform.com/answers/277033.
As for the text color in the widget, I will address it in this new thread: http://www.jotform.com/answers/718838.
Please let us know if you require any further assistance with the original question in this thread.