Grouping - how to group by singular Multis?


#1

I have a question about Grouping…

I understand how to Group a grid view.
I am doing so by a Multi-Select field, called “Topic”.
The problem (which is one of preference) is that some of my items have more than one Topic assigned. The way Grouping works, it shows distinct groups for combinations of Topic, eg. Not only a Group showing items with a “Red” Topic, but also a Group for items with “Red”, “Green” AND “Blue” Topics.

I’m curious if I could force a Group to show all the items with the corresponding Topic. It is confusing to see this many Group combinations thanks to Multi-Select.


#2

You need to transform the MultiSelect in a new Table. There you could see the Items by Topics:

Even you could create a junction Table if you need to store more data about that relation (start date for instance): https://support.airtable.com/hc/en-us/articles/218734758-A-beginner-s-guide-to-many-to-many-relationships

You are talking so abstract I can give you more advice :sweat_smile: