Nov 12, 2019 06:55 AM
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
Solved! Go to Solution.
Nov 12, 2019 09:52 AM
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.
Nov 12, 2019 07:52 AM
I think the practical ceiling is like 50,000 rows in a table.
Nov 12, 2019 07:56 AM
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!
Nov 12, 2019 09:52 AM
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.
Nov 12, 2019 10:05 AM
Really great advice, Bill. Thank you so much for taking the time to respond in such detail. I appreciate the ideas!