Publicly displaying select content from database with strict permissions

I have a dataset called “Members” which contains certain private information for people who sign up to my site. Therefore the permissions for this database are set for strict privacy:

  • Who can read content from this collection? Site member author
  • Who can create content? Site member
  • Who can update content: Site member author
  • Who can delete content? Admin

However, I have a dynamic page on which I want to publicly (i.e. anyone can see it) display select fields from this database, such as the variable “displayname”.

Is there a way to do this without compromising the privacy of the other fields in the “Members” database? For example is there a way to use backend code to access and display select fields from the “Members” database?

Thank you!

I’m trying to do the same thing, I just want to add additional information to members profile pages. I have created a dataset that members can submit data to but do not know how to display it based on their individual profiles? I thought filtering it based on who authored the content would work, but this doesn’t seem to be an option.

Any guidance on this from the wix pros? If this is not possible, that would be useful to know as well.