topic Re: Using an IF statement in calculations in ArcGIS Survey123 Questions

Using an IF statement in calculations

CamKenny2 — Tue, 21 Nov 2023 18:00:42 GMT

I have a select one question in my survey and depending on which one is selected, I'd like to present the user a message.

I have created a text field where I am performing a calculation using an IF statement.

The trouble is, I would like to use a BUT, but I don't know what the syntax is for that - even if it is possible.

if(${header_mode}='new' and ${Flight_Status}='Post-Flight','You must complete the Pre-Flight Checklist before selecting Post-Flight','Please complete the Pre-Flight Checklist in its entirety') BUT (if(${header_mode}='edit' and ${Flight_Status}='Pre-Flight','The Pre-Flight Checklist has been completed, please complete the Post-Flight Checklist',''))

The first part of the IF statement works, but when I edit an existing survey, it doesn't execute the second IF statement.

Re: Using an IF statement in calculations

DougBrowning — Tue, 21 Nov 2023 18:18:33 GMT

I think the easiest way is to just make 2 different note fields. One for each side of the but. Have you tried that?

Re: Using an IF statement in calculations

rwrenner_esri — Tue, 21 Nov 2023 22:04:11 GMT

I'll second what Doug said, although if you want to do everything in a single field you could use or as the operator.

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_276FB773E7E2442EB81831714B08660D