I have a collection that has a reference field to the first collection. The first collection is the PrivateMembersData. Basically, I have a custom form that I want all members to fill out. Let’s say it’s a liability waiver form. Let’s say I have 3 members - John, Bill, Sarah. Let’s say John and Bill have filled out the waiver. I want to be able to have a list saying Sarah hasn’t filled out the waiver.
I have a page now that has both datasets. The waiver collection has the reference field to the Members collection. The waiver dataset has no filters. The members dataset has a filter. See pic. In the pic waiver = goals.
My dynamic text/table will look at the waiver table which has less records and pull the associated member data. Great! By the way, this is all done through the editor and not any code. Again waiver = goals.
How do I go the other way? I want to look at the members data and list all of the people who don’t have a record in the waiver table. Do I need to use code? Can I do this in the editor?
Thank you!
Note that if you use the Members/PrivateMembersData collection, which is added to you website automatically when you add the Wix Members app.
Then please note that there are limits to what you can do with the fields from this collection as shown here.
https://support.wix.com/en/article/corvid-wix-members-privatemembersdata-collection-fields
Also, note that this collection is set up to only show the relevant site member data which is unique to that specific site member and it won’t display all the collection data to all site members.
The PrivateMembersData collection has the following permissions :
-
Read: Site member author
-
Create: None
-
Update: None
-
Delete: None
You can workaround this with Wix Data Options.
https://www.wix.com/corvid/reference/wix-data.html#WixDataOptions
You might be better suited doing something like this member profile tutorial here.
https://support.wix.com/en/article/corvid-tutorial-building-your-own-members-area
Simply change the member profile parts to your waiver form for example and connect another dataset to this tutorials dataset through reference field, which will give you the same answer as you are looking to do above.
Plus, see here for working with reference fields and multiple datasets.
https://support.wix.com/en/article/about-your-database-collection-fields
https://support.wix.com/en/article/about-reference-fields-in-database-collections
https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931
https://support.wix.com/en/article/referencing-multiple-items-in-one-database-field
https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields
https://support.wix.com/en/article/about-referencing-multiple-items-in-one-field
