Thanks for your patience @Kal_Lam
Looking at question 2 below:
Question 2: The app doesn’t currently support the ability to set a form submission URL that goes to a Google Sheet. Can Kobo user servers be set up to automatically forward all the data they gather to a destination URL like a Google Sheet?
If you wish to have your google sheet as your server which stores data go through the discussion that has happened earlier in the community forum . It should help you guide on how to do the same.
I am wondering, it seems the instructions tell us how to use ODK to send form submissions to a Google Sheet, but what we’re looking for is how to send the form submissions already stored inside a KoboCollect server to a Google Sheet. So we submit our KoboCollect form, and its submissions go to the KoboCollect server, and after that, the server forwards the data into a Google Sheet. Is this possible? It seems like maybe the answer is no?
On Question 3 you requested the link be shared please see here: https://kf.kobotoolbox.org/api/v2/collections/
I do have another question, for the sake of continuity I will call it Question 4: If we pull data into other tools from the KoboCollect account, can we also simultaneously erase the data that is being pulled? This is in the context of a repeating data extract which will create cases out of the form submissions when it pulls them out of the KoboCollect account. In order to avoid duplication, we would want to erase the data from Kobo once it’s been extracted.
Thanks for all of your support! it is greatly appreciated
Warmest Regards
Karen
