I would like to know if Seatable has an option to limit form entries. I would like to disallow entries after X number of submissions, to avoid oversubscribing for an event.
Is this possible? Perhaps once the form is closed it could display “this event is fully subscribed”?
You can limit the submissions of a form by a adding a link column field with the function “Limit row selection to a view”.
How would you do it?
Create an additional table “spots” (or whatever).
Add a column of type “link to other records” in this table
Addd as many records in the linked view as you have available spots
Set the filter such that the view only shows records that are not linked to another record
Go to your table with the registrations and configure the link column to only permit links to this view
Open your form and add this fields to your form and make it required
→ If someone submits a form, a link is created in the table “spots”. Because of the filter setttings for the view, this record is now excluded. In the form, one spot less is available.
Thanks. I’ve learned this solution before but it is not quite the same as what I’m asking.
The suggested solution is relevant when you want to make a particular option limited, and remove it once it reaches capacity.
I am interested in closing the actual webform entirely, once a given number of submissions are made.
Use case:
For a workshop, a venue may have a hard limit of people allowed, so I do not want anyone to still enter into the form only to realise they cannot submit because there are no valid options left. I also don’t want to have to keep looking at how many registrations have come in before removing the form link.
Why don’t you set up an automation that sends you an email (or notifies you in some other way) once the number of registrations reaches the maximum limit?
Question: let’s say the user opens the link after you have removed it because you have reached capacity. They will get an error. What will you put in place to get around this?