Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Grouping by Multiple Select Field

5081 8
cancel
Showing results for 
Search instead for 
Did you mean: 
DavidMa
6 - Interface Innovator
6 - Interface Innovator

Let’s say I want to assign the same item to two categories in a multiple select field. And I am grouping my view by that field. For instance maybe I am creating a list of vendors and what we buy from them, so for HP I want to select “computers” and “printers” from my multiple select field. For Xerox I would only select “printers”. I would now want my grouped view to look something like this:

Computers

  • HP

Printers

  • HP
  • Xerox

But instead what Air Table understandably does is this:
Computers; Printers

  • HP

Printers

  • Xerox

Is there a way to create the grouping I want where HP would be listed twice, once under each category, as in my first example? Hopefully I’ve described my question in a way that makes sense.

Thanks

8 Replies 8

You may not like the solution I think of…
Create a seperate record for every item, and let go of the idea of Multi Select and switch to Single Select. Something like this:

Hardware%20Grouping%201
If you enter it like that, the grouped view will be like this:

Hardware%20Grouping%202

I know, it’s not perfect, but it works.

Thank you. Yes, as long as that’s the solution I can live with that :-).

Robert_Andrews1
6 - Interface Innovator
6 - Interface Innovator

This is also why I have come to the forum today.
Airtable should have a switch to group in this way. It’s confusing to see so many groups - arbitrary, non-existent groups of multiple combinations.

Karla_Berron
4 - Data Explorer
4 - Data Explorer

Hello! It’s now 2021 - has there been any progress on this issue?

In Grid View - Is there a way to group by a Multiple Select field that separates each ‘select’ to a group?

David_Thompson-
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello! It is not 2023 – has there been any progress on this issue?

I would also like to group by a multi-select field, displaying records with multiple values separately in each distinct selected value group. Notion does this perfectly.

margoyle
4 - Data Explorer
4 - Data Explorer

I would also like this, and duplicating entries is a terrible solution

mrvc
5 - Automation Enthusiast
5 - Automation Enthusiast

This is very important and seems like a simple feature to include

FaH
5 - Automation Enthusiast
5 - Automation Enthusiast

Any progess on this?
The proposed Airtable workaround "adding additional views to the table and filtering them—only showing records with specific select options" is really not helping in my case...