Survey123 : In a Word report template, conditionnaly display a table

Question

Hello,

Is it possible to conditionnaly display a table depending on the answers entered by the user in Survey123 ?

For instance, I would like to be able to display a table with given "water" results if the category "water" has been selected in the Survey123.

If the category "water" has not been selected, then the table is not displayed.

I thought it would work with the following instructions in the word report template, but it doesn't.

${if ((categories | selected: "water"))}

Table with results for the "water" category

${/}

Do you have a solution ? What would be the right instructions to add to the word report template ?

Thanks a lot!

Daniel_Perkins · Answer

Hi @jaimesmith1

You would want to add some fields in your survey to capture which of the select multiple were selected. See this blog for helpful tips: https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-xlsform-functions/

jaimesmith1 · Answer

Hi @Environnement_1Lausanne

Did you find a solution for your problem above?

Thanks in advance

CSDING_GIS · Answer

Hello,

Just a small clarification : in my case the "category" field is a select_multiple. In the template report, I have a table per category that is being filled up with the results of the specific category. I would like the tables for categories that have not been selected on the field, not to be displayed in the final report (built from the report template).

For instance, the user has selected the categories "water" and "air.

The template report has the following structure :

Water table results

Waste table results

Air table results

The final report built from the template should only display :

Water table results

Air table results

What is the nomenclature that should be used for the conditional display of tables in my case ?

Thanks for your help !