I have a custom form on a member page called Goals. I wanted to have a page that a few members who I have added the “admin” role to can view the results for everyone. On that admin page I added a repeater. My Goals collection has a “members data” reference field which references the “Members/PrivateMembersData” collection. In a previous post, I found out that only the “site member author” can read the data. I use the member data to get the first/last name of the user. But, this will only retrieve the logged in user’s name. For all other users it won’t.
My question is: how do I get the first/last name of the person who filled out the form when I just have the owner ID?
One approach I thought of was to add the first/last name to my goals collection. Of course, this violates traditional DB convention.
If you have to use the Wix Members app own collection of Members/PrivateMembersData collection, then you can look at using Wix Data Options.
https://www.wix.com/corvid/reference/wix-data.html#WixDataOptions
Also, note that with the Wix Members collection, you are also limited to what you can do with the collection and each of the fields too, see here for more info.
https://support.wix.com/en/article/corvid-wix-members-privatemembersdata-collection-fields
Otherwise, you should look at creating your own dataset which will let you have full control over it yourself and not be limited to what you can do with it.
Something like this in this tutorial, which will give each user their own unique page still, however you will be able to access all of the dataset entries if you needed.
https://support.wix.com/en/article/corvid-tutorial-building-your-own-members-area