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!
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:
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.
"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.
This would be so simple with a checkbox to 'separate multiple values'. Official response from airtable on following page has a poor workaround suggested — creating views for every multiselect item which would be super tedious!
I suggest visiting that support article and responding to the page with feedback about how poor this suggested workaround is.