Hi @DigitalWarrior,
If you wish to use your google drive (google sheet) as a server, please follow the steps outlined below:
Step 1: Login to your Gmail Account . Then go to Google Drive .
Step 2: Create a new spreadsheet in Google Drive. You could do this by clicking to the New button as shown in the image below.
Then click the Blank spreadsheet .
Change the name of the Untitled spreadsheet .
Once you have done this, you will be able to see a new spreadsheet in your google drive. Here I have renamed my Untitled spreadsheet to Example .
Step 3: We now require a sharable link which needs to be placed under the settings tab of our xlsform that we built. For this, simply right click the spreadsheet that you created in your google drive as shown in the image below.
Copy the link that you see as shown in the image below.
Paste this link under the submission_url of your xlsform (settings tab).
Step 4: You will now need to convert the xlsform to xml form. For this, you could visit the site here to convert your xlsform to xml form. Once converted, click the download XForm as shown in the image.
Step 5: Upload the xml form to your google drive (just next to where your blank spreadsheet is).
Step 6: You will now need to configure your android data collection app. Please note that at the moment KoBoCollect does not support this feature. Hence as an alternative you could use ODK Collect . Press General Settings>Server>Type . Then select
Google Drive, Google Sheets .
Then select Google account and choose a google account for ODK Collect.
Go back and then select Get Blank Form . Select the form and then press Download Selected when done.
You now have a blank form that you pulled from your google drive. Fill it as you normally do with any other forms that you deploy from KoBoToolbox server. Once you complete the data collection, you can send the Finalized Forms to your google drive (google sheet, which acts as your server).
GOOD DAY!
