My website has a login function to provide users information’s related to their accounts only (profile, bills, etc…)
On a profile page, I can check I am correctly connected with a unique profile (one userId); this page is dynamic with permissions members only
I’ve got a second dynamic page with permissions members. On that page, I have one dataset to see different bills. This is visible via a table which is connected to the dataset.
When I am connected with my user, on that page, I can see all the bills available in the dataset.
I did not succeed to filter to a specific user on the table.
How can I setup on a table a filter to see only bill related to the connected user ?
Thanks for your help
There are two ways to do this: if the users create their own rows (which, in your use case I doubt), you have to code to select all rows with that userid. Other option is to copy email address per user to your bills-row and later, in code, selecting on that email address. So it takes abit of code, but nothing special.
Dear Giri,
Many thanks for your help !
I think you right the second possibilities for me is the option 2 ( opy email address per user to your bills-row and later, in code, selecting on that email address)
I added the column email in the database but to be honest I have some difficulties via the code to transfer the correct email to the selected page.
Maybe my mistake is on the page ingo URL to select.
Should I modify the URL page code to use email instead of userID as well ?
Many thanks for you help, I am quite lost as I started on Wix
Thx again
pierre-yves
