Aug 09, 2018 07:06 AM
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.
Aug 09, 2018 08:19 AM
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:
Sep 25, 2018 11:40 PM
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?
Sep 26, 2018 08:50 AM
You also need to convert the MultipleSelect to a Table.
May 31, 2019 12:48 PM
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?
Aug 22, 2019 08:10 AM
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”?
Aug 22, 2019 02:12 PM
You can do that with today’s features.
Aug 23, 2019 04:22 AM
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
Aug 23, 2019 10:14 AM
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.
Feb 22, 2020 05:34 AM
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.