Select to view content in your preferred language

how to create a if statement for a report?

2653
11
Jump to solution
06-05-2023 11:39 AM
JoseBarrios1
Frequent Contributor

Hello everyone

I am having hard time creating a report from survey123. First, I'm trying to just get a sample report using the the "individual record" template but it won't open on Word. I'm getting the attached pic error in word.

My second problem is trying to populate on a report the select_one question that have "other" answer.

The formula works in XLSForm but not on the report. It is just a simple "if statement" that record the entry on <other assessor> field if "otherAssessor" is selected on the select_one questions, otherwise <assessorname> is recorded. 

if(selected(${assessorName},'otherAssessor'),${other_Assessor},${assessorName})

 I just realized that the "if" expressions are different for the report but I can't find any examples or documentation. 

I try this but still won't work: 

${if assessorName == " otherAssessor "}${other_Assessor},${assessorName}${/}

 

error.png

 

Any suggestions?... Thanks

0 Kudos
11 Replies
Nicole_Ueberschär
Esri Regular Contributor

Are you using ArcGIS Online or Enterprise?

0 Kudos
JoseBarrios1
Frequent Contributor

I'm using ArcGIS online

0 Kudos