I have two collections involved in this:
The PrivateMembersData collection
The PaymentCycle collection
I have created a referenced field in the PaymentCycle collection which references users Login Email as set when they register.
I'm trying to make it so that when the user that is logged in visits the page where the table is displayed, they will only be able to see the row in the table that contains their own email via the referenced cell.
I've been able to match the emails to who I assign they should pay, however the table shows everyones details and doesn't only show their own email and who they should pay.
When logged in as the admin this is what is seen and when logged in as a site member the following happens:
when the PaymentCycle dataset is filtered to "owner is logged in": nothing is shown
when the PaymentCycle dataset is filtered to "owner is not logged in" everything is shown however only the email of the user who is logged in is shown under the (your email).
Thank you for any help in advance.
I referenced the following guide: