Hi @Kamilla_Foler and Welcome to the Community
!
As @Federico.Stefanato said, it would be better if you could share a sample/mock-up doc with us so we could you give you a more precise answer …
And just to illustrate this
…here’s a quick sample (Some explanations are below the sample)
There’s an Artists
table containing all the artists (enjoyed or not … this is determined using a simple checkbox but it could be something else).
This table is then linked to the Event
table through a LookUp
field where for each concert I selected one artist from the Artists
table.
To filter the Event
table so it only displays the concert by the artist I marked as “enjoyed” (i.e.: Enjoy ?
checkbox is Checked
I created checkbox on the canvas and added this filter formula to the Event
table.
thisRow.Artists.[Enjoy ?].Matches([checkbox 1])
So if the canvas checkbox is checked → the table will only display the concert of the Artists
marked as Enjoy
and if the canvas checkbox is unchecked, the opposite .
But again, without a sample/mock-up doc of your actual set up this is just a possibility, an idea …