# Update Database from a second Google Sheet
**URL:** https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314
**Category:** Ask for Help
**Created:** [March 9, 2020, 9:25pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314 "2020-03-09T21:25:24Z")
**Posts on this page:** 17
**Page:** 1
### Author:  [@BobbyG77](https://community.glideapps.com/u/BobbyG77)
#### Post date: [March 9, 2020, 9:25pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/1 "2020-03-09T21:25:25Z")
I have an Expense sheet that captures data from users on their smartphones. There are columns in the sheet for values related to “Expense Approved” and “Date of Reimbursement”.
Is there a way to make entries into those columns from a second sheet? I’d prefer not to have the administrators who process expenses making entries in the live data source.
Thanks in advance for any suggestions!
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [March 9, 2020, 9:53pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/2 "2020-03-09T21:53:40Z")
You could periodically use import ranges on both sheets to pull the data from the “live” sheet to the second sheet and the push the data from the second sheet to the live one.
You would import all the rows and columns, except the two you mentioned, in the second sheet. And import those two columns from the second sheet into the live sheet.
The second sheet would be the one that your administrators update those two columns.
Alternatively you could write an app for the administrators, connected to that same live sheet, that would allow them to enter those to values in the live sheet.
---
### Author:  [@BobbyG77](https://community.glideapps.com/u/BobbyG77)
#### Post date: [March 10, 2020, 12:16pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/3 "2020-03-10T12:16:31Z")
Thank you sir. I thought about the second app. Question: If the first app is a Glide Pro app, and the second app is accessing the same sheet, would that have to also be a Pro app?
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [March 10, 2020, 12:25pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/4 "2020-03-10T12:25:58Z")
I assume so based on the fact that you are saying the first one is Pro. I expect over time that you would reach the 500 row limit. However, now that I think about it more, with the recent Glide features of making edit functionality conditional there most likely would be a way of only allowing admins to edit those two columns of data and keep it all within the same app and spreadsheet.
---
### Author:  [@BobbyG77](https://community.glideapps.com/u/BobbyG77)
#### Post date: [March 10, 2020, 12:28pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/5 "2020-03-10T12:28:28Z")
I will explore those admin options on the same app.
---
### Author:  [@BobbyG77](https://community.glideapps.com/u/BobbyG77)
#### Post date: [March 12, 2020, 5:34pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/6 "2020-03-12T17:34:23Z")
George,
Would you happen to know of any video or documentation on how to use the conditional editing functionality that would enable me to set up admins to edit those two columns of data?
Thanks for your help.
---
### Author:  [@BobbyG77](https://community.glideapps.com/u/BobbyG77)
#### Post date: [March 12, 2020, 7:45pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/7 "2020-03-12T19:45:22Z")
George,
I was able to make it work using the conditional editing logic. Thanks again for your help!
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [March 12, 2020, 10:32pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/8 "2020-03-12T22:32:08Z")
I threw together this sample app because I wanted to experiment myself with how to allow different edits by different users within a single app. It took me a bit longer than I expected but I was learning some of the new Glide features along the way.
I believe there are others examples out there that do similar things but again there is a difference in looking at what someone has done and doing it yourself. That said this is not a tutorial but the best way to test this is in the Glide builder.
I would suggest that you change the signed in user a few times to random emails and enter in a few expenses for each.
Then you need to change the signed in user to see the full affect of the admin feature. Start with [one@gmail.com](mailto:one@gmail.com). If you set the signed in user to any of those admin emails the image will show. And when you select it will open to the Reimbursement sheet, which in detail view allows admins record payments. So make a copy of the template and hack away at it.
It is not polished at all, just a sort of proof of concept and starting point to experiment further.
[Edit]
[expensereimburse.glideapp.io](http://expensereimburse.glideapp.io)
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 12, 2020, 11:19pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/9 "2020-03-12T23:19:04Z")
> [@George\_B](#):
>
> I tried to make it a relation so the list could be unlimited but I failed to get that to work.
What kind of problems did you run into?
PS, your link isn’t working.
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [March 12, 2020, 11:55pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/10 "2020-03-12T23:55:30Z")
It works for me in an anonymous browser. [expensereimburse.glideapp.io](http://expensereimburse.glideapp.io)
Interesting. When I changed the link it appeared to stop taking characters at 20 but I had typed more that did not show. When I did the copy link it must have taken the full 24 characters. Oh well it should work now.
What I initially tired was to create a relation to the list of admin emails and then a lookup but when I tried to use either one as my signed in user email column neither column was in the list to select it. Both showed all the emails but it I couldn’t pick the column. I tried it that way because I thought I saw where you used that technique but admittedly I didn’t check out your sample app. Maybe I did something wrong.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 13, 2020, 12:09am UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/11 "2020-03-13T00:09:47Z")
Second link works. It might depend on if you are using a Filter vs Visibility. Filter will use columns from the sheet of the list you are showing. Visibility will use columns from the sheet of the detail record you are currently viewing. I’m guessing you tried to use Visibility. When I add an inline list to Reimbursements, the filter shows the lookup column as an option. If you wanted to used visibility, then I would do the same template-relation-lookup on the home sheet.
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [March 13, 2020, 2:35am UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/12 "2020-03-13T02:35:56Z")
I started trying this without the Home page and just the Reimbursements sheet. My plan was to filter that down by signed in user. But I realized that that was not the best as the regular user would be able to see the Tab but never have any rows to view. So I changed gears and decided on the Home page and never tried the relation and lookup trick to pull in all the admin emails. Anyway thanks for the tip, it’s a bit more streamlined now with a lot less data in the spreadsheet and all relations and lookups in the columns within Glide.
---
### Author:  [@BobbyG77](https://community.glideapps.com/u/BobbyG77)
#### Post date: [March 13, 2020, 1:28pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/13 "2020-03-13T13:28:11Z")
Thanks George. I will check it out.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 13, 2020, 5:52pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/14 "2020-03-13T17:52:01Z")
@Tim_Sullivan I think your expense may be rejected…
---
### Author:  [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)
#### Post date: [March 13, 2020, 5:53pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/15 "2020-03-13T17:53:46Z")
Depends on how progressive the boss is. 😀
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 13, 2020, 5:56pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/16 "2020-03-13T17:56:14Z")
hehe, I guess it depends on the line of work too.
---
### Author:  [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)
#### Post date: [March 13, 2020, 5:57pm UTC](https://community.glideapps.com/t/update-database-from-a-second-google-sheet/5314/17 "2020-03-13T17:57:12Z")
I actually could never get that one through, though, no matter who I said the client was.