# Dynamically loaded multiple-choice data with Google Drive **URL:** \ **Category:** Support\ **Tags:** odk-collect\ **Created:** [October 31, 2017, 4:45am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404 "2017-10-31T04:45:11Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![mariaplaying](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/4491bb/32.png) [@mariaplaying](https://forum.getodk.org/u/mariaplaying)\ **Post date:** [October 31, 2017, 4:45am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/1 "2017-10-31T04:45:11Z")
Issue: I'm using ODK with Google Drive/Sheets as described here. I would like to create multiple, conditional select lists / dropdowns (e.g., state --\> city) using an externally pulled-in CSV. I don't know how to get my smartphone to "find" the CSV file and pull it in. Right now I have it sitting in the same directory as the XML on Google Drive. The XML is pulled in but not the CSV. I have also tried putting it in a directory, [XML]-media. The ODK running on my phone doesn't seem to see it and pull it in. Here is one of the more complicated examples I have tried: [https://opendatakit.org/downloads/download-info/sample-searchandselect-form/](https://opendatakit.org/downloads/download-info/sample-searchandselect-form/) I set up my stuff using this short tutorial: [http://macbio-pacific.info/wp-content/uploads/2017/06/ODK\_Google\_Documentation.pdf](http://macbio-pacific.info/wp-content/uploads/2017/06/ODK_Google_Documentation.pdf) ---
**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\ **Post date:** [November 2, 2017, 10:12pm UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/2 "2017-11-02T22:12:34Z")
Hi @mariaplaying. I haven't tried this feature in a while, but this sounds like a bug to me. @Grzesiek2010, can you take a look at this one and try to reproduce it with the form at [https://opendatakit.org/downloads/download-info/sample-searchandselect-form](https://opendatakit.org/downloads/download-info/sample-searchandselect-form). My guess is that there is something odd about the form title/name or maybe CSVs aren't downloaded, but other media types are? Oh, and Maria, when you get a chance, please [introduce yourself here](https://forum.getodk.org/t/-/6671). I'd also encourage you to add a real picture as your avatar because it helps build community! ---
**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\ **Post date:** [November 3, 2017, 11:48am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/3 "2017-11-03T11:48:40Z")
The form itself works well but I can confirm that we are not able to download media files using GD. This option is just not implemented. Looking at the code we just download an xml file. I reported this issue [https://github.com/opendatakit/collect/issues/1591](https://github.com/opendatakit/collect/issues/1591) ---
**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\ **Post date:** [November 7, 2017, 5:32am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/4 "2017-11-07T05:32:46Z")
@mariaplaying Please try your form with Collect v1.11.1 now available in the Play Store. This should fix the issue. Thanks, @Grzesiek2010! ---
**Author:** ![mariaplaying](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/4491bb/32.png) [@mariaplaying](https://forum.getodk.org/u/mariaplaying)\ **Post date:** [November 16, 2017, 1:03am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/5 "2017-11-16T01:03:55Z")
Hello, Helene. Thanks for the note. I'll give it a try on Collect v1.11.1 but I'm not sure where to place the file and how to name it so that it is picked up. Second, it seems this feature has not been implemented (per Grzesiek2010 and yanokwa) and their notes on [github.com](http://github.com). So, shall I give the new version of Collect a try or wait to hear from the Bithub folks? ---
**Author:** ![mariaplaying](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/4491bb/32.png) [@mariaplaying](https://forum.getodk.org/u/mariaplaying)\ **Post date:** [November 16, 2017, 1:10am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/6 "2017-11-16T01:10:15Z")
Hello there, yanokwa. Nice to meet you. I believe I have put an introduction in the right place. Thanks for the response and for tackling this issue. I'll keep an eye on bithub for a solution. Please let me know if it is simply a matter of upgrading Collect. ---
**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\ **Post date:** [November 16, 2017, 1:18am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/7 "2017-11-16T01:18:37Z")
It's just a matter of upgrading to v1.11.1. Once you do that, put `form.xml` and `form-media/my-file.csv` on your Google Drive. Then when you download `form.xml`, it will automatically download all the media files in the `form-media` folder. ---
**Author:** ![mariaplaying](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/4491bb/32.png) [@mariaplaying](https://forum.getodk.org/u/mariaplaying)\ **Post date:** [November 17, 2017, 12:08am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/8 "2017-11-17T00:08:15Z")
Great news! I'll give it a try. Thanks! ---
**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\ **Post date:** [April 24, 2018, 11:54pm UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/9 "2018-04-24T23:54:14Z")
A post was split to a new topic: [Select one text and image from loaded csv](https://forum.getodk.org/t/select-one-text-and-image-from-loaded-csv/12833) ---
**Author:** ![pdineshraj](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/pdineshraj/32/5221_2.png) [@pdineshraj](https://forum.getodk.org/u/pdineshraj)\ **Post date:** [October 29, 2019, 3:14am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/10 "2019-10-29T03:14:27Z")
@yanokwa and @mariaplaying **I am trying to pull data while using ODK with google drive. Is there any video which can help me set it up? or a detailed document?** Thanks in advance. ---
**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\ **Post date:** [October 29, 2019, 8:30am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/11 "2019-10-29T08:30:36Z")
You can try this video [https://www.youtube.com/watch?v=GnXwGmhaI9U](https://www.youtube.com/watch?v=GnXwGmhaI9U) ---
**Author:** ![pdineshraj](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/pdineshraj/32/5221_2.png) [@pdineshraj](https://forum.getodk.org/u/pdineshraj)\ **Post date:** [November 14, 2019, 6:34am UTC](https://forum.getodk.org/t/dynamically-loaded-multiple-choice-data-with-google-drive/10404/12 "2019-11-14T06:34:30Z")
Thank you @Grzesiek2010 One of the best resource for starting with ODK and Google Drive.