Sep 01, 2021 10:01 AM
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.
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!
Sep 03, 2021 12:21 PM
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”…
Sep 04, 2021 11:44 AM
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:
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.
Sep 04, 2021 04:44 PM
Thanks for the response, I said “filter” but did mean “grouping” like you mentioned. I will keep this in mind!
May 17, 2023 02:23 PM
This would be very helpful to me as well. Perhaps as a grouping option (x Repeat records in multiple groups)
Jun 03, 2023 11:05 PM - edited Jun 03, 2023 11:10 PM
"List View" is a limited option for addressing this somewhat. It only works with linked tables not select fields, but you can easily convert a select field to a linked table. Unfortunately, though, the List View only "groups" by the key field.
Note: the List View can in fact show the same record in multiple places in the same view (e.g., if linked to more than one record in upper level table), so that seems not to be a valid reason for not displaying group by fields with multiple values separately.