Admin Account & User login

I was introduced to Glide a week back by a friend of mine. I started to learn about Glide and frankly I could not stop. So, I decided to create my first app using glide while being inspired by the posted
showcases in the forum.

My first app is an online directory of Doctors, Assistants, pharmacies, Medical schools etc. With each of these categories has its own sheet that contains name and email . My questions are how to:

  1. Enable user’s login knowing that I have built separate sheets for doctors, assistants etc…
  2. Once a user login, the user can only edit/update their own data based on their email found in one of those sheets, eg. Doctos, Assistants etc…
  3. How can I create an Admin to add/edit and delete data from the different sheets.

Thanks for your assistant

I’m going under the assumption that each category would different types of data in each one. Otherwise I would recommend joining everything into one sheet.

I would first create duplicates of each sheet and use a formula to populate each one from it’s respective primary sheet. Using those duplicated sheets, I would create a tab for each one. These tabs would be set to view only. I assume you would want everybody to view the data on each tab.

Next I would create a Profile Tab in the menu. This tab could point to a placeholder sheet with an unused column heading. Then place a button for each category and use Link to Screen to link to each Primary category sheet. (Alternately, you could create an inline list to each category and filter on per user data. I think lists will only show if there are matching items, but I think it might show ‘no items’ as a placeholder.) Here you can turn on Per User Data and and Editing to allow the logged in user to make changes to only their own record.

Next create a Admin sheet with the Names and Emails of Admins. Also add a column and fill it with ‘Admin’ on each of the rows. Next on each category sheet, create a column and also fill it with Admin. You could use the Template column in the data editor to do this. Create an Admin tab in the menu. This admin tab will point to the Admin sheet. You can use Per User Data here if you want each Admin to only edit their own record. in the Details for each Admin, you could create a List Relation for each category that uses a relation you create on the Admin sheet to the Admin column on each Category sheet. This will provide access for the Admin to edit all records.

If I’m thinking correctly, this should allow for all the situations you are looking for.

Wow Jeff, what a reply. Can’t take it all in…you should knock up a demo (if you have time and can be bothered :slight_smile: ) cheers

Thanks @Jeff_Hager for addressing my request and for providing the solution / workaround. You are correct to assume that each sheet would have different types of data. I think I understand the concept but not sure how to implement using Glide as I am still exploring all its possibilities. Would a demo be possible if not too much to ask?

I’ll keep a bookmark on this thread. I have a lot going on the rest of the month, so I’m not sure when I can throw together a demo. @Rogelio, if you could put together a sample spreadsheet with some fake data that I can copy, that would help me a lot.

An idea