Database management for Members

Ask the community
, ,
1

I want to create a membership site where members can retrieve information specifically for them from a dataset, filtered by the logged in member, but that dataset is managed by the Admin only. They don’t touch it.

Is this possible?

I’ve seen a tutorial about how to show the information that a Member has uploaded, but I’m struggling to show data filtered for a logged in member when they aren’t the owner of that data (ie it was created by the Admin).

I’ve also seen how to show data uploaded by everyone but the logged in Member, but this also isn’t useful for what I would like to achieve.

Any help greatly appreciated!! Thanks.

2

I think it might be possible by writing a custom router that will query the DB with the logged-in member’s ID and return that data for the router-page to render.

3

Hi @claytonrmorgan
Yes Its possible and i have already implemented such an application. You can use a query filtered by the membr id. And in the database you can enter a member Id corresponding to the data you want to show to the user. I hope it will work…

4

Thanks for your replies. Ended up finding the solution here: https://www.wix.com/code/home/forum/community-discussion/how-to-filter-a-table-according-to-the-current-user and it’s working a treat.