I have 4 sheets to make an app. One is “client” and One is “staff”. I want to hide the Client tab when the user in the staff sheet sign-in to the app. And hide the staff tab when the user in client sheet to do so. I have used user-profile and RowID to make the data which belongs to the user show on …

This is what you will have to do. Your app can have only 1 user profile sheet. So all your users must be in the same sheet.

In the user profile create a ROLE column. Assign someone “staff” and another person “client” You can then hide the tabs (visibility) based on that data. Staff tab is visible if ROLE = staff etc

I am not in Private Plan, so i cannot set Role column. Is there another solution?

Should I set both client and staff in One sheet then assign them a title in a column for setting the tab visibility condition?

Doesn’t really matter what the column title is. Could call it permissions. Just so long as you have some way of differentiating between staff and clients.

[image] FLT_Limited: Should I set both client and staff in One sheet then assign them a title in a column for setting the tab visibility condition? Yup. You can still keep user data private. As @Manan_Mehta said, all will have to be in the same sheet. There are various options available if y…

OK, let me make all user in one sheet and manage how to work it out. Thank you.

Please be aware that whilst you might be able to “hide” a tab from view, all the related data will still be downloaded to your users devices. So if one of your clients decides that they want to spy on your staff data, there will be nothing you can do to prevent this. The only way to properly secure…

[image] Darren_Murphy: The only way to properly secure data is through the use of Row Owners, which means a paid private plan. Has this changed recently? I am currently building/testing an app which has row owners and is only on the basic plan set to public with email.

oops, I misspoke there. Yes, row owners is available on a free plan. If you want role based security, then you need a paid private plan

How to hide TAB based on user in different sheet

Ask for Help

FLT_Limited February 8, 2021, 9:22am 12

Do you know any way that the user can spy my sheet data that don’t show to their interface?

Topic		Replies	Views
Security info about Hidden tab Ask for Help	16	1585	January 12, 2024
Security with visibility of tabs using css Ask for Help	4	241	March 8, 2021
How to control data access? Ask for Help	15	352	November 25, 2022
Glide Pages - Protect some Pages Ask for Help	8	401	December 28, 2023
User experience different than preview mode Ask for Help	9	412	July 18, 2023

How to hide TAB based on user in different sheet

Related topics