Okay.
Let me first preface this by saying that what follows is not much more than me thinking out aloud, and there is every chance that I could be wildly off base.
With that said…
I’ll assume first that within your Business Owners table there is a mix of information about each business. Some of this you want to make public, but some should be kept private and only accessible by individual business owners. If that’s not true, then you can probably stop reading here. Otherwise, read on…
If there is any private information in the Business Owners sheet, then you definitely should be using row owners on that table. But then, how do you make the “public” information available?
This is what I would do:
- Create a 2nd sheet, let’s call it Business Owners Public
- The first column of this sheet would be an arrayformula, which copies the RowID from the private table
- You use this column to create a relation between the two tables
- With that in place, you can add a lookup column to bring in each column from the private table that you want to make public
- You do not set any row owner on this table, so all data is accessible by anyone
Then with the above in place, anywhere in your app you need to display “public” business owner data, you reference this sheet instead of the “private” sheet.
This is a very similar approach to what @kyleheney described here, and to my simple mind it is both sound and secure.