Thanks Pierre, your script works great!
The only issue I’ve found is when the Kobo form contains repeated groups of questions. In this case, only the first group of responses for each individual record gets imported into the Google Sheet like this:
When I export the XLS file from the Kobo website, however, each group is given its own tab. Do you think it could be possible to replicate this in the Google Sheets script as well?
Thanks again!
Peter
···
On Monday, August 28, 2017 at 10:15:16 AM UTC-3, Pierre Grandidier wrote:
Dear Ahmed,
I am glad that the Kobo-GSheet synch is working on your side. It is also working for me.
You can easily set up some automated time based triggers on any Google script. I have set up mine to update every 5 minutes.
Please follow this link which describes it well:
https://www.quora.com/How-can-I-periodically-run-a-Google-Script-on-a-Spreadsheet
I hope this helps!
Pierre
Le lundi 28 août 2017 12:06:59 UTC+2, Ahmed Hassan a écrit :
Dear All,
I tested Kobotoolbox sync with google sheet and it was worked, but Manually,
I mean((You must click on the Kobotoolbox button and then click on the entry then “Select the survey(s) to import” then choose “Import data into which sheet?” finally “Import survey data” for update the data from Kobo to excel sheet)).
But, I need automatically, do you have any ways
