Google-sheets – Limitation of participants Google Docs

google sheetsgoogle-forms

I would like to create a registration form for a series of lectures participants could sign up for. However, depending on the lecture, there is a different limitation of numbers of participants that can sign up for it.

So far, I found the course registration template, however it does not allow to use it with the "checkboxes" but only with "choose from the list" question type. In the registration form I try to create, they should be able to choose more than one option (therefore use the question type "checkboxes" instead of "choose from a list").

Do you know if there is any possibility in Google Docs to specify a limited number of participants for each lecture?

Best Answer

Short answer

Google Forms doesn't include a limit on the number of responses as built-in feature but you could extend the of Google Docs editors features though add-ons or Google Apps Script.

Alternatives

formLimiter

From: https://sites.google.com/a/newvisions.org/scripts_resources/add-ons/formlimiter

formLimiter automatically sets Google Forms to stop accepting responses after a maximum number of responses, at a specific date and time, or when a spreadsheet cell contains a specified value.

Great for time-bound assignments, event registrations with limited seats, or other first-come, first-served signup scenarios.

References

Extend Google Docs, Sheets, and Forms with Apps Script - Docs editors Help

Related Solutions

Google-sheets – How to create a multiple choice question in Google Forms based on spreadsheet data

You should be able to do it with something like

// Change these three values to match your own spreadsheet
var OPTIONS_SPREADSHEET_ID = "0Avea1NXBTibYdEY4XzBvSk84MjB2RENiOFljSkVaY0E";
var OPTIONS_SHEET_NAME = "Sheet 1";
var OPTIONS_RANGE = "A1:A4"; // We have 4 options, listed in column A

// This returns a 2D array of the values of the range, e.g. [["A1value", "B1Value"], ["A2Value", "B2Value"], ["A3Value", "B3Value"]];
var options2DArr = SpreadsheetApp.openById(OPTIONS_SPREADSHEET_ID).getSheetByName(OPTIONS_SHEET_NAME).getRange(OPTIONS_RANGE).getValues();
var options = [];
for (var i = 0; i < options2DArr.length; i++) { // Now iterate through the 2D array and extract values from the first column only
  options.push(options2DArr[i][0]); // 0 is the index of the first column
}

form.addMultipleChoiceItem()
.setTitle('Do you prefer cats or dogs?')
.setChoiceValues(options) // <-- Uses the spreadsheet values as choice options
.showOtherOption(true);