Please I need assistance on how to setup KoboCollect to use Google Sheets as a server. I was able to deploy and download xml file from the Google Drive but I could not send finalized forms (completed interview) to Google Sheets. I’ll appreciate any useful guide on how to do this.
Welcome back to the community! Kindly please see the earlier discussions that has happened in the forum (for your reference):
When the setup is run, following error occurs " UiApp has been deprecated. Please use HtmlService instead" . Can someone with developer background edit the script to convert google app UI into html service?
I think my issues is slightly different or I’m still having issues on how to go about it.
Kindly find the error message as attached.
Could you please clarify the following:
Are you trying to use Google Sheets as servers i.e. hosting your entire KoBoToolBox server?
Are you trying to use GoogleSheets to simply get all the data you have/are collecting on KoBoToolBox servers onto it?
If none of the above, could you please clarify what is it exactly you are trying to do so that we look at it
I’d like to know how to do No. 1 and 2 as you clearly indicated.
In that case please see below
For 1: To the best of my knowledge you cannot set google sheets as a server so this options will definately not work.
For 2: You can definately set your data to be pushed to GoogleShests as explained in the discussions
@stephanealoo and @Kal_Lam .
Let me give a try following the instructions.