topic Re: how to create a if statement for a report? in ArcGIS Survey123 Questions

how to create a if statement for a report?

JoseBarrios1 — Mon, 05 Jun 2023 18:39:25 GMT

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}${/}

Any suggestions?... Thanks

Re: how to create a if statement for a report?

DougBrowning — Mon, 05 Jun 2023 18:52:49 GMT

try this post

https://community.esri.com/t5/arcgis-survey123-questions/survey123-report-template-if-statement-with-select/td-p/1018695

Re: how to create a if statement for a report?

JoseBarrios1 — Mon, 05 Jun 2023 18:55:21 GMT

Thanks Doug,

I did look at that example, but is not clear to me what was the solution!

Re: how to create a if statement for a report?

DougBrowning — Mon, 05 Jun 2023 19:56:47 GMT

Sorry I do not use it much but it almost looks like there is no else. So if yes do this is all there is. Prob need 2 if statments to simulate a if. Just a guess.

Re: how to create a if statement for a report?

Nicole_Ueberschär — Tue, 06 Jun 2023 08:10:50 GMT

It looks to me like there are blanks around the expression. " otherAssessor " is not the same as "otherAssessor". And then the reports don't have an else option, they only execute if the expression is true and don't if not. If you need an else then as DougBrowning said, you need another if statement that covers the other options (!="otherAssessor").

Regarding the word issue: did you try this yet? https://support.microsoft.com/en-us/topic/how-to-resolve-the-problem-word-experienced-an-error-trying-to-open-the-file-when-opening-a-word-2007-2010-file-easy-fix-article-0903bb9b-d8e4-aabd-0364-f832d26ecff7

Re: how to create a if statement for a report?

JoseBarrios1 — Tue, 06 Jun 2023 15:25:28 GMT

Thank you Nicole and Doug,

I go it to work! As you indicated, I created a second "if" statement to evaluate the "other" option. Thanks once again for your suggestions!

Here is the expression for reference!

${if assessorName == "otherAssessor"}${other_Assessor} - ${assessorName}${/}${if assessorName != "otherAssessor"}${assessorName}${/}

Thanks,

Re: how to create a if statement for a report?

JoseBarrios1 — Thu, 08 Jun 2023 18:56:56 GMT

I forgot to mention that the issue with word not reading the sample template created by survey123 still not working for me. The MS link suggested by Nicole does not work to solve the issue . I still unable to open ANY sample template (individual record or Combined) created by syrvey123.

Re: how to create a if statement for a report?

Nicole_Ueberschär — Fri, 09 Jun 2023 10:38:14 GMT

Sorry to hear that the MS link didn't solve your issue. Do you want to try the attached template? It was only downloaded not further manipulated in word. (It belongs to a quiz in case you wonder about the questions.)

Did you try a different browser yet? Tech support's favorite advise is clearing the cache 😉 Did you try yet to open the file from a different location?

Re: how to create a if statement for a report?

JoseBarrios1 — Fri, 09 Jun 2023 16:53:20 GMT

Thanks Nicole,

The file that you attached opened without any problem! I'm not sure what it is going on with the one I created! I did try to download the file with Chrome and Firefox and from different location.

Re: how to create a if statement for a report?

Nicole_Ueberschär — Fri, 09 Jun 2023 18:01:01 GMT

Really strange. Is it only for this particular survey or is it happening for all surveys? Do you have (by any chance) another subscription where you could try downloading the template?

Re: how to create a if statement for a report?

Nicole_Ueberschär — Fri, 09 Jun 2023 18:01:44 GMT

Are you using ArcGIS Online or Enterprise?

Re: how to create a if statement for a report?

JoseBarrios1 — Fri, 09 Jun 2023 18:18:55 GMT

I'm using ArcGIS online