Dear Community,
I have prepared my XLSForm for a survey and have cascaded some variables and there are some which a long list and want to be selected in a cascading manner. The variables are UniqueID, farmer_name, sex, age and LWD (these are for the respondent). The file I want external data to be selected form is attached (farmer_details.csv) and the XLSForm is also attached. I have read several times on the topic but I am not able to understand. I would like anyone to help me to do this. I greatly appreciate your help in advance.
Regards,
farmer_details.csv (22.8 KB)
farmer_details.csv (22.8 KB)
Baseline Assessment for Promoting a Resilient, Innovative and Equitable Food System Project in Malawi.xlsx (42.8 KB)
@ctmukhala, are you looking to cascade a response from an external CSV file? If so, we would be happy to provide you with some documentation that can assist you in achieving this. If your inquiry is about something else, please feel free to explain in detail.
I have prepared my XLSForm for a survey, where I have included several variables with cascading selections, some of which involve long lists that need to be filtered step by step. The key respondent variables include UniqueID, farmer_name, sex, age, and LWD. I also have an external data file (farmer_details.csv) from which I want to dynamically pull and filter data based on previous selections. Despite reading multiple guides on this topic, I am still having difficulty understanding how to properly implement cascading selections using external CSV data in XLSForm. I would greatly appreciate any guidance or support in helping me set this up correctly.
