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
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!