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

[learningasigo]

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!

[Ratslinger]

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.