Hi,
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:
Enable user’s login knowing that I have built separate sheets for doctors, assistants etc…
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…
How can I create an Admin to add/edit and delete data from the different sheets.
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.
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.
Before I take the time to jump into this, I was wondering if you ever got this solved yourself or if you had a chance to build a sample sheet that I can use.
Thanks @Jeff_Hager! Unfortunately I was not able to resolve it. I even upgraded my app to pro and still unable to manage. I highly appreciate your assistance.
I’m getting really close on this one. I’m just trying to understand how you are expecting the profile sheet to work. Are those the only values that a user would be allowed to edit? I’m assuming the admin would add records to the Vets sheet, but how would the Profile sheet get populated? I have an idea where the logged in user would create the profile record if they want to override anything that was initially created in the Vets sheet, but I’m still trying to work out how to get the UUID from the vets sheet into the Profile sheet when the user creates a profile record. I think I can probably do it, but it would make the sheets a bit more complicated to link everything together.
I think I can simplify it a lot if I eliminate the Profile sheet and add the Admin (you) to the Vets sheet, but I just wanted to get clarification before I dive in.
Thanks @Jeff_Hager. I think I would go for the Admin (me). Would it be possible to be an Admin on the following sheets Vet,Institutions, VetJobs, OwnPet,Events
Thanks for the efforts.
So, I’m still struggling to understand how the profile tab works and how it’s populated Does it contain only admins and employees? Could it contain customer profiles too??? For now I changed it to only contain administrators and renamed it. I do have the general functionality in place. There is an admin tab that only shows the admin profile and a button to edit all vets if the logged in user has authority. There is a Profile tab which points to Vet-Edit and if the user is in the Vet-Edit sheet, they will be able to edit their own profile. On the About tab and Vets tab, they both show vets from the Vet-ViewOnly sheet and do not allow editing.
Here is what I have so far. Hopefully it’s enough to give you a general idea of how to accomplish what you want. Let me know if you have questions. https://lhxgi.glideapp.io
) cheers