Add-ons‎ > ‎

formLimiter

"Shut off Google Forms automatically based on a condition!"

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.
INSTALLATION

Install on any Google Form from the Google Forms Add-ons store.


BASIC USE
Easy as pie.  Just launch and set the limit type:
  • Maximum number of responses - Form evaluates on each new submission and shuts off once a limit has been reached.
  • Specific date and time - Timer will shut off form on that date, down to the minute.
  • Spreadsheet cell value equals - specify a spreadsheet cell (e.g. "Sheet1!A2" in the form destination sheet that must equal a particular value, and the form will evaluate on each new form submission.

STUDENT DATA PRIVACY
Have questions about how formLimiter handles student data? Check out this terms of use document.


DEVELOPERS

  • Find the code for the formLimiter Add-on on GitHub (coming soon)

USAGE PATTERNS (launched Fall 2014)

Join the Google Apps Script / Add-ons for EDU users' community

If you have any questions about using formLimiter, please post it to the Google Apps Script for EDU users' community.


VIDEO TUTORIALS

Thank you Brian Gray for contributing this excellent walk through of the formLimiter Add-on for Forms.





ABOUT THE AUTHOR / MAINTAINER

  Andrew Stillman worked in outdoor education in the Pacific Northwest prior to a ten year stint in the New York City Department of Education, where he worked as a science and math teacher, and later as founding assistant principal and engineering educator for the Columbia Secondary School for Math, Science and Engineering in Harlem, NYC.  Andrew joined New Visions for Public Schools in 2011, where he has focused his energies on innovating strategies and tools to bring better ways of working to everyone from the classroom teacher to the back office administrator.  When Andrew is not coding, he loves working on "maker" projects with his two young kids, cooking spicy food, or riding his bike.