Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 29, 2023 05:27 AM
Hello,
I am new to airtable. I need help with records. I have created 1250 records in my table even though i am on freeplan. I am not sure if i should add more rows records or not?
Solved! Go to Solution.
Aug 29, 2023 09:47 AM
@kuovonne is right… you shouldn’t be pre-creating records like that. I didn’t even notice or realize that that is what you are doing. You may be better served by Google Sheets, which is a free spreadsheet program that has no limit to the number of rows you can create.
Aug 29, 2023 06:12 AM
It looks like they haven't strictly enforced the record limit in the past, but I remember reading somewhere that they are planning on enforcing those limits starting sometime in September 2023. They said that you will still be able to see your old records that have gone over the limit, but that you won't be able to add new records.
Aug 29, 2023 09:45 AM
Historically, the limits have been soft limits, and have not been enforced in real-time. The record count on the workspace page (which is what is used to determine if you have reached your limits or not) is not updated in real-time.
The old record limit on the free plan was 1200 records. It is now 1000 records, but the changeover is not fully implemented.
Why do you want to pre-create so many records? Part of the beauty of Airtable is having linked relationships, which involves having records in multiple tables, and you may not know which tables you want records in. Airtable has also not stated whether or not it will limit editing once you go over record limits. If you need a free solution with over 1000 records, Airtable might not be the right platform for you.
Aug 29, 2023 09:47 AM
@kuovonne is right… you shouldn’t be pre-creating records like that. I didn’t even notice or realize that that is what you are doing. You may be better served by Google Sheets, which is a free spreadsheet program that has no limit to the number of rows you can create.
Aug 29, 2023 10:13 AM
@ScottWorld @kuovonne but then what is the use of airtable. I thought i might use it to create admin dashboard which can store million of data. Since it is very convinent and fast.
Aug 29, 2023 12:00 PM
Many users have found Airtable to suit their needs. That doesn't mean that it will fit yours. Many people have created admin dashboards using Airtable, but not with millions of records of data, and not on the free plan.
Nov 08, 2023 03:04 AM
Please help me understand what constitutes a 'record'. I am not familiar with databases, but have inherited one which has important details of our wide circle of friends. And, I am also seeing warning that I have crossed the limit of permitted records in a free plan. I have six bases in my account/workspace, out of which this warning is being shown on three bases. For example, one base has only 538 rows in Master View with about 65 fields, and there are six tabs in this base. Also apart from Master View, it also has 10 more Views.
So, what do I need to reduce, to fall within the permitted limit of records?
Nov 08, 2023 06:38 AM
Each tab at the top of the data view of a base is a table of records. To see how many records in a table, look at a grid view of that table with no filters. Each row is one record. You must use an unfiltered view to know how many records are in the entire table. Then add up the number of records across all tables.
To get under the record limits, either upgrade to a plan with higher limits of delete records to get under the limits. If you choose to delete records, the “over limits” warning does not update in real time. It may take a day or so for the wsrning to go away.
Nov 09, 2023 01:07 AM
Thanks a ton, for explaining it in very simple language. Let me see how I can manage it now.
Jun 27, 2024 03:36 AM
As of now, I still able to create more than 1k records too on free plan. I just worried whether it is an error or simply just the limit is not strictly enforced for now.