Grouping Multi-select using a formula

[Robert_Andrews1]

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.

[Elias_Gomez_Sai]

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

You are talking so abstract I can’t give you more advice :grinning_face_with_sweat:

[Jayati_Doshi]

I have a similar question. (@Elias_Gomez_Sainz, if you could help! )
So, for example, I have a workspace with multiple projects, and one multi-column that has the type of activity, so say consulting, research, workshop, and so on. Now, I need to group all the records that have consulting, all those have research, etc. Right now, it is grouping the records that have 3 of these, 2 of these, and those that have only one, rather than showing me all that have one of these functions.
I tried to use filters for this when it was just a few categories, but this is not helping when there are many categories. Is there any way to group it this way?

[Elias_Gomez_Sai]

You also need to convert the MultipleSelect to a Table.

[Susan_Lanier]

Hi - I’d like to be able to do this but plotted onto the new Gannt chart. The problem with converting the multiple select to a table is that you then have to create a date look up fields which creates an array.

Is there a way to do this?

[Scott_R]

I read the support article but not sure what which solution I need. Let’s say I simply have a client and they are in two projects (an in person project and online project.) So I have a multi-select for my clients and group by this selection.

Like the original post, if a client is in person and online, it makes a new category. Instead I want them to show up in both categories, not a new category for people with both online and in person checked.

Can you explain how to “transform the multiselect in a new table”?

Thanks!

[Elias_Gomez_Sai]

Scott_R:

I want them to show up in both categories

You can do that with today’s features.

Scott_R:

Can you explain how to “transform the multiselect in a new table”?

[Scott_R]

I’m sorry. I feel this should be easy, but when I tried to select link to a new table, It didn’t create a new table as yours did. It just created a new category.

I have attached this image. I have groups. I just want the client to stay in both groups, in a similar view as I have, if possible…

Hm, it won’t let me attach an image or include a link. Here’s a screen shot, just remove the spaces… "https:// prnt .sc /owit4p

[Elias_Gomez_Sai]

Scott_R:

I’m sorry. I feel this should be easy, but when I tried to select link to a new table, It didn’t create a new table as yours did. It just created a new category.

1. Open the field configuration
2. Change the field Type to ‘Link to another record’, at the top
3. Go to the bottom and select ‘Create new table’
4. Press ‘Save’

Anyway, this not solves the problem on the Grouping in the Client table, but creates a Client Type table where you can work: get sums, bye Clients by Type, etc.

[Pamela_Alfred]

Hi,
Can I transform a multiselect field in a new table when it is currently integrated with Jotform. I don’t want to mess up with my current setup right now.
Thank you