Filtered Kobo Matrix List using Uploaded CSV Data

[ELIJAHKIMANI]

I want to build a dynamic kobo question matrix. I have a large list of choices that I have uploaded in an external csv file to help render the question matrix.
I also have a select dropdown that I intend to use to filter the questions that will appear in the kobo question matrix created.

1. Is there a way to set the value of a kobo--matrix_list to reference the list uploaded in the.csv file?
2. Can the value of kobo--matrix_list be dynamic in such a way that the data from the uploaded .csv file can be filtered based on the value selected in the dropdown before rendering the matrix?

[Kal_Lam]

Welcome to the community, @ELIJAHKIMANI! Maybe this post discussed previously should help you solve your issue:

How to designing a cascading select question (choice filter) within a matrix question?

Hi @rholdorp, Welcome to the community! Would you mind having a look at the workaround that i have tried out. It should solve your issue: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] In the settings tab of your xlsform: [Image 3] Data entry screen as seen in Enketo: [Image 4] Reference xlsform: Matrix Questions with Cascading Selects.xls (49.5 KB) Have a great day!

[ELIJAHKIMANI]

Hi @Kal_Lam
I did review the above solution
However, i have over 1000 questions to work with and typing them all and adding the relevant column to conditionally render them did prove very inefficient

Is there another alternative?

The ideal solution for me would be to upload the csv file with the list of questions and have a function to filter and pull data and populate the kobo--matrix_list

[Kal_Lam]

@ELIJAHKIMANI, if you have a long list of choices you could integrate this approach in the approach mentioned above:

Cascading Limitation

@dimesh, seems like you have a lot of choices in your cascading select option. Please be informed that in such cases you will need to use the external CSV to list the choices. You could overcome this limitation as outlined in the post discussed previously (using the select_one_from_file question type): Alternatively, you could also overcome this issue by using the select_one_external question type as outlined in the post discussed previously: