Group with different columns

[lo_duq]

Hello to all,

I created an app from a spreadsheet that contained an exercise list (for climbing). Each exercise is categorized (minimum age, difficulty ...) and one of these categories defines the theme of the exercise (balance, strength, mental ...). As an exercise can correspond to several themes, I have multiplied the theme column into 3 columns. Now I want the app to group the exercises by theme, but I see very well how to group them according to a column but I don't see how to group the exercises from the result of three columns (example: in the mental group I will find all the exercises having mental in the category column 1,2 or 3). I hope I have been clear, I thank you for the help you can give me.

Loïc

[Marc_Dillon]

That's not a very optimal data structure.

Here's something you could try. Create a table (or maybe you already have it) of all possible categories. Then make a View on this table, and set a Row Select Behavior that uses LINKTOFILTEREDVIEW to view all records that match the selected category in either of the 3 columns.

https://help.appsheet.com/en/articles/2357260-linktofilteredview

https://help.appsheet.com/en/articles/2357288-or