Maximum fields in Airtable?

[SpelaU]

Hi guys! I was just wondering what is the maximum fields in Airtable (Enterprise or Pro)? I heard that the number is 500, but this is too small for me. I would like to import more than 100.000 products (in records) and for each record I want around 1,200 fields (columns). Does anyone know if this is possible?

[Stephen_Orr1]

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

[SpelaU]

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

[Stephen_Orr1]

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.

[SpelaU]

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. 

[ScottWorld]

@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.

[SpelaU]

Thanks, I will check it out.