Hi everyone, I’m looking for some advice on this issue as I haven’t been able to find a solution yet. I have a Glide Pro account (public with email).
In my app, I have two types of users, let’s say clients and professionals.
I display the professionals profiles in the app but I want to keep the client data secure. I can’t use Row Owners in the User Profiles tab because then I can’t display all of my professionals profiles. If I use Protected columns for emails, for example, then users can’t share any information between users.
So, I’m not sure how to best secure my app…
The only solution I’ve found is to query the User Profiles tab in Excel to have a copy of it and remove any private fields and use the ‘copy’ as the Public Profiles tab.
Is there a better solution here? I would ideally like to have only one User Profiles tab to avoid confusion. If I accidently edit something in the query tab, I lose everything and have to start over…
Would it make sense to create a separate “Professionals” sheet, then use Row Owners on your User Profile sheet? Then, you can create a relation from the Professionals sheet (that is unprotected) to the User Profile sheet, so that the Professionals can still access their protected profiles for editing, but other users would only access the data in the “Professionals” sheet (and their own User Profile).