This is my very first attempt at using Airtable, and my first question here. My name is Rosane, and I am a programmer. We are moving our processes into Airtable, and I expect to have lots of questions coming up. I have watched several tutorials, but am not finding the answer to my current question.
I need to count records in a base, and only display groups that have 9 or fewer records. I grouped my base and collapsed all so I see the counts, but I can’t figure out how not to show all counts. Any help is very much appreciated.
Unfortunately, what you want to do is not natively built into Airtable.
Airtable can cosmetically show you those group counts onscreen as a very shallow veneer, but Airtable doesn’t actually let you DO anything with those group counts.
You can’t use them in formulas, you can’t filter by them, you can’t sort by them, you can’t do ANYTHING with them. You can’t even copy & paste them. The only thing you can do with them is stare at them with your eyeballs and read them out loud to somebody who is standing in the same room as you. I don’t even think Airtable lets you read them out loud over a phone call. Lol.
I would highly recommend emailing firstname.lastname@example.org to request that they greatly improve this feature. In my personal opinion, it is much needed in Airtable.
The only way that you can natively sort or filter based on group counts is to link records to other tables, and then use a combination of linked record fields, count fields, and/or rollup fields to get usable numbers. But this is much more advanced stuff than what you were probably hoping to dive into.