Narrowing down Data in a View with "radio buttons"

AppSheet AppSheet Q&A
,
1

Hi.

I have an app where I have a record that contains details of a Rock group. And I record in that data whether:

  1. I have seen them,
  2. I have interviewed them
  3. I have reviewed them,
  4. I have included them in a report.

I want to be able to display all my band records, let’s say in a panel on the left of a dashboard, then select 1, 2 ,3, or even 4 of the above conditions, and have the relevant bands displayed in the right panel.

So if I select conditions 1 and 3, the right panel displays bands I have seen AND reviewed.
If I select 1 and 2, it would show all the bands I have seen and interviewed.

And so on. There are obviously 24 combinations (some are duplicate) so i don’t want to create loads of views etc.

Any ideas of an approach for this?

Thanks

TS