I have to admit that its not so easy to figure out referenced fields, in the beginning. I have a worksheet named (locations) which contains [owner_uid], [owneremail] and [location_uid] fields.
In this worksheet, [location_uid] is always unique. [owner_uid] and [owneremail] are multiple, since there are several locations belong to same [owner_uid].
For this table, in security filters, I have added the following as in the help example;
OR(USEREMAIL() = "email@example.com", USEREMAIL() = [EmailColumn])
which works fine when tested for an invited user.
On the other hand, my main data table consists of multiple copies of [location_uid] rows containing several records for varying dates, for these locations. I am viewing this table’s records with a deck-view, and in Behaviour section, “Row Selected” set to “Edit” which brings a Form to edit.
What kind of REFerence/design needed here, to let [owneremail] view/edit their own locations only and filter out rest of the data? (Other than creating several replicates of emails in an email column, and apply security filter to main data table, too)