Continuing the discussion from Row Owners vs. Filters:
“All records” means all columns of all records? Even lookups? Notion usually does not display lookups/rollups if the viewer has no permission to read the related table from where the rollup (lookup) is coming from. What about glide?
Almost all computed columns, including Lookups, process client side. The device in your hand determines what a Lookup returns, based on the source data that is available. If the data is coming from a different table and that table is not under row ownership, then it has access to all rows of data in that other table as well. Your device is doing the heavy lifting based on the data that has been downloaded to that device.
If a user does not have access to data in another table, then the lookup will be empty.
Great, thanks, then it works in a similar way to notion. I will in that case use the row owner at the source table with confidential info. so that i can see it from the shared tables via lookup, but not the rest of users as they will not have row ownership to the private source table.