I have an app with USERS that join TEAMS
Each TEAM - have TEAM MEMBERS - (List of Users)
In a repeating group I have USERS in a TEAM which I want to SORT by Team Member ORDER.
How do I set up my Database so that each USER has an TEAM MEMBER ORDER - to SORT or each TEAM they belong to
The question isn’t that quite clear, you want to display a list of users by the team they belong to?
Thanks for responding. I can already display user by the team they belong to. I need to assign an team member order number to sort that list by order for each team they belong to
what do you mean by order number?
do you mean something to identify them with? or category the team belong to
I need to be able to reorder team members in any team they belong to
It is a good idea to have one more datatype for this. You need a new datatype called Team Member that has a field for Team and one for Member (or user). When a member joins a team you create a new Team Member with those fields filled in. Also add some logic so if they want to join a team check if a database entry already exists. If they leave a team either delete the thing, or for history purposes add a date field for when they left.
Then that allows you to set up a repeating group for Team Member and filter by Member and see all their Teams, or filter by Team and see all Members.
Thank you - I’ll try this
