Help

Re: Grouping by Multiple Select Field

1676 0
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

7 Replies 7

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