Once you have collected enough responses for your Google Form or have met your initial targets, it’s time to close it. This will prevent others from submitting new responses.
You can close your form manually at any time you wish. Alternatively, you can schedule a time or target for the form to close automatically. This guide shows you the different ways you can close your Google Form.
Close a Google Form Manually
You can manually stop accepting responses by closing your form.
- In your Google Form, go to the Responses tab at the top of the page.
- You will see the Accepting responses toggle. Turn the toggle to “off” to stop accepting responses for your form.
- By toggling the button off, you will be notified that your form is “Not accepting responses”.
- If new respondents open your form after turning new responses off, they will be greeted with a default message informing them that the form is now closed. You can customize the default message to what you prefer.
If you want to re-open your form to new submissions, you can turn on the toggle on again.
Close a Google Form Automatically
To close a form automatically, you must install an add-on from the Google Workspace Marketplace.
Installing formLimiter
- Open your form in Google Forms, and click on the three-dot menu in the top-right corner. Select Add-ons.
Google Workspace Marketplace will open in a new window.
- In the marketplace, you will see an add-on called formLimiter. If you can’t find it, use the search bar at the top. Click on Install to add formLimiter to Google Forms.
- It will ask you to choose a Google account to continue the installation. Select the account you used to create the form.
- When you return to your Google Form, you will see an Add-on icon at the top of the page. Clicking it will show formLimiter.
- Select formLimiter and then Set limit from the options.
Setting a “limit” allows you to choose when the Google Form stops accepting new responses.
Date and Time
Scheduling a date and time can help you to manage incoming responses. To close the form through this limit type, select the date and time by clicking on the displayed tab. Also, you can enter the default message for the respondents. Click on Save and enable it to set the limit.
Number of Responses
You can set the maximum number of responses you wish to receive on your form. Once the number of responses reaches the specified limit, formLimiter will close the form and display a custom “form closed” message to the respondents.
Spreadsheet Cell Value
In this last option, you can specify the value of an Excel sheet cell to limit your form responses. The requirement to use this option is to connect your destination sheet with your form.
- Go to the Responses tab, and click on the three-dot menu.
- Choose the option Select response destination.
- You may choose to create a new spreadsheet or use an existing one. Click Create when you select the destination.
- Once the destination is selected, go back to formLimiter. Under “Limit Type”, make sure you have spreadsheet cell value chosen. Specify a cell number, for example, “B11,” from the destination spreadsheet. Then, enter any value you wish to fill until the specified cell number. As soon as this value is inputted, the form will automatically close.
- Finally, select Save and enable.