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.


  • Profile Image

    Limit number of submissions for each choice.

    Asked by holmster 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 submission limit to avoid too many people choosing one item?

    Submissions submission limit unique different
  • Profile Image

    Answered by jefreylandicho on May 01, 2013 at 02:20 PM

    Unfortunately that is not possible as it looks to me that it would require an inventory to achieve the result you need. You can however limit the submission you can receive for a form. For example, you can set  a form to only accept 50 submission, once the submission reach the 50 submission limit, the form will automatically get disabled or disallow submission. 

    To set the limitation of a form, go to Setup & Embed, click the Preferences Icon and select Form Limits tab.

    If you need further assistance, please contact us again.

  • Profile Image

    Answered by holmster 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 by dineshit 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: https://support.google.com/drive/bin/answer.py?hl=en&answer=37579 To learn about how to publish a google spreadsheet.

     

    Go To: https://github.com/mikeymckay/google-spreadsheet-javascript 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 by jeanettebmz 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 by holmster 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.

  • Profile Image

    Answered by jefreylandicho on May 02, 2013 at 02:17 PM

    No, I think that is not possible. You cannot set a condition that is based on a report field value. Also, changing the product fiield type will still not accomplished what you are trying to do. You can however try integrating Jotform with eCommerce to control the product and submission you received.