Survey123 feature reports: conditional statement if a value has no answer (text)

Question

Hi,

I am trying to do a survey123 report template on word showing only questions with answers.

To show the phone numbers, I used this expression and it worked since the number 0 is written when we don't have the info:

${if phone_number!=0}Phone number : ${phone_number} ${/}

For the email address it did not work since the answer is left blank when we don't know the answer:

${if email!=” ”}Email address : ${email} ${/}

Even though the email answer is blank, the title always shows up.

Anyone knows how to solve this?

DeborahSulzer · Answer

I noticed this is an old thread, and this was the answer I was looking for. I hope someone else will find this helpful.

I have three answers for this one, and I only need the correct one.

Here's my code for the check boxes:

${Performed_BY| selected:"FA"}

${Performed_BY| selected:"CTR"}

${Performed_BY| selected:"Both"}

Here's the code for the X, or you can add whatever text you need.

${if Performed_BY | selected:"FA"} X${/}

${if Performed_BY | selected:"CTR"} X${/}

${if Performed_BY | selected:"Both"} X${/}

@Michelle Williams, the Survey123 Jedi figured this one out.

Vinzafy · Answer

Hey there,

I realize this thread is three years old, but I was coming across the same issue and couldn't find a reliable answer.

Scenario

In a feature report, there is a text question. I want to return the inputs if the text question was answered, otherwise I want to add a custom message if no answer was provided.

Solution

We need to use the not equal (!) operator before the field name in a if statement.

Following that is the syntax for how you want to display the text if the question is answered.

E.g.,

${if !(note_question)}No notes were added for this question.${/}
${note_question| appearance:"multiline"}

If the text question is unanswered, the not equal if statement is true and the custom note is displayed. Though the note question is called, because it's blank, nothing will appear.

If the text question is answered, the not equal if statement is false, the custom note is not displayed, and the value submitted for the note question will display.

Result

Text question is unanswered; custom message appears

Text question is answered; inputted value appears

Jim Moore · Answer

Hi Marie-Joëlle Desgagné

To check if a question has an answer (i.e. is not empty), use the following syntax referring to the field name only (without any operators):

${if email}Email address: ${email}${/}

Please find more info here: Feature report templates—ArcGIS Survey123 | Documentation

Best,

Jim