Row Owners vs. Filters

As far as filters are concerned, everything is done client side. About the only client/server interaction is to synchronize data changes between glide’s copy of the database and the client’s copy of the database.

Row Owners are a security feature which restricts which data is sent to the client in the first place.

Row owners need to be basic columns. You can’t use computed columns because computed columns are computed only on the user’s device after the data has been synchronized to them. At that point, data security is a moot point if you wanted to apply row owners to computed columns. The only loophole is to create an array via a google sheet, because a sheet array is not computed data. It’s still basic static data, so you can apply row owners to an array column generated from sequentially numbered Google sheet columns.

3 Likes