Help

Re: Pull count Value

Solved
Jump to Solution
411 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve_Doll
5 - Automation Enthusiast
5 - Automation Enthusiast

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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.