Set maximum number of rows

Topic Labels: Formulas
2273 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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
7 - App Architect
7 - App Architect

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.