ODK Collect with Google Sheets as a server

[@MartijnvandeRijdt-0]

Thanks for this great video! I had no idea this was possible!

[@naiksrinivas6154]

Really a great video. if possible make a full video on using the odk app for a beginner.

[@gentilityjonathan7170]

Pls the GPS location accuracy of the odk collect is not reading ,what should I do?

[@richardfletcher9410]

Hi - it could be something to do with your device: docs.getodk.org/collect-location/ or it could be something to do with how the form has been written: xlsform.org/en/#gps-with-accuracythreshold --- there are quite a lot of posts on the form about GPS as well: forum.getodk.org/t/gps-accuracy-and-accuracythreshold-issues/12645 --- good luck!

[@jordanchamberlin]

very useful! thank you for this! A side question: what Android emulator are you using in the video? I need to get something for virtual trainings of enumerators, etc.

[@richardfletcher9410]

Hi it was a while ago but I am pretty sure it was Vysor - it was an app to display my phone on the PC - I think there is a free and paid version for more features. I suppose an emulator could work as well? Good luck with your project!

[@chanmonyung3379]

Thanks for this great video. I just had a question that I have two forms uploaded into google drive, but when I used ODK application to get the form, ODK application allows me to get only one form. Is it the restriction of that? THanks

[@richardfletcher9410]

Good question, unfortunately I've not tried it with more than 1 form at a time. I assume the forms are both valid, have you tried each one separately from the other? It would be useful for you to let the community know over at the forums forum.getodk.org/ Good luck and thanks!

[@ategekastewart]

Failing to submit filled form to google drive: I successfully added a url but my form can not submit. It says 400 bad request. Message: This operation is not supported for this document

[@richardfletcher9410]

Hi - sorry about your error. I am not 100% sure if this approach still works with the current version of ODK. Ask in the forums: forum.getodk.org/ Good luck

[@findthetruth3021]

Many thanks for this amazing video, but i have a question where did bring this field submission URL? Please tell did you add it in the questionnaire or you added by yourself that would be a great help if you explain this. Please

[@richardfletcher9410]

Hi - I talk about this from about 2m50s in the video - use the "share" link from Google sheets, whatever file you want to be the destination for your results. Now you bring it up - I realized I have missed a step in the guide, to set up this file first. Basically it is just a blank spreadsheet in Google Sheets. Hope that helps

[@Naruto-fi6]

Many many thanks for this great tool

[@rinhoang6629]

I need to add offline maps to ODK collect. you can guide me?

[@richardfletcher9410]

Hi, I think this is possible however my knowledge is a bit out of date now. Try the ODK forums, they're great!

[@FANISITE]

nice informative video. boss i have a question.is there any way around to upload existing data in database and download that data in ODK Collect App for further edit ????

[@richardfletcher9410]

Hi, I don't think ODK Collect does this, but I would look up ODK-X which is based around some similar elements but with more complex/advanced features

[@FANISITE]

@@richardfletcher9410 please let me know about it. Thanks so much for your time and consideration

[@carolinecraig6253]

Wonderful video. However the Start GeoPoint just keep going and going, despite going outside to get a point. Is there any specific setting I should do?

[@richardfletcher9410]

Caroline Craig thanks! Unfortunately I don't know much about the GPS/geopoint features, I've never had the excuse to try them out. If you ask over at the ODK forum maybe someone else will know? forum.opendatakit.org/

[@carolinecraig6253]

Thanks for the reply!

[@briangitonga5784]

Hi @Richard Fletcher. I've just started to use ODK Collect and I have successfully set up my google drive as my server. Thanks for the tutorial. I have 2 questions; 1. How many users can access the google drive at the the same time? 2. Will I have to add the gmail account to all their phones? I would really appreciate a timely reponse

[@richardfletcher9410]

Hi, I'm glad you're finding it useful. I can't see why multiple users would not work - although I haven't tried it myself. 1 login between multiple devices would be my first idea, or perhaps a login per device with all accounts given access/permission to the same google drive/sheet. Possibly if you were simultaneously sending responses very close together but even then if it can't send at one time, you can try again later. As noted in the video this approach is not as fast as other servers. With ODK Collect it saves each response as they are finalized locally to each device. It wont delete until it has confirmed that the data has been transferred, and you can change that option as well if you want. You can even download locally off devices with ODK Briefcase, no connection required.

[@sophyrath9299]

hi i have a problem with KOKO i cannot skip more than one question! Please help1

[@richardfletcher9410]

Hi, do you mean KOBO Toolbox? I am not familiar with that version of ODK. It's probably worth asking in the forums: forum.opendatakit.org/

[@sophyrath9299]

@@richardfletcher9410 Thanks you for your respond! I've found the way now!!

[@DanielAlvaradoOspino]

How can I see the points on a maps?

[@richardfletcher9410]

Hi, sorry I don't know much about the Geopoint or GPS features. You could try asking at the forum: forum.opendatakit.org

[@thatsaneeznb2692]

After the form is filled, I can't send to the google drive. help me with this plz

[@richardfletcher9410]

If you mean in the ODK Collect app, Main menu -> Server Settings -> Type - select Google sheets/drive from there. Not sure if that's what you meant but hope it helps. Also you could ask in: forum.opendatakit.org

[@thatsaneeznb2692]

@@richardfletcher9410 thank u for your repply. I follow this video every step. but the problem is that when I finished answer the form, I couldnt send finalised form to the sheet created in excel. I have no idea why

[@dennisushina7157]

I had the same problem, and my solution was create the blank sheet directly on google drive and no create it on my computer and after upload it on google drive. the problem was fixed.

[@MohamedIbrahimEid]

Hi Richard Fletcher, great tuts, thank you so much. I have a problem on how to convert excel sheet into machine readable form, because the i can find the new domain?

[@richardfletcher9410]

Hi Mohamed thanks for bringing this to my attention, the website has been changed since so I think the new address you are looking for is : getodk.org/xlsform/ I've put it in the description of the video as well

[@eltrukof]

Thanks for the video, but I am having problems to submit the finalized forms to Google drive, I got a 404 error, Im using my account in both sides but the error still even verifying the correct url with permission in gdrive

[@richardfletcher9410]

Hi, sorry about that, have you tried asking in the forum.opendatakit.org - Have you managed to submit other finalized forms to any other types of server (for example the demo aggregate server at opendatakit.appspot.com)

[@genesisbriones2413]

How to add image next to radio button.?

[@richardfletcher9410]

Hi - this would make use of the Media function: xlsform.org/en/#media Here is a post on the ODK forums that solves a similar issue with examples: forum.opendatakit.org/t/adding-small-photo-with-each-answer/9533/10 I don't think I've tried this with Google Sheets specifically, but I can't see why it wouldn't work: when the other route for media files works. Good luck!

[@christianscott7052]

please help to understand more from excel to xlsform

[@richardfletcher9410]

Hi, this video might help: kzbin.info/www/bejne/joHTgIV_hZx-qas Or you could try asking at the forum: forum.opendatakit.org/ Or this site has a very thorough explanation of all the possible XLSFORM options: xlsform.org/en/ Thanks

[@DanielAlvaradoOspino]

xlsform.org/en/#appearance

[@RayAdamsCanada]

choices tab is missing from the video.

[@MotariOngeta]

Great video. best platform for testing surveys

[@kazimmoosvi7518]

Hi Thankyou for the very helpful video. I have one concern, how can we attach data-sets and media files in this method?

[@richardfletcher9410]

Hi Kazim thank you. It does seem to be possible to use media with this method - both media as part of a question (eg images for options) and to send media as an answer (eg take a photo and send it). However if media is important to your use, I would look at setting up ODK Aggregate on Digital Ocean which is the current recommended method if you've never done it before: docs.opendatakit.org/aggregate-digital-ocean/ If you are thinking of something more complex with two way data sync then ODK X may be the more advanced version you need: docs.opendatakit.org/odk-x/ There is also the forum to ask for help: forum.opendatakit.org/

[@rexryanmalbacias6865]

Thank you for this video,I think this ODK is great... I hope I can learn more about it quickly...

[@davidbustospulido3408]

Friend thank you very much, your video helped me a lot. Really thank you

[@richardfletcher9410]

David Bustos Pulido thank you! (and the developers/community!)

[@RolandoBustillo]

Richard thanks this is very helpful

[@kamrannecefov8087]

thanks for great video

[@mfondoumroland]

Really great tutorial

[@Power-ip5bw]

Thx pro. Have a nice day 🌹

[@bernieseville]

Great video!!!

[@subhamraj2500]

Really helpful

[@TechEvs]

Very helpful video but my my form not submission

[@richardfletcher9410]

Hi, you can try asking for help at forum.opendatakit.org

[@hogirmirza9908]

thank you

[@wburke230]

ODK doesn't allow this anymore, and it infuriates me.

[@richardfletcher9410]

Hi thanks for letting me know. I haven't used ODK in a while so I have added a note to the description of the video.

[@tesfahun_taddege]

Good

[@gentilityjonathan7170]

Pls in the ODK collect app the GPS location accuracy is not reading, pls what should I do?

[@monardd8551]

عربي ياليت مترجم