Hi All. So I’m having a play with Row Owners as I would like for the person that is logging in, depending on what organisation they belong to, only see data for that organisation.
In my user table I created an Organisation column and made it the row owner and I set org names accordingly. In my Animal table, I did the same. But now I can’t see any animal no matter who I logged in as. So I created a test animal to see what happens in that new column and it is adding in the email of the person who is logged in and subsequently that person can now see that one test animal. How do I tell it to not use the person’s email but rather the Organisation instead so that anyone from that same organisation can see that animal?