nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Conditionals in Survey 123 Reports

DavidJones19

I found very little in the documentation. What I am trying to do is generate a report and show the questions and answers only if a certain single choice answer is given. I downloaded the template

1. Question text was here?

${field_5}

First I tried

${if field_5=choice1}

1. Question text was here?

${field_5}

${/}

This generated a syntax error. Next I tried

${if field_5|selected:"choice1"}

1. Question text was here?

${field_5}

${/}

and the report seems like it is generating but never gets above 0%.

Najděte více příspěvků označených jako

Accepted answers

All comments

StephenM

Testing if two values are equal should use two equal signs. That may have been why the first conditional gave a syntax error.

erica_poisson

Just curious if you ever figured out a solution to this, as I am having a similar issue. I use the syntax -

${Standing_Location} (${if Corner_Landmarks==“other_sign”}${LD_Other_Sign_Details}${/}

With the example that I'm testing the record has Corner_Landmarks equal to other_sign, and details filled out in LD_Other_Sign_Details, however nothing prints. All I get is the result of the Standing_Location field.

StephenM

I saw that you got a reply in another thread that said this isn't supported, but this worked for me:

In my report template (the selected record has city = "Los Angeles"):

${test_yes_no} (${if city=="Los Angeles"}${time_stamp}${/})
${test_yes_no} (${if city=="San Francisco"}${time_stamp}${/})

Output in the generated report:

No (Oct 5, 2018)
No ()

I thought maybe there could be an issue with field length or something, but I also tested this with a field containing a 450-character description and it worked.

What's the data type of the LD_Other_Sign_Details field?

Edited to add: This looks like the most detailed documentation that discusses this type of conditional statement:

https://community.esri.com/groups/survey123/blog/2018/07/06/bull-release-30

erica_poisson

Hi Stephen,

The LD_Other_Sign_Details field is a text field; this only shows up when the answer to Corner Landmarks (a select multiple question type) is equal to "other_sign". Is your city field a select one question type? Part of me wonders if the fact that my Corner Landmarks question is select multiple is causing this to fail.

But yes - I have received responses say this isn't possible/wont be possible, which is disappointing. I see no difference in our syntax that would cause your statement to work, and mine to fail.

I've also read the https://community.esri.com/groups/survey123/blog/2018/07/06/bull-release-30, which is what led me to believe this was possible in the first place.

Anonymous User

Hi David,

Documentation on conditional if statements in the feature report custom templates can be found here: Feature report templates—Survey123 for ArcGIS | ArcGIS

Regards,

Phil.

ChrisCzerwinski

I was running into a similar issue, and finally figured it out on a "select_one" scenario.
My if statement originally referenced the <Name> value for the choices for a particular question, instead of the <Label>.

${re_inspection_required_by | selected:"site_visit_2"} SITE VISIT #2 (${if re_inspection_required_by=="site_visit_2"}${date_for_re_inspection | format:"MM/DD/YYYY"}${/}) DOESNT WORK

${re_inspection_required_by | selected:"site_visit_2"} SITE VISIT #2 (${if re_inspection_required_by=="SITE VISIT #2"}${date_for_re_inspection | format:"MM/DD/YYYY"}${/}) WORKS!!!

Result:

☑ SITE VISIT #2 (04/26/2019)

OrçunAkkay

Hello Philip, I have an issue with conditional statements. I can use if conditions but the problem is when a field is hidden, the other field which is placed on the next line does not take the place of the hidden field. For example;

Situation 1 Situation 2

Field 1 - when field 1 is hidden, field 2 is placed at the second line
Field 2 - Field 2

Is there any way to prevent it?

Anonymous User

Hi Orcun,

Can you provide a screenshot of how it looks in the form, and also if you can share a copy of your xlsx file that would be very helpful. I just want to make sure what you are describing is what I am thinking, and it is working as expected.

Regards,

Phil.

OrçunAkkay

My excel file is so complicated it has 684 lines but i am sure you can understand the problem from these screenshots. In the first one, "Bina Yapı Belgesi Durumu" is hidden, so other fields are placed on next lines.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.