Great information. I also will be referring people to this post…probably often.
I just want to add the reason WHY row owners can only be applied to basic columns in a google sheet or glide table. I think what many people don’t realize is that any computed columns are actually computed on a user’s device. It may seem like it’s done on the glide server, but it’s not. This includes relations, lookups, template, math, etc. Anything that’s not a basic column.
Because of that, for example, the reason you can’t use a lookup as a row owner, is because all of the data needs to be downloaded to the user’s device before the lookup function can run. At that point you have already defeated the purpose of row owners, which is to secure data by preventing it from being downloaded to a user’s device in the first place.
Only basic column data is synced between the glide servers and each user device. All of the calculations and computed column values are only determined on the user device.