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!