Grouped by Multiple select should separate values not lump them together

AirTable acknowledges that users like to create many views. What they do not understand is that while yes, views are critical, we are forced to create more views than we want for one key lacking feature (bug IMHO):

"Grouped by" view on “Multiple select” field does not separate the individual values

E.g., if a table has one record with “Product1” available in “USA” and a second record with “Product2” available in “USA”, “Canada”, then grouping by availability will currently yield two results, “USA” and “USA, Canada”. Instead it should show “USA” with Product1 and Product 2, and “Canada” with Product2.

USA

  • Product1
  • Product2

Canada

  • Product2

Of course, this gets much worse in real-world examples where you have larger numbers. The manual, painful workaround? Manually create a filtered view for each multiple select value. UGH!

2 Likes

I agree. I was disappointed that when using Multiple Select I could not filter by a Single label, only with the same combination of Multiple’s Selected. I’d rather the Multiple Select be like “Labels” in Gmail where a record (i.e., email) can have 3 labels (USA, Canada, Mexico), but I can still click on “USA Label” to view all messages that have that label - even if they have other labels as well. In AirTable, it seems to exclude the “USA” labeled records if they have more than 1 record because I didn’t say “USA” and “Canada”…

Filtering by a single item—or an arbitrary combination of items—from a multiple-select field is possible (I do it frequently). Here’s an example of that type of filter setup:

Screen Shot 2021-09-04 at 11.31.45 AM

However, grouping by a multiple-select field currently groups by the entire contents of the field, not the individually-selected items. That’s because Airtable strictly adheres to the concept that a single record can only exist in one place when displayed in any view.

One way around this is to change the multiple-select to a linked record field. Using the earlier example of products and countries, you could make a [Countries] table with “USA” and “Canada” entries, and link products to them. Then you’d be able to see all products linked to either country.

Thanks for the response, I said “filter” but did mean “grouping” like you mentioned. I will keep this in mind!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.