I’m a first time Survey123 Connect user and am trying to figure out how to proceed with the following workflow issue. Basically I have xlsform working in a cascading select as follows: survey worksheet Type Name label choice_filter select_one country country What country do you live in? select_one state state What state do you live in? country=${country} select_one duration or other duration How long have you lived in this state? select_multiple cities cities What cities in this state have you lived in? state=${state} So to this point I’m happy with my form, but here I have my issue. I want user to be able to select between 1 and ~10 cities that they have lived in (provided in the choices worksheet) AND THEN have the form generate a table, grid, or similar that will populate one row per city selected in the table, grid or similar with: Name of city Did you live in this city? Related question: Did you like this city? If user selects 1 city, I want 1 row generated with the "Name of city" column populated and the “Did you live in this city?” column shown; if they select 7 cities, I want 7 rows generated with the "Name of city" column populated and the “Did you live in this city?” column shown. This question should also be a mandatory question. Also, I want the related question "Did you like this city?" to only be shown if the answer to “Did you live in this city?” is Yes. Any help is appreciated.
... View more
