Matching Database Entries

Hello there,

I need some desire assistance. I’m working on a site but I’m working on adding some security features. I have a database where people put their email (database is called email). Yet, on a dynamic page informaiton is displayed, now the problem the that anyone can access this information as long as they are signed into the page. I’ve been playing around with code but I’m not able to figure it out. :frowning: I require that only the user email associated with the dynamic page can have permission to access the page.
I know the databases assign a ID to each entry. If that ID could somehow be validated to be checked with the email in the dynamic page it would probably work.

Hi Jason,

database collections has permissions on them which you should first set to ‘site member author’


then in your repeater/table that directs to the dynamic page you should filter the dataset to display only those owned by the author

Shlomi

Hello Shlomi! Thank you very much for your answer! Yet, I’m afraid that this isn’t quite what I am looking for. What I basically require is that there are able to be two site member authors for one database entry. In my user input fields I have one that’s name “to:” and one that is named “from:” in both fields people enter an email, both which match to an existing entry in another database collections. I need only so that both people with the to and from matching their account can see, view, and edit the entry instead of just the “from:” person. I hope this clears up any confusion.

Thank you,
Jason

Hi Jason,

the full context of the scenario is still not clear, wix code supports a single owner but you can implement your own data hooks and enforce that logic.

Shlomi