Comparing Differences Between Two Tables

Hi @Kamilla_Foler :blush: and Welcome to the Community :partying_face: !

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 :blush:

And just to illustrate this :point_down:

…here’s a quick sample :blush: (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 :blush: .

But again, without a sample/mock-up doc of your actual set up this is just a possibility, an idea :innocent:

4 Likes