I need help using databases.
My idea is a website where: You can become member Members can create a team (main page shows all teams like a members page) Each team has various levels for permissions for its team members Leaders can assign people to the team roster Each team has private pages for only it’s team members
I’m having a trouble planning this out and dont really know how to use databases yet. If you have any advice for this topic and just tips in general for databases that you’ve found useful, let me know. Thanks!
Hi,
You can find the following links useful for achieving the desired functionality:
-
Create a database that will contain all the team names.
-
Create a members only page where they will be able to create a team ( add data to the collection).
-
Create custom members area (the custom members collection should reference the team in the teams collection)
-
On the team members list page display all the members relevant for the current team ( query the teams database and display the gotten data in the repeater) and check the email of the currently logged in member . If it’s a team leader - display buttons or dropdowns that allow changing member roles, if not keep them hidden .
-
For each team to have private page, you can use dynamic pages but display only information relevant to the members team, the same way as in the members list part.
I hope the above information was helpful. You can also hire a Wix partner using the instructions here to help you achieve the desired functionality.