Group using multiple select field, without creating a new group

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.

4 Likes

Another problem with current functionality is Record 1 might have A,B and Record 2 might be B,A and Airtable will make two different groups for that. It would be nice to have some control over how Airtable handles groups for multi-select fields.

1 Like

I strongly doubt that this will be implemented, and here’s why: each record in a database is a unique and independent entity, and therefore can only be in one place at a given time. This is a core database paradigm that’s not likely to change any time soon.

The analogy I like to give here is that a record is like a person. Say that you’re a member of two different clubs, and both clubs take an annual membership photo. It just so happens that both clubs are taking their respective photos on the same day, at the same time. Because of this, you have to choose which photo you want to appear in. You can’t clone yourself and be in both photos at once. You have to choose to be part of one photo, and absent from the other.

Database records are the same way. When choosing to group all records at once by a given field that has multiple options, Airtable has to decide where to place each record. While technically it could “clone” the record as needed for each group simply for display purposes, it doesn’t because that’s not an accurate representation of the data, and accurate data representation is hugely important in database software.

To use your example, there aren’t multiple copies of Record 3. There’s only one Record 3, so it can only appear in one group. To see the full lists of both Group A and Group B, you’ll have to create a separate view for each group. Their full membership can’t be viewed at the same time, just as you can’t be in two photos being taken at the exact same time.

Justin thanks for the insight.

The functionality would be very helpful for lots of applications. You are correct to define it more as a display than a “group” function, but I guarantee you most Airtable users want the group function specifically for the purpose of display. It makes it easy to see all related items to one tag.

Sounds like they would need to build some sort of grouped/stacked display of filters on one screen.

Would be amazing.

2 Likes

Any hint if this feature will be implemented?
I have this need for an Airtable I just created and impossible to group in a smart way for multiple select. :frowning: