It would be great if there was a mode where grouping a table by a column who’s format type is “Select List” would allow you to see rows of that table in every Group where a given item from the “Select List” is select. Or perhaps there’s another approach to what I’d like to see…
For example… consider I have a table called “My Stuff” and it has a column called “Categories” which is a column with a “Select List” format and allowing multiple selections. Consider I have these items in the table
Item 1, Categories = A, B
Item 2, Categories = B, C
Item 3, Categories = C, A
Item 4, Categories = A
Item 5, Categories = C
Item 6, Categories = (none)
When I create a view of this table, and group by the Categories column, I get groupings like this:
Group: A, B … Item 1
Group: B, C … Item 2
Group: C, A … Item 3
Group: A … Item 4
Group: B … Item 5
Group: (no categories) … Item 6
What I’d like to see is:
Group A: Item 1, Item 3, Item 4
Group B: Item 1, Item 2, Item 5
Group C: Item 3
Group (no categories): Item 6
Further, I’d like to be able to move items between the Groups to be able to add that category to the item, e.g. move Item 6 to Group C would add “C” to Item 6’s Categories, or moving Item 1 to Group C would add “C” to Item 1’s Categories. If I moved an item to the Group for those with no Categories, it would clear the Categories field.
Is this possible? is there a better way for me to set this up?
Edit: Because my list of Categories is dynamic, I’d rather not setup separate views for each Group (by way of a View and a Filter where Category = A, etc.) as I’d constantly be having to add another View every time I add a new Category.