I would love to be able to have a record appear in two groups when using a multiple select field, rather than having the record create a new group that is the combination:
i.e. Record 1 — A Record 2 — B Record 3 — A,B
Group A Record 1 Record 3
Group B Record 1 Record 3
Current functionality creates a new group called Group A,B and each group then only has one record.
Have been tracking this issue for years and realized I never chimed in.
I have at least a dozen scenarios for my clients where an option to Group By individual values would solve the scenario and the current behavior makes the Group By feature unusable for them.
Indeed, I think this is probably the more common scenario for end users than the current behavior.
I too would like this feature. And also the ability to define a group, but be able to toggle it off or on without resetting the group configuration.
Regarding the limitations Justin was mentioning a couple of years back, perhaps a solution may be to have a new View type specifically for viewing/managing grouped data, maybe a Group View?
Another user here, just validating the chorus above. When I create a view grouped by a multiple-select field, it gives items with more than one selection their own group, rather than appearing under each of the groups selected.
It defeats the whole purpose of multiple-select, since it’s treating every combination of selections as a unique, singular category.
This would be so simple with a checkbox to 'split multiple values'. Official response from airtable and the suggested workaround is poor — create views for every multiselect item — 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 and link to this post...
