Limit Response Capacity in Google Forms

Every year about this time, I go through the process of setting up Professional Development Workshops for teachers in our district. As it stands, we have a faculty large enough that we need to offer several workshop opportunities, but with limited space in each session since they are held in classrooms. As a result, to avoid overbooking a workshop, I’ve always needed the ability to limit responses in a Google Forms question once the number of respondents for a session have reached capacity.

For this reason, I use a little ingenuity and formula hacking in Google Sheets, along with Form Ranger. By using Form Ranger, I can set limits on questions like the one you see below:

For the question below, choose a workshop to attend for Session 1:

  • Google Forms
  • Google Slides
  • Google Calendar
  • Gmail

In the example above, I can set a limit of 30 attendees in my Google Response sheet, and once 30 teachers have registered for Google Forms, then it will no longer appear as an option for future registrants. Thus this will ensure that the workshop is not overbooked, creating a standing room only issue for the workshop presenter.

To see how this works, take a look at the video below. You don’t have to be a Google Forms or Google Sheets guru to make this happen. Just give it a try!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s