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?
Solved
Pull count Value
Best answer by ScottWorld
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.
+20Unfortunately, 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.
ScottWorld wrote:
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.
1 person likes this
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.