ODK Collect with Google Sheets as a server

แชร์
ฝัง
  • เผยแพร่เมื่อ 11 พ.ย. 2024

ความคิดเห็น • 62

  • @MartijnvandeRijdt-0
    @MartijnvandeRijdt-0 6 ปีที่แล้ว +4

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

  • @Naruto-fi6
    @Naruto-fi6 3 ปีที่แล้ว +1

    Many many thanks for this great tool

  • @naiksrinivas6154
    @naiksrinivas6154 3 ปีที่แล้ว +1

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

  • @gentilityjonathan7170
    @gentilityjonathan7170 4 ปีที่แล้ว +1

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

    • @richardfletcher9410
      @richardfletcher9410  4 ปีที่แล้ว

      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!

  • @MotariOngeta
    @MotariOngeta 6 ปีที่แล้ว +1

    Great video. best platform for testing surveys

  • @ategekastewart
    @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
      @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

  • @chanmonyung3379
    @chanmonyung3379 3 ปีที่แล้ว +1

    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
      @richardfletcher9410  3 ปีที่แล้ว

      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!

  • @RolandoBustillo
    @RolandoBustillo 6 ปีที่แล้ว +1

    Richard thanks this is very helpful

  • @davidbustospulido3408
    @davidbustospulido3408 6 ปีที่แล้ว +1

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

    • @richardfletcher9410
      @richardfletcher9410  6 ปีที่แล้ว

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

  • @kamrannecefov8087
    @kamrannecefov8087 3 ปีที่แล้ว +1

    thanks for great video

  • @rinhoang6629
    @rinhoang6629 2 ปีที่แล้ว

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

    • @richardfletcher9410
      @richardfletcher9410  2 ปีที่แล้ว

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

  • @Power-ip5bw
    @Power-ip5bw 4 ปีที่แล้ว +1

    Thx pro. Have a nice day 🌹

  • @findthetruth3021
    @findthetruth3021 4 ปีที่แล้ว +1

    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
      @richardfletcher9410  4 ปีที่แล้ว

      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

  • @briangitonga5784
    @briangitonga5784 4 ปีที่แล้ว +1

    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
      @richardfletcher9410  4 ปีที่แล้ว

      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.

  • @mfondoumroland
    @mfondoumroland 5 ปีที่แล้ว +2

    Really great tutorial

  • @carolinecraig6253
    @carolinecraig6253 6 ปีที่แล้ว +2

    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
      @richardfletcher9410  6 ปีที่แล้ว +2

      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
      @carolinecraig6253 6 ปีที่แล้ว

      Thanks for the reply!

  • @sophyrath9299
    @sophyrath9299 5 ปีที่แล้ว +1

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

    • @richardfletcher9410
      @richardfletcher9410  5 ปีที่แล้ว

      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
      @sophyrath9299 5 ปีที่แล้ว

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

  • @DanielAlvaradoOspino
    @DanielAlvaradoOspino 6 ปีที่แล้ว +2

    How can I see the points on a maps?

    • @richardfletcher9410
      @richardfletcher9410  6 ปีที่แล้ว

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

  • @eltrukof
    @eltrukof 5 ปีที่แล้ว +1

    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
      @richardfletcher9410  5 ปีที่แล้ว

      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)

  • @jordanchamberlin
    @jordanchamberlin 3 ปีที่แล้ว +1

    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
      @richardfletcher9410  3 ปีที่แล้ว

      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!

  • @FANISITE
    @FANISITE 5 ปีที่แล้ว +1

    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
      @richardfletcher9410  5 ปีที่แล้ว +1

      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
      @FANISITE 5 ปีที่แล้ว +1

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

  • @thatsaneeznb2692
    @thatsaneeznb2692 6 ปีที่แล้ว +1

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

    • @richardfletcher9410
      @richardfletcher9410  6 ปีที่แล้ว

      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
      @thatsaneeznb2692 6 ปีที่แล้ว

      @@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
      @dennisushina7157 5 ปีที่แล้ว

      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.

  • @bernieseville
    @bernieseville 6 ปีที่แล้ว +2

    Great video!!!

  • @genesisbriones2413
    @genesisbriones2413 5 ปีที่แล้ว +1

    How to add image next to radio button.?

    • @richardfletcher9410
      @richardfletcher9410  5 ปีที่แล้ว

      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!

  • @MohamedIbrahimEid
    @MohamedIbrahimEid 4 ปีที่แล้ว

    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
      @richardfletcher9410  4 ปีที่แล้ว

      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

  • @subhamraj2500
    @subhamraj2500 5 ปีที่แล้ว +1

    Really helpful

  • @christianscott7052
    @christianscott7052 6 ปีที่แล้ว +1

    please help to understand more from excel to xlsform

    • @richardfletcher9410
      @richardfletcher9410  6 ปีที่แล้ว

      Hi, this video might help: th-cam.com/video/XPpORIP7KsI/w-d-xo.html
      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
      @DanielAlvaradoOspino 6 ปีที่แล้ว

      xlsform.org/en/#appearance

    • @RayAdamsCanada
      @RayAdamsCanada 5 ปีที่แล้ว

      choices tab is missing from the video.

  • @kazimmoosvi7518
    @kazimmoosvi7518 4 ปีที่แล้ว

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

    • @richardfletcher9410
      @richardfletcher9410  4 ปีที่แล้ว

      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
      @rexryanmalbacias6865 4 ปีที่แล้ว +1

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

  • @wburke230
    @wburke230 9 หลายเดือนก่อน

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

    • @richardfletcher9410
      @richardfletcher9410  8 หลายเดือนก่อน

      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.

  • @hogirmirza9908
    @hogirmirza9908 6 ปีที่แล้ว +1

    thank you

  • @TechEvs
    @TechEvs 5 ปีที่แล้ว

    Very helpful video but my my form not submission

    • @richardfletcher9410
      @richardfletcher9410  5 ปีที่แล้ว

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

  • @tesfahun_taddege
    @tesfahun_taddege 6 ปีที่แล้ว

    Good

    • @gentilityjonathan7170
      @gentilityjonathan7170 4 ปีที่แล้ว

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

  • @monardd8551
    @monardd8551 3 ปีที่แล้ว

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