Google Sheets and ARRAYFORMULA

[burningmikey]

I agree. The only reason I use a Sheet formula is to create a mirror public table (no row owners) from a private table (row owners). Unless there is another way to do it!

[Darren_Murphy]

Of course there is

Secure Your Data with Row Owners and Public Profiles

Hey fellow Gliders! Are you using Row Owners and Public Profiles to secure your user data? If not, you might accidentally expose private info. Let’s fix that. In this important tutorial, I demonstrate how and why to enable Row Owners, create a Public Profiles table, and onboard new users in order to safely create a community app that doesn’t reference the User Profile table. [Glide: Secure Your Data with Row Owners and Public Profiles] You can also reference this article in…

[burningmikey]

Much more better and elegant. I had missed that video, so thank you