Is it possible to close or lock a form after a defined number of responses?

[jord8on]

I’m using the from view for people to register for an upcoming round robin event!

I’d like to lock submissions after we hit 12 responses. Is there a way or workaround to make this possible?

If not, no worries. How can I “lock” it manually to prevent additional entries?

[ScottWorld]

That’s not possible.

However, EventBrite.com lets you create forms for events that lock submissions after you hit X number of responses. So you could simply create your forms in EventBrite, and then have your form submissions automatically feed into Airtable using Integromat or Zapier.

To lock your form manually, you could just stop sharing the form altogether — or change the URL to a different URL so people can’t find it. If you still want them to see the form at its old URL, then just remove all the fields from your form so there are no fields to fill out anymore.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

[CristianCG]

Hi there!

At miniExtensions, we've built a third-party form that offers various flexible options to get more out of Airtable. Our form offers several ways to control or disable form submissions. These include allowing users to create only one record, setting a scheduled date to disable submissions, and restricting submissions based on specific conditions.

The ability to restrict submissions when specific conditions are met can be used along an autonumber field and the Save & Continue mode to verify how many submissions have been sent so far and mark new submissions as invalid while informing the user.

To set up the condition, you can create a formula field that reflects the value of the autonumber field. The Save & Continue mode will compute the formula before the user can submit the form and it will show an informative message if the limit has been reached.

Note: each form attempt creates a new record in Airtable, so you’ll have a trace of all invalid attempts. However, only submissions made before reaching the limit will have a verification checkbox marked, which you can use to filter your view.

Here's an example with a form that accepts 2 submissions:

And here's the Airtable setup: