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: https://youtu.be/GjVRjeKEH98

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

3 Likes

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

@parker

Great Video!

1 Like