Turn form off based on # of responses?

  • moberempt
    Asked on November 30, 2015 at 4: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?

     

  • jonathan
    Replied on November 30, 2015 at 5:30 PM

    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.

    Turn form off based on # of responses? Image 1 Screenshot 20

     

    Hope this help. Let us know if you need further assistance.

  • moberempt
    Replied on November 30, 2015 at 5:50 PM

    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.

     

  • Jeanette JotForm Support
    Replied on November 30, 2015 at 11:03 PM

    I think limiting the maximum number of selections could help in your scenario, like on this example:

    Turn form off based on # of responses? Image 1 Screenshot 20

     

    This is another demo form https://form.jotform.com/53274797698983

    And here is the general guide :

    https://www.jotform.com/help/251-How-to-set-up-minimum-or-maximum-number-of-selection-on-Checkbox-Field

  • moberempt
    Replied on December 1, 2015 at 2:09 PM

    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.

  • Ben
    Replied on December 1, 2015 at 4:24 PM

    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

    2. Adding Ticket Purchases widget to your form (See here how)

    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:

    span.items-left {
        display: none;
    }

    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.

  • moberempt
    Replied on December 1, 2015 at 6:29 PM

    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!

  • moberempt
    Replied on December 2, 2015 at 8:57 PM

    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.

    My form

  • jonathan
    Replied on December 2, 2015 at 10:08 PM

    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".

    Turn form off based on # of responses? Image 1 Screenshot 20

    Please test/check again also on your end. Let us know if still not working.

    Thanks.

     

  • moberempt
    Replied on December 3, 2015 at 12:33 AM

    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...

     

  • Chriistian Jotform Support
    Replied on December 3, 2015 at 4:52 AM

    Hi,

     

    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.

    Turn form off based on # of responses? Image 1 Screenshot 40

     

    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.

    Turn form off based on # of responses? Image 2 Screenshot 51

     

    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.

    Turn form off based on # of responses? Image 3 Screenshot 62

     

    Do let us know if you still encounter the issue on your Ticket Purchase Widget.
    Regards.

  • moberempt
    Replied on December 5, 2015 at 10:00 PM

    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?

     

  • moberempt
    Replied on December 5, 2015 at 10:02 PM

    In the ticket purchase widget, how can I change the text color of the labels that are In and Out (currently they are a gray color, and they don't show up very well with the background I am using and the transparency of the field).
  • Welvin Support Team Lead
    Replied on December 6, 2015 at 4:06 AM

    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.