Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Set maximum number of rows

Topic Labels: Formulas
1904 1
Showing results for 
Search instead for 
Did you mean: 

i linked my app with Airtable but i want something which i cant find in that

can we set a limit on the numbers of the row ?

like in my app i just want to add 100 rows per table

is it possible ? if yes than please tell me how to do this

1 Reply 1

You can’t limit the number of rows… mostly.

What you could do is add a ‘Control’ table. This is just a table with a single record that is linked to all other records. This will allow you to count the number of records.

Screen Shot 2019-04-13 at 3.59.13 PM.png

Add a filter view:

Screen Shot 2019-04-13 at 4.00.03 PM.png

And then make a form with the control as a ‘required field’:

Screen Shot 2019-04-13 at 4.11.11 PM.png

If you’re after the 100th customer you won’t be able to submit the form:

This is hacking quite a few Airtable features so it might not be what you were hoping for. Feel free to copy out the base. And let me know if you have any questions.