Solved: Use and Admin in ONE and the same app, hotfix, hack

So I was waiting for the super team of glide to add somekind of “role” capabilities to the app. Admin role, user role etc. But for the time being I have made a hot fix for this!

Case: You have an email whitelist app and want a user and an admin to use the same app instead of making 2 apps of 1 sheet.
Admins can read and edit
Users can read-only

So i have “news” Items in my app.
A tab in my sheet is called news with =arrayformula(newsadmin!a1:z) in cell a1.
This inserts all the rows from another tab called “News Admin”


  1. Make a new tab in your sheet and add (whitelisted) admin emails to this.! See column C

  2. In your glide app add a inline list in whatever screen and show the admin-spreadsheet-tab BUT in the features of this modules Filter by signed in user en set this to the email column!

Now your module only shows one item for the admin-user with “Admin Home” which you can make it look like a button :man_shrugging:t4:

Then you set up admin home screen with Buttons that go to screens that normal users don’t have access to like the “news admin” screen I’ve set up.

These admin screens items can be edited by users etc etc.
A normal user can never reach admin screens! :ok_hand:


Thank you for using your creativity to encourage people to not depend on Glide so heavily for every little roadblock they encounter.

Everything that we could ever need to do can already be done in google sheets and glide. Its just limited to our imagination. Glad you are thinking outside the box.

I’ve been using this technique with my church app to give ministers a different access than regular member, it works perfectly

Welcome to the other side. (The bright side that is.)

1 Like

Have read some of your comments Mr. Candle, your rough - BUT when your right you are right!

It took me some trial and error but arrived at a similar mechanism. Also, what you say about our ability to do magic on the spreadsheet side is true. Although the new MATH column should be thoroughly studied as it seems flexible enough to allow for the migration of most computational work to the Glide side.

1 Like

Hi, will you possibly share the app. Thanks

Do want to see the app (as a user that is) or look at the glide builder environment

look at the glide builder environment, Thanks

I have made some changes to an even better method. Will post soon. When there some spare time, I will make an app with sample info so I can share it.

Great, Thanks for the effort. I look forward to your posting.

Here’s the app in glide editor to see how I did it. “You can click copy this app”

Have fun


Thanks a lot, truly appreciated.

I kind of got the gist of this and got the “admin” panel to show and hide appropriately. Now I have 6 administrative tabs that I want to hide from the users but allow access to the admins to configure the app. How do I hide those and create buttons to access them or have them pop up when the admin is logged in?

@Herbert_Coleman My post below questions how your are setting up your app, so to add on to that, I’m wondering why you have 6 Admin tabs, when you could probably get away with one. That aside, what you could do is place the admin tab in the side menu, so it’s less obvious, and then set visibility so only show components within that tab based on the user’s authority.

You are mentioning that you created the admin tabs. You can hide them by moving them to the hidden section in the in the tabs section of the builder. However using a button to access them will not give you the layout you already created in each tab. Link to Screen buttons allow for a separate design as compared to a tab. They will both take you to the same sheet, but you can control the look separately within each view.

You can’t control the visibility of a tab based on a user. Any visible tabs will be visible to all users. Like I said, my preference is to put an admin tab in the side menu, or pick a tab in your app and add a button that conditionally shows for admins.

1 Like