Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Pull count Value

Solved
Jump to Solution
291 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all,

When grouping, Airtable automatically does this count, anybody know if we can pull this Count Value into a cell with like a Formula or something?
image

1 Solution

Accepted Solutions

Unfortunately, the values in the summary bar are completely inaccessible to us in formulas. :frowning:

You can only get a count by counting linked records in another table. So, if your records are linked to another table, then you can do a count from that other table — and you can even re-lookup the count back into the current table.

Otherwise, you’d need to create your own custom JavaScript that loops through the records and figures out the count of each group — and then stores the count of each group somewhere.

This sort of group counting can also be created with Integromat’s aggregator module, which is a low-code/no-code platform that lets you do many of the advanced things that you would normally need JavaScript to do.

See Solution in Thread

2 Replies 2

Unfortunately, the values in the summary bar are completely inaccessible to us in formulas. :frowning:

You can only get a count by counting linked records in another table. So, if your records are linked to another table, then you can do a count from that other table — and you can even re-lookup the count back into the current table.

Otherwise, you’d need to create your own custom JavaScript that loops through the records and figures out the count of each group — and then stores the count of each group somewhere.

This sort of group counting can also be created with Integromat’s aggregator module, which is a low-code/no-code platform that lets you do many of the advanced things that you would normally need JavaScript to do.

Thanks for the reply, much appreciated.