How to display only certain records based on group count

Hello, everyone,

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.

Thanks,

Rosane

Welcome to the community, @Rosane_Mordt!

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 support@airtable.com 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.

You could also automate some sort of a group counting automation with JavaScripting or external automation tools like Make.com, but that is EVEN MORE advanced.

Also, since you’re brand new to Airtable, you might gain a lot from my free Airtable training course:

@Rosane_Mordt - there is one way to do this, but relies on your group field being a linked field. Example:

I have Categories and Items table and each item is linked to a Category:

Screenshot 2022-06-25 at 10.07.54

On my categories table, I count the number of items associated with each:

Screenshot 2022-06-25 at 10.09.16

I can now pass this count value down to every item (lookup field)

Screenshot 2022-06-25 at 10.10.03

I can group by category and filter out any records where (for example) the Items in category value is less than 2:

1 Like

Thanks, @JonathanBowen, for taking the time to spell this out!

@Rosane_Mordt: This is one of the advanced workarounds that I was referring to earlier,

1 Like

Thank you so much, @JonathanBowen ! I will give this a try.

Rosane

Thank you, @ScottWorld!

Rosane

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.