Help

Limit record entries in a table

3191 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Kimon_Bear
4 - Data Explorer
4 - Data Explorer

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

3 Replies 3
Utility_Locator
6 - Interface Innovator
6 - Interface Innovator

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.

Deborah_Buck
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

HannesK-ME
7 - App Architect
7 - App Architect

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!

Screenshot 2024-11-28 at 15.53.37.jpg