I maxed out 500 fields. It’s disappointing cause I didn’t know about it or I missed it wherever it’s mentioned. At least the Account overview should warn me earlier I am maxing out the number of fields. It doesn’t say anything about that. Now I have to spent days and days to redesign the table, maybe weeks…
I have lots of fields primarily because of many complex formulas I have. I rather do multiple steps with formulas so that it’s easier to fix them or update them, given how unhelpful the formula editor is in Airtable.
Now I will have to fold many of these fields together to free some space. I have alone 30 fields taken up with formula to generate separate URLs for attachments in the attachment fields (Yes I know there is an addon)… and so on.
If I sound a bit frustrated, yes I am. That’s SILLY this 500 fields limit. If it was 1000, fine. But I would have thought maybe 5000 or unlimited.
I have lots of formulas and dozens of automations… It will take me weeks to fix this.
This is an issue for Airtable database design.
I already have 15 linked tables also with 100’s of additional fields there. So it’s not like I am not taking advantage of additional tables.
From what I see, even if I upgrade to the highest Airtable plan, I can’t remove this limitation. It’s a design limitation.
This is bad bad… If I sound frustrated … YES I am
Simple mention of database limitations would solve it. There’s place for this in the account overview. So if Airtable is quick pointing out the benefits of an upgrade to higher package, it should also point out the obvious limitations of records. If this was a time-sensitive thing the user putting together such a database would be screwed.
Now in this situation it doesn’t make it easy to redesign things, looking at this hairball it’s a major redesign. There is a thick line on the right of left long table and that is made out of 100’s formulas. That’s the problem.
Previously discussed here…