500 is the limit for fields per table. If you're exceeding this, you may want to think about pivoting your data or using linked record relationships to normalize it into joined tables instead of one wide table.
https://support.airtable.com/docs/airtable-plans
Yeah, I was thinking of breaking the data in more tables but I was really hoping to have all data in one place (in a one big table) 🙂 Thanks
There are some good reasons to do so when using Airtable. Unlike a spreadsheet app, records will not be able to access surrounding records in the same table via formulas in Airtable. You must build relationships to create aggregated data points as field values to actually use/output and not just view in a group by summary function. Airtable can be a database for spreadsheet folks but it doesn't shine when used only like a spreadsheet.
Yeah, I understand.. I'm getting used to this but it's hard sometimes when you were using spredsheets for years 🙂 I'm slowly getting there.
@SpelaU
Note that Airtable is not a professional enterprise-grade database app. It is a basic, entry-level database app (that doesn't even have 20% of the functions that Excel has).
However, if you are looking for a professional database app with no limitations at all (up to 256 million fields, up to billions of records, up to 8 TB worth of attachments, full design canvas, enterprise-grade security, encryption, etc.), you will want to look at FileMaker Pro.
I was a certified FileMaker developer for 30 years before becoming an Airtable consultant, so if you need a referral to some great FileMaker developer, feel free to contact me through my website.
Thanks, I will check it out.