I have a basketball team app for parents with different teams. I need team specific chatroom. Parents shouldnt be able to create a chatroom ro initiate a one on one chat.
Path: Home > Team > Chat> Chatroom
If there’s anyway my parents can access the Chatroom from Home that would be great.
1st database structure:
you should have the parents as users have only one team in relationship between the collections (one team multiple users)
each team has at least one chat, (you should create the chat with the creation of a team, this way any new parent entering for the first time will immediately see the chat button)
the rest of the messages relationship to the chat collection is as usual
Now how to make it work from home screen:
put a chat button on the home screen, make it a list of teams, filter = team that contains the parrents as users, link to a chat screen, the screen would display a listt of messages, filter= message -->chat → team ID= current teamID
have fun with Adalo