Finding data in a search list screen

Hi there!

I have a „user“ collection in which there is a contacts column with a many-to-many relationship back to users. The idea is that I can add „contacts“ (who are other users) to a user.

Using the search list screen I want to do the following:

… search for users whoes email addresses match the search criteria AND who are not already in my (Logged in user) contacts list.

I can filter on the search input, BUT I cannot find a way to filter out the users in my contacts colums.

Why is that??

Hey Gavan!

This is such a great question. In short, I’ve found the best way to do this is by adding another many-to-many relationship back to Users where you can store a list of Users where somebody is on a contacts list.

That solution sounds a little confusing, so I recorded a demo answering your question on video! Check it out here:

I hope that helps you. Let me know if you have any questions!


Hey Parker! Thank you so much for your help and the video on youtube. You have solved my problem (on which I have spent many hours looking for a solution) and explained the solution so elegantly. Great! :grin:

Many thanks again!!!

1 Like

So happy to help out, Gavan! Good luck on the rest of your build :grin:

1 Like


Great Video!

1 Like