I have a collection ‘Users’ and another collection ‘Teams’. Users belong to Teams in my database structure.
I have a function where I can select a user and add them to the team in Xano, that works great. What I’d like to do is not show a user if they already exist as part of the team I have selected. The users are stored in an Array in my database where multiple users can exist in one team.
Any idea how I can filter in Xano to only show users who are not already added to the team I am on?