Ask Your Question
0

Can I create a 'shared' database for my small team that connects to Google Sheets as the source?

asked 2018-05-25 17:51:55 +0200

learningasigo gravatar image

I work on a small team of 3 people (myself included) and I am trying to build a database to track serial numbers for our products, as well as a few other things. We don't have an internal server or dedicated database, and rely on Google Sheets a lot. I am wondering if I can create a database that I can share with my team and they can access the database source through the front end (Base).

What I had in mind was setting up a database that connects directly to Google Sheets on my laptop. When I have the database front end completed in Base I can send the file to my team, set up the connection to Google Sheets on their machine, and then we can all access Google Sheets through the database.

Would something like this actually work?

Can I edit information in Google Sheets via the LibreOffice Base application I make? i.e., will any changes any of us make while we are in the database be synced with Google Sheets and we can all view the changes?

If I create this, can my team access the database at the same time and make changes to the Google Sheet? We would all have the 'same' database in LibreOffice Base because I would create it and share it with the team, but they would access Google Sheets from their own computer. Google Sheets allows multiple people to edit and change the document at the same time.

We are all using Mac.

Thanks!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-05-25 19:30:15 +0200

Ratslinger gravatar image

Hello,

Don't know of any method to connect to Google Sheets from Base. While Base has the ability to use data from a spreadsheet, this is a local setup. There have been instances of using Base on Google Drive. This does also require careful attention to who is doing what with the database and when. In other words it is not for multi-user processing. For this you would need a database server and a completely different approach.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-25 17:51:55 +0200

Seen: 106 times

Last updated: May 25 '18