Ask Your Question

How do I use Google docs to store / access my Base database?

asked 2017-08-23 00:48:54 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am developing a database for a half dozen users across the country. We do NOT have a dedicated server. How do I a) save my database to Google docs, and b) make it available to the other users to read and update? thanks

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted

answered 2017-08-23 08:39:25 +0100

morsed2 gravatar image

updated 2017-08-23 08:49:22 +0100

With less than, say, 10 users and the type of database you want, why not use Google Sheets?

I use Excel, Libre Office Sheets, and Google sheets for many of my databases.

Sorry if this does not answer your question, but consider it another approach to the problem.


edit flag offensive delete link more

answered 2017-08-23 12:12:37 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

OK...that may work. But my question is, how do I point to Google sheets from Base? When I look at "file location" I don't see a way to get to it.

edit flag offensive delete link more

answered 2017-09-03 04:44:32 +0100

Ratslinger gravatar image

Only recently have I installed & tested Dropbox. This is similar to Google drive but I veered away from that because you must use a third party client for Linux, none of which on the surface seem very good to me.

For Base you would need to have a synced folder on the computer. Once the necessary client software is installed (Google or DropBox), you simply copy your DB (entire folder if split DB) into the synced folder and work from there. In Dropbox (fairly certain Google also) backups are also created. Kind of nice.

In your case of sharing, there is an additional problem with other users. No matter how you set this up, only one person at a time can be updating the database, you need to share the files, and each must have a synced folder. For more information on the sharing part, this post may be helpful to you - click here.

edit flag offensive delete link more

answered 2019-02-09 22:13:51 +0100

goedible gravatar image

I have the same question. How can I collaborate with others online using my database? I have an "availability" table that I would like others to be able to add information to. Currently I have it set up so that they can add info to the Google Sheet doc, then I have to copy it and paste it into my database , replacing the old one. The ID is not automatic and they have to scroll to the end of the entries to add their data.

edit flag offensive delete link more



Please do not use an answer to post a question. Answers are to respond to original question.

Additionally, my answer in this post covers what you mention. If this is not enough, please post as a new question and provide specifics - concerns, specific LO version, database used, etc.

Ratslinger gravatar imageRatslinger ( 2019-02-09 22:26:40 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-23 00:48:54 +0100

Seen: 931 times

Last updated: Feb 09 '19