Pull count Value

Question

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?

ScottWorld · Accepted Answer

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.

Steve_Doll · Answer

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.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded