I have a simple pair of tables to collect and process usability testing notes. In my main table, I have each note as a record, and there is a lookup field for tags that apply. The tags are in a linked second table. I.e., each note may have multiple tags, and each tag may have multiple notes.
I want to view each tag with a list of the corresponding notes below. I can see that here in the expanded record view. Like this:
But I can’t figure out how to do this in a grid view to get an overview, e.g., with groups. I get all the tags aggregated or the notes aggregated. Like this in the second group:
I suspect this is a simple issue but I can’t figure it out. Suggestions?.
"The “group” feature of Views treats the values of array-type fields (multiselect and record links) as one long string. It is not yet possible to have one group per array item, with records appearing multiple times in the view depending on how many individual groups they fall under.
While Airtable has talked about this possibly being changed in the future, no timeline for this change was given."
A workaround would be to create multiple views filtered to display each individual tag.
The filter would be something like Where Tag “contains" Tag Name .