I would like to display multiple values on my forms based on the selected choices from a list.
There are a lot of values to display depending on each item in the list. Potentially I can have more than 20 values per list item
Currently I am proceeding automatically. I feed my list by concatenating my different values from the “Project” sheet in the value of the item separated by “;” (see “Project” sheet and “choices” sheet).
To retrieve the value, I do a “substring” in the “Survey” sheet (see cell “k4”, “k5”, “k6”, “k7”, “k8”).
My question is to know if there is not an easier solution to achieve this.
Sorry, I’m a new user, I can’t upload my xlsform. I will post it as soon as possible.
For this moment, i give you the enketo form url : https://ee.humanitarianresponse.info/preview/NqhczkDG