I am trying to limit access to a page/table view. It seems straight forward initially, but the answer is not coming to me …
I need two groups of users to be able to access the page/table.
- Anyone with a user role of “Role A”. This is easy by setting the page login to user role “Role A”, which would allow access to all data in the table.
- Anyone with a user role of “Role B” that is selected in a connected field titled “Owner”. This is easy by adding a table (data source) filter “Owner is the logged-in Role B”, which would allow access to only those matching records.
Where I am having trouble is giving access to either of the above options. As soon as a filter is added it prevents Role A from access, and if you don’t have a filter, it doesn’t limit the second option as required.
What am I missing?