Limit Responses in Google Forms Using Google Apps Script

Welcome !

In this blog I am going to show you how to limit responses in Google Forms using Google Apps Script. We are going to use the following fictitious example:

  • We are having a Cloud computing workshop.
  • But the hall that we have booked has a max capacity of 100 people.
  • People can register for the workshop through a Google Form.
  • The organising Team wants to make sure that there are only 100 responses in the Google Form.

So let’s get started.

If you need to refresh your knowledge on using Google Forms, click on the link given below.

Step1: Sample Google Form

The form that I will be using is a Simple Registration form.(If you prefer working with click here)

The form contains the following details:

  • Name of the Attendee
  • Email Address of the Attendee
  • Phone number of the Attendee
This is the Google Form that the Attendee will fill

Step2: Write the Automation Script

While you are in the Form , launch the Apps Script Editor.

To do that:

(1) Click on 3 dots next to the Send button on the top right.

(2) Next click on on the Script Editor option.

This brings up the Script Editor as shown below:

We have reached the Script Editor. Let’s Code.

function Limit_Responses() {
max_responses = 5;
var form = FormApp.openById("17XDAjSnwB8gU0CIpiDLRv3Q7-Ozfro- n0pRDQOAEjuI");
var responses = form.getResponses();

Here we are first declaring the maximum number of responses that you want in your Google Form. Next we are going to get the form by ID. Then we are going to get the responses that are in the Google Form.

len = responses.length;//Logger.log(len);if (len == max_responses){
form.setAcceptingResponses(false);
}
}

Here we get the length of the responses present in the Google Form.

Step3: Add a Trigger

In order to count the responses, we have to add a trigger, so that as soon a new response comes into the form, the count of the responses will get incremented by 1.

To add the trigger follow these steps:

(1) Click on the Triggers button .

(2) To add the trigger click on Add Trigger.

(3) Make the following changes in the trigger that you have made.

Here you have to select the Limit_Responses function. For the event type you have to select On form Submit.

After making the changes click on Save.

Now as soon as the number of responses in the Google Form matches the max responses, the Google Form will get locked and no longer accept responses. It will look like this.

Here you can see that the form has shown a message that says that the form is no longer accepting responses. If you want custom messages for the form you can go back to the form and make the changes.

Here you can add you custom messages

This is all for this blog. I hope you have understood how to Limit Responses in Google Forms Using Google Apps Script. You can send your feedback on aryanirani123@gmail.com.

Currently pursuing B Tech at MPSTME. Technical Blogger, interested in Google Workspace. Hope to remain a life long student. Created a course on Google Classroom

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store