Survey123 Connect - Populate a text field when only specific choices are selected from multiple questions

DarrenLloyd__DOIT

My goal is to create an “Additional Cost” field that populates choices from various questions throughout the survey. Basically, a submitter will select question choices and only specific choices will populate in the “Additional Cost” field. I got this to work when I only reference one field in the calculation column. However, there are multiple fields I would like to bring.

The expression below works and the ArcGIS_Developer_Subscription text is placed in the “Additional Cost” field.

• if(${ent_specialty_lic}='ArcGIS_Developer_Subscription', "ArcGIS_Developer_Subscription", " ")

However, I cannot find a way to use multiple IF statements. Here are examples of other choices I would like to bring in to the “Additional Cost” field.

• if(${ent_additional_portal_products}='ArcGIS_Insights', "ArcGIS_Insights", " ")
• if(${singleuse_pro_ext}='ArcGIS_Aviation_Airports_for_Pro', "ArcGIS_Aviation_Airports_for_Pro", " ")

Any help would be greatly appreciated and welcomed.

JA7

That is how if statements work, once one of the statements evaluate to true, it stops. You likely want to set up multiple temporary fields to do each if statement separately and then combine them into a single field. 

 

multi select.xlsx