Skip to main content

Grouping by Multiple Select Field

  • February 11, 2018
  • 8 replies
  • 57 views

Forum|alt.badge.img+9

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

Forum|alt.badge.img+18

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:


If you enter it like that, the grouped view will be like this:

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


Forum|alt.badge.img+9
  • Author
  • Known Participant
  • February 11, 2018

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:


If you enter it like that, the grouped view will be like this:

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


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


Forum|alt.badge.img+7
  • Participating Frequently
  • August 9, 2018

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.


Forum|alt.badge.img+1
  • New Participant
  • March 17, 2021

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?


Forum|alt.badge.img+6

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.


Forum|alt.badge.img+3
  • New Participant
  • August 3, 2023

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


Forum|alt.badge.img+6
  • Participating Frequently
  • August 11, 2023

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


Forum|alt.badge.img+8
  • Participating Frequently
  • May 24, 2024

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...