How to Set an Auto-Close Date or Response Limit on Google Forms

Imagine you are hosting a workshop with 50 seats, running an early-bird ticket sale, or accepting job applications until Friday at 5:00 PM.

You launch your registration form on Google Forms.

You check your dashboard on Saturday morning, and to your horror, 185 people have registered. You only have venue space for 50. Now you are forced to spend your weekend sending 135 awkward apology emails, issuing refunds, and explaining that the form didn't close automatically.

In Google Forms, there is no native setting to schedule an expiration date or automatically close a form when a response limit is reached.

The only default option is manually logging in and toggling the switch:

"Accepting responses" -> OFF

If you are away from your laptop, in a different time zone, or asleep when your form hits capacity, you are out of luck.

Here is how to solve the auto-close problem using Google Apps Script—and how modern platforms handle capacity natively.

---

The Google Apps Script Workaround (And Its Limitations)

To make Google Forms auto-close, you must write custom JavaScript inside the Google Apps Script editor.

Example: Auto-Closing After 50 Responses

function checkResponseLimit() {
  var form = FormApp.getActiveForm();
  var maxResponses = 50;
  
  if (form.getResponses().length >= maxResponses) {
    form.setAcceptingResponses(false);
    form.setCustomClosedFormMessage("Sorry, this event has reached full capacity!");
  }
}

Why Apps Script Workarounds Are Unreliable:

1. Trigger Delays: Google Apps Script triggers run on an installable event trigger (onFormSubmit). During high-concurrency traffic bursts, multiple submissions can slip through before the script finishes executing.
2. Maintenance Overhead: If you duplicate the form for your next event, the custom script does not copy over automatically; you must re-install the script and re-authorize Google cloud permissions.
3. Execution Quotas: Google Workspace free accounts enforce strict daily script execution time limits.

---

How Modern Platforms Handle Form Scheduling & Capacity

Modern platforms like InfiForm make scheduling and capacity management a native, one-click setting.

[ Form Availability Settings ]
- Status: [ Active / Scheduled / Closed ]
- Auto-Close Condition:
  [✓] Maximum Responses Cap: [ 50 ] submissions
  [✓] Scheduled Expiration Date: [ 2026-10-31 ] at [ 17:00 UTC ]
- Custom Closed Message:
  "Registration for this workshop is now closed. Join our waitlist below."

Architectural Advantages:

1. Atomic Transaction Limits: The capacity check happens at the database write transaction level. When response 50 is committed, the form instantly locks at the edge. Response 51 cannot slip through, even during a high-speed traffic spike.
2. Timezone-Aware Scheduling: Set exact start and end dates with automatic timezone handling, ensuring forms open and close precisely on time.
3. Waitlist Routing: When a form closes due to capacity, modern builders can automatically redirect visitors to a secondary waitlist form or display a customized message with alternative links.

---

Comparison: Google Apps Script vs. InfiForm Native Capacity

Feature	Google Apps Script Hack	InfiForm Native Engine
Setup Complexity	High (Writing & authorizing code)	Zero (Toggle switch in UI)
Concurrency Protection	Weak (Race conditions allow over-capacity)	Atomic (Guaranteed exact cap)
Auto-Close by Exact Date & Time	Requires time-driven triggers	Built-in scheduler
Custom Closed Screen	Plain text only	Rich Markdown / Custom CTA
Automatic Waitlist Switch	❌ No	✅ Yes

---

4 Common Scenarios Requiring Form Auto-Close

1. Limited-Seat Workshops & Webinars: Prevent overbooking for Zoom rooms, physical event venues, and catering counts.
2. Early-Bird Discount Applications: Automatically expire promotional pricing forms at midnight on the launch date.
3. Job Posting Application Windows: Close hiring intakes at the formal deadline without HR managers staying up until midnight.
4. Grant & Scholarship Submissions: Enforce strict regulatory submission deadlines with immutable closing timestamps.

Never risk embarrassing overbooking or missed deadlines again. Use a modern form platform with native capacity management and automate your form lifecycle from day one.