- I have a “employee” table with one column being “email”
- I have another table called data where each employee can enter multiple rows.
- I created access rules as follows:
if user.Email == data.Email allow R U C D
This was working so far.
- Then I changed “email” column in data table to be a reference column in “employee” table.
This is where access rule broke. I am not able to figure out how to match logged in user’s email with table’s email’s field when the field is a reference.