topic Re: Auto populate non-relevant questions in ArcGIS Survey123 Questions

Auto populate non-relevant questions

DiegoBrenes1 — Wed, 27 Jul 2022 17:19:38 GMT

Hello

I am looking for a way to mark or highlight non-relevant fields in the results or report of a questionnaire. For example, that in the report, if a question is not relevant, that field shows a text saying "Response not required" (if the non-relevance applies).

I need something like this so that the reviewers of a questionnaire can easily identify non-relevant fields and know that they were not just left empty by the data collector.

Any ideas on how I can achieve this?

Thank you

Diego

Re: Auto populate non-relevant questions

TroyGerhardt1 — Wed, 27 Jul 2022 17:43:21 GMT

Maybe some if/then statements in the report? Check out the thread and links here Survey123: Report Template if then statements - Esri Community

Re: Auto populate non-relevant questions

TL2 — Wed, 27 Jul 2022 21:59:16 GMT

I would create a note field with the same title. If the item is relevant, it will appear and if the item is not relevant the note will appear (with a default answer); make the null fields.

Re: Auto populate non-relevant questions

DiegoBrenes1 — Fri, 29 Jul 2022 17:43:24 GMT

Thank you. I partly solved this with the following statement in the report:

${green_loan_env}

${if especial_credit | selected:“copeval”} Not required ${/}

However, my relevant expressions are more complex than one single operation and I could not figure how to include AND and OR on those expressions. For example, I tried the following with an AND expression, but it didn't work:

${permisos_licencia_amb1}

${if especial_credit | selected: “emerg_ecu_banana2022” and cert | selected:“yes”} Not required ${/}

Any advice on how to incorporate that AND on the expression?