Filter one collection's names based on a list of another collection

Hi
This should be an easy one to solve for the experts, and is probably already answered somewhere before.

I have a collection of names called “People”. I have made a ‘Friend’ list of this with a toggle so a user will go through that list and select those people that they are friends. This will then create a record into a new collection called “Friendship” with the Friend name in one column and the Users name in another.

If the user wanted to add more people and go back to the Friend List, how do I filter out those people already selected and only show those people currently not selected?

It sounds easy but I am going around in circles with the filters in Adalo because its a list of friend’s names, not just one name.

Any help would be greatly appreciated.

Thanks
Darren

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.