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”
Steps:
Make a new tab in your sheet and add (whitelisted) admin emails to this.! See column C
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
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.)
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.
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.
