Grouping by Multiple Select Field


#1

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


#2

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.


#3

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