I’m struggling with what should be a simple query. I think I’m just not used to Bubble grammar/logic yet.
So I have three data types: User (email etc); Group (id, active?, etc); GroupMember (member, group, other data). The member field is a User object and group field is a Group object.
Now I want to display in a repeating group all users that are in the same active group (in GroupMember) as the current user.
So I have set the content type of my repeating group to GroupMember (I’ve also tried User). I am now trying to set my data source but I’m always getting an error.
As I see it, I need to:
a) Find the active group in GroupMember that my current user belongs to;
b) Find other GroupMember records with the same group
c) Return the list of User records for those GroupMember records
Below is a screenshot of my latest attempt: