Hello!
There's a question in our survey where we ask participants "From the following list of buyers, to which ones do you sell conventional agricultural products?"
Then, follow up with a question asking them "Of the buyers you mentioned, which ones are the most important?"
How can I do that? To be able to select (one or multiple) of the choices selected in the previous question. (Right now I just have the same list re-appear, not only the buyers selected)
I created a document with this question only in case it is easier to show me in it directly, and here is a screenshot of the two questions:
And the choices tab:
Here's the excel sheet:
Buyers.xlsx (9.2 KB)
Thank you very much! I appreciate your help.
Bana
If you're using the same list, and want the second question to only show options that were selected in the first question you can use add a choice_filter column with a value of selected(${buyers},name) for the second question. More details in this forum thread about Choice filter with multiple selection.
Note, that there is a rank widget that might be useful for your survey (details in the ODK docs and XLSForm docs).
Thank you so much @danbjoseph. Very helpful as usual!
Hello Dan,
I have a follow up question on this. The question right after "Of the buyers you mentioned, which ones are the most important?" is: "Of the most important buyers that you answered in the previous question, how satisfied are you with the sale with each buyer?" And the answer option is a "select_one" from a list: "Very satisfied, satisfied, not satisfied, very unsatisfied"
I am attaching the file with the third question for your reference.
My question is: how do I have that 3rd question repeated but for only the choices selected in the previous question?
Thank you x 1 million! I really appreciate your help.
Bana
Buyers.xlsx (9.6 KB)
Be sure to use an underscore in the column header... choice_filter
For the third question, you could use a repeat but it can be tricky to implement (see Repeat recipes and tips) and the data analysis will be more difficult - as the results from the repeats will be saved to a separate spreadsheet.
If there are not a very large number of buyers, you can create a satisfaction question for each one and only show the ones necessary using relevant.
Example: Buyers_satisfaction.xlsx (10.2 KB)
This is great, this way makes a lot of sense. I appreciate your help @danbjoseph, thanks!
Bana
1 Like
