Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 01, 2021 10:01 AM - edited Feb 16, 2024 09:49 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.
USA
Canada
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!
Note: the UNNEST command in SQL uses an array field to create one row per array element
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.
Aug 11, 2023 03:50 AM
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!
https://support.airtable.com/docs/multiple-select-field
I suggest visiting that support article and responding to the page with feedback about how poor this suggested workaround is.
Jan 17, 2024 05:02 PM
This would be a great solution @mrvc. @dashler78 please implement asap.
Feb 16, 2024 09:52 AM
SQL has UNNEST command that uses an array field to create one row per array element