Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Count number of unique groups

cancel
Showing results for 
Search instead for 
Did you mean: 
ScottWorld
18 - Pluto
18 - Pluto

When working on a layout with groups, it would be awesome if Airtable gave us the ability to automatically display the total number of unique groups on that layout. Even better, automatically number the groups going down the left-hand margin, so we could say “I’m currently looking at group #17 of 28 total groups”.

3 Comments
Michael_Berman
6 - Interface Innovator
6 - Interface Innovator

This work?

0d41b7239ab01c5f5e8f76a7f7d714f76ba86a36.png

numbered groups - Airtable

Explore the "numbered groups" base on Airtable.

Michael_Berman
6 - Interface Innovator
6 - Interface Innovator

Explanation:
grouped value is linked to table “grouped values” which has an auto index beside the unique values.
field 5 is linked to one record in table 2
table 2, field 5 uses arrayunique to isolate all the unique items in table 1
table 2, field 6 uses counta to sum the number of unique variables in field 5
table 1, field 6 uses lookup on field 5 to reference the above
table 1, field 7 looks up the index through grouped values
field 8 concatenated
use field 8 to group
because it a lookup value, you will not be able to add to the table while this group is working
if you leave the field 5 grouping while adding values then you will automatically add to the cell in table 2 when you add new records and your grouping will continue to work

hope this helps
M

ScottWorld
18 - Pluto
18 - Pluto

@Michael_Berman, thanks for this workaround! :grinning_face_with_big_eyes: