I have a member profile page, setup with the wix members area tutorial (https://support.wix.com/en/article/how-to-build-your-own-members-area-using-code) and setup almost identically as far as user information.
My goal is to have a small website for family and friends to login and draft weekly nfl teams for a little competition we do. I want each user to have access to edit and update their profile, submit their team, and display a leaderboard.
Everything is working fine except the leaderboard. The player database is set to "Site Member Author" can read so that each player can only see/edit their own profile and submit their own picks. But when I want to display their name and profile picture (in order of rank, which is a field in the member database) in a leaderboard list, it still only displays the current "Author" and not all other members as well. If I change the permission to "Site Member" can read, then the member profile area and submission pages no longer work since they are not tied to a specific user, so that idea is out.
I want all site members to see the leaderboard which includes other members photo and name but only be able to see and edit their own data everywhere else.