How to show items connected to the logged in user

In my AirTable base I have a table for Users and a table for Items.

I then have a table for links that tell me when a User owns an instance of an Item.

What I want to do is to display a list of all and only the Items that are linked to the current logged in User.

It feels like this should be simple but I can see how to do it.

Set the conditional filter on the block so that “[condition] is Logged in user’s [variable]”

In this instance, presuming the [variable] will be the primary field in your table for your users; whatever is the same field which appears as the linked record field in the Items table.

Thanks, Matt.

I worked it out by assigning the list to my links table (not the objects table). Then I display related fields from the objects table.

It works!

Alex

1 Like