Limit number of submissions for each choice.

  • Profile Image
    Asked on May 01, 2013 at 02:07 PM

    I don't have a form designed yet, this is more of a hypothetical question while trying to design one.

    Lets say I have 4 different types of items in a drop down. I only have two of each item. Is there any way to make it so that after 2 submissions for one item, that choice is no longer available?

    In other words, can I use the unique submission in conjunction with the form submission limit to avoid too many people choosing one item?

  • Profile Image
    Answered on May 01, 2013 at 02:36 PM

    Thanks for the response. I knew about the submission limit, I was just curious if it could be used with any other qualifiers.

    Thanks though!

  • Profile Image
    Answered on May 01, 2013 at 05:51 PM

    Hi holmster, Unfortunately that is not possible by only using JotForm, But you can achive this by some workarounds.

    1. Integrate your form with google spreadsheet, then publish your spreadsheet, once you have published your google spreadsheet, You can use that spreadsheet as a Data Source using Javascript API's.

    Go to: To learn about how to publish a google spreadsheet.


    Go To: to learn how to access spreadsheet data using javascript API


    2. Then using javascript, check the number of submissions for all items using a loop, depends on the result (items submitted count), you can add Items to the Combo Box.

    3. Now, you create a form with all these scripts and tags then upload it to form builder. 


    If you need further help regarding how to do scripting part feel free to ask me by reply to this post.


  • Profile Image
    Answered on May 01, 2013 at 08:00 PM

    I use the unique submission in conjunction with the submission limit to avoid too many people choosing one item?

    Yes, you can, but you will not be able to accomplish what you are looking for, as Unique questions will not work with dropdown menus

    As explained to you by Dineshit the escenario you are looking for is something that could be accomplish using the source code of the form and getting dirty with some programming

    Our you might want to try to apply submissions limit based on unique questions (such as email, phone, etc) in combination with submission limit based on numbers or dates

  • Profile Image
    Answered on May 02, 2013 at 12:26 PM

    Thanks to both of you for your suggestions.

    I know you can embed a form report into the form so it can be seen while filling the form out. Is there a way to make this a hidden field and put a conditional formatting once the report field shows a certain number of an item submitted on the form?

    Also, the items don't have to be in a drop down as listed in the scenario I gave. It could be radio buttons or even check boxes.