Select Choices from an External File | KoBoToolbox | ODK | select_one_from_file
Hello Fellow Aid, Development & Social Data Practitioners!
Do you have tens of thousands of choices in your choice list? OR, do you have a choice-list that keeps getting updated over time, like a list of centers or clinics or water points that have their status updated regularly?
Well, what you might want to consider is using ‘select_one_from_file’ which allows you to put your choice-list for a question in your XLSForm into a separate csv file.
In this video, we’ll look at three things:
How to access the choice-list from within your XLSForm, when you have your choices stored in an external csv file
How to tell your XLSForm what columns your ‘name’ and ‘label’ of all your choices are stored in (if they’re not called ‘name’ and ‘label’)
How to do a ‘vlookup’ from your external csv file, if you want to pull data from your external file back into your form (kind of like the pulldata function).
Can’t wait to hear how you’re using this solution in your own work!
⬇️ You can download FREE XLSForm I use in the video here:
https://humanitariandatasolutions.ac-...
🔗 Link to Documentation: Here are a couple links to the ODK documentation on how to use this feature:
📝 https://docs.getodk.org/form-question...
📝 https://docs.getodk.org/form-datasets...
🔗Link to Forum Discussions: Here are a few Forum Discussion Topics that discuss ideas and challenges on this feature:
💭https://forum.getodk.org/t/proposal-c...
💭https://forum.getodk.org/t/last-saved...
💭https://forum.getodk.org/t/select-one...
🍒 WANT TO JOIN THE HUMANITARIAN DATA SOLUTIONS MAILING LIST?
https://www.humanitariandatasolutions...
✅Interested in enrolling your staff in training courses with Humanitarian Data Solutions? ►
https://www.humanitariandatasolutions...
✅Need help from Humanitarian Data Solutions with a consulting project? ►
https://www.humanitariandatasolutions...
✅ Looking for a Course On “Getting Started in KoBoToolbox?” ► https://humanitariandata.thinkific.co...
If you liked this video, please give it a thumbs up 👍, subscribe, share it with your friends.
✅ SUBSCRIBE TO OUR YOUTUBE CHANNEL:
http://www.youtube.com/c/Humanitarian...
CONNECT WITH HUMANITARIAN DATA SOLUTIONS:
Website: https://www.humanitariandatasolutions...
Email List: https://www.humanitariandatasolutions...
Instagram: / humanidata
YouTube: / humanitariandatasolutions
Linkedin: / humanitarian-data-solutions
Facebook: / humanitariandatasolutions
Twitter: / humanidata