Nov 12, 2018 01:31 PM
Hi all,
first of all, I’m a non-native English speaker, please keep that in mind, in case my question isn’t understandable :slightly_smiling_face: I’m quite struggling to explain it in german, my native language.
I’m new to airtable and trying to set up a registration form with limited record entries. The form should not accept any input after, let’s say 30 entries, since the registration is limited. Is there any way I can limit the records in a table?
I found some posts about different field types like formula, rollup and count, but they all refer to linked records and that’s what I don’t understand. Do I need a second table for this? And if yes, how do I accomplish this? Is it possible to limit records in general?
I’m grateful for any hint.
kimon
Dec 31, 2018 10:06 AM
Create a column using the Auto ID field type and name it “entrynumber”. This will automatically number your rows starting off at #1 and will incrementally count up from there.
Now, create a new field with a formula. The formula will check the entry number to see if it is within the 1-30 limit. The formula should look like this:
IF(entrynumber<30,“Valid”,“Invalid”)
If the entry is within 1-30, the field will say “Valid”, other wise if the entry number is over 30 it will say “Invalid.” Once you have that working, you can create a filter that will only display entries that are “Valid”
Hope that helps, let me know if you hit any snags.
Apr 06, 2021 11:14 AM
I too was searching for a similar solution and found this - https://community.airtable.com/t/limit-the-number-of-workshop-registrations/35485/2 - which is a great way to limit registration. I wanted to share it with this thread too since this thread also helped.
Nov 28, 2024 02:57 PM
Hey there,
Our miniExtensions form can do this without the need for a second table! We have a feature to only allow submission of a record under certain conditions. That feature, in combination with the formula field @Utility_Locator mentioned above can achieve exactly what you need! To make this work for new records you would need to turn on our form's Save & Continue feature as well, since formula fields are only defined once a record is created in Airtable. Save & Continue creates a temporary record in Airtable and therefore enables the use of formula fields on forms to create new records! Once the user actually submits the record, a checkbox can be checked to indicate that the submission has been completed. This way, temporary and submitted records can be distinguished easily!