4 AWESOME Ways to Use Choice-Filter in your XLSForm
‘Choice-filter’ is a fun little feature in XLSForm that allows you to dynamically change the response-options in a select-one or a select-multiple question type.
Have you ever wanted to ask two select-one questions in a row - with the same option list - but in the second question, exclude the option that was selected in the first question?
Or, have you ever wanted to collect location data using a ‘cascade select’ - where only towns in a selected region are able to be selected, rather than all the towns in your list?
I cover this and more in the tutorial!
⬇️ You can download CHOICE FILTER TEMPLATE XLSForm I use in the video here:
https://humanitariandatasolutions.ac-...
✅ Looking for a Course On “Getting Started in KoBoToolbox?” for your team? ► https://humanitariandata.thinkific.co...
🔗 Link to Documentation: Here’s a link to the ODK/KoBo Documentation on how to use this feature:
Choice-filter:
https://docs.getodk.org/form-logic/#f...
Cascade Select:
https://xlsform.org/en/#cascading-sel...
https://docs.getodk.org/form-datasets...
Form Datasets:
https://docs.getodk.org/form-datasets...
Choice_filter from an external file:
https://xlsform.org/en/#multiple-choi...
🔗 Link to Forum Discussions: Here are a few Forum Discussion Topics that discuss ideas and challenges about connecting ODK to Power BI:
Make a note/title with no space after:
https://forum.getodk.org/t/form-with-...
Skip OR Show selected options in future questions:
Restrict choices already selected from a repeat group: https://community.kobotoolbox.org/t/r...
Ranking importance of a previous question’s answers (multiple answers): https://forum.getodk.org/t/ranking-im...
Filter question options based on previous question: https://forum.getodk.org/t/filter-que...
Filter options to remove previously selected choices: https://forum.getodk.org/t/filter-opt...
Vlookup inside XLSForm:
Reverse Cascading Select:
https://forum.getodk.org/t/reverse-ca...
Loop over pre-established list:
https://forum.getodk.org/t/loop-over-...
Calculate values from extra lookup columns in choices tab:
https://forum.getodk.org/t/calculate-...
Bonus: inside a repeat group! Use choice-filter in a repeat group:
Cascading selects in a repeat group & indexed repeat: https://forum.getodk.org/t/cascading-...
🍒 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...
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