Can a numeric limit be placed on field options?

  • Profile Image
    Asked on September 21, 2013 at 04:59 PM

    I'm currently using Google Drive (form and spreadsheet) for a class registration form. My employer conducts these classes 6 months out of the year, one each month. There is a limit of 12 students for each class. On my Google form, I have fields for First Preference and Second Preference that contain the month and dates of all the classes that have not been conducted yet for the year. Since we don't take payment for the class online (a whole other issue that it looks like you can solve for us), I call them within 72 hours to verify which class is available out of their 2 preferences and to process their credit card payment for the class.

    The ideal solution would be to have one field with the months and dates of the classes and once 12 people have registered for a specific class; that option is not available to be chosen. I did search your forum a bit and it looked like this option was not available as of about August 2013, but a request had been submitted to developers.

    I have replicated the Google form we use in your solution and I definitely like the look, feel and intuitiveness of your product.

    This feature along with the payment options that you support would make it no brainer for us to use your solution rather than Google Drive.


  • Profile Image
    Answered on September 21, 2013 at 07:36 PM

    Hello dpolaski,

    To limit the amount of submissions that can be made on your form kindly try out the steps below:

    Click on Preferences icon on the Setup & Embed category

    On the Preferences window, go to the Form Limits tab and add your preferred amount of allowed submissions on the Submission Limit category.


    Do let us know if you need additional assistance. Thank you.

  • Profile Image
    Answered on September 21, 2013 at 08:28 PM
    Thanks for the response, but your answer is not for the question that I'm asking. Let me give an example:
    Choose class dates:
    May 5-7 (option 1)
    June 9-11 (option 2)
    July 20-23 (option 3)
    If I have 12 available spots in each class, once 12 people submit a registration for a given class, let's say for May 5-7, can that option be made unavailable.
    I'm not looking to limit the number of submissions; I'm looking to limit the number of times an option for a specific question can be chosen.  I think the answer at this point is no, but I thought there may be some creative ways to address what I'm looking to do. 
  • Profile Image
    Answered on September 21, 2013 at 08:54 PM

    Unfortunately no, there is no way to limit available slots depending on a field. What I would suggest is to create your base form and clone the form to have a copy per class. This way you could use the submission limit option on each form. And post the links of your forms to your site:


    Registration May 5-7 <-- Link to form Here
    Registration June 9-11 <-- Link to the second form Here
    Registration July 20-23  <-- Link to the third form Here

    Hope this helps. If you need additional assistance to let us know. Thank you.

  • Profile Image
    Answered on September 24, 2013 at 01:02 PM

    I think that might work!  Thanks.  I hadn't thought about tackling it that way.