Help

Re: Forms - max number of records in a base

Solved
Jump to Solution
1344 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Emily_Lokenberg
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, we’re using a form to capture survey responses and my question is: how many responses, or records, can a base hold? 5k? 10k? Any idea?
Thank you

1 Solution

Accepted Solutions

Yep, probably fine. There are some nuances that go along with Airtable’s practical ceiling including the density of the data, attachments, attachment sizes, etc. But it’s unlikely you’ll have any issues concerning scale. And you can always craft a suitable archive strategy if you suffer from a good turnout which is a good problem to have.

In the world of analytics, multiple responses are generally welcomed if for no other reason than to serve as yet an additional data point that says something about those respondents. However, for computational integrity, consider using a roll-up, or a grouping or even filtered views to sanitize the data as you like. Instead of attempting to limit activity, use your energy to shape the analytics despite the respondents who feel the need to post multiple entries.

See Solution in Thread

4 Replies 4

I think the practical ceiling is like 50,000 rows in a table.

Thanks, Bill! I think we’ll be ok then. We have 67k employees, but only a fraction will respond. Now to figure out how to limit the survey to only one response per person!

Yep, probably fine. There are some nuances that go along with Airtable’s practical ceiling including the density of the data, attachments, attachment sizes, etc. But it’s unlikely you’ll have any issues concerning scale. And you can always craft a suitable archive strategy if you suffer from a good turnout which is a good problem to have.

In the world of analytics, multiple responses are generally welcomed if for no other reason than to serve as yet an additional data point that says something about those respondents. However, for computational integrity, consider using a roll-up, or a grouping or even filtered views to sanitize the data as you like. Instead of attempting to limit activity, use your energy to shape the analytics despite the respondents who feel the need to post multiple entries.

Really great advice, Bill. Thank you so much for taking the time to respond in such detail. I appreciate the ideas!