topic Re: Survey123 Using Conditional Calculations to auto-populate fields in ArcGIS Survey123 Questions

Survey123 Using Conditional Calculations to auto-populate fields

JoshHabel — Sat, 17 Feb 2018 15:24:44 GMT

Hello,

I am working on a utility pole inspection form that will have multiple questions and am trying to figure a way to create a shortcut field (Quick_Pick) that will auto populate these questions when either everything is Okay or they cannot inspect the pole while still allowing them to choose other answers if needed. So far I have the following questions setup. Both fields are select_one type with their corresponding choice lists.

Field Name Choices

Quick_Pick "OK" or "No Inspect"

Pole_Condition "OK" or null

Ive been hacking around trying to create a calculation on the Pole_Condition field without any success. Below is my latest failed attempt. Is what I'm trying to do even possible and if so what am I doing wrong? Any help would be appreciated!

if(selected(${Quick_Pick},'OK'),'OK', or selected(${Quick_Pick}, 'No_Inspect'), 'null')

Josh

Re: Survey123 Using Conditional Calculations to auto-populate fields

JohnathanHasthorpe — Sun, 18 Feb 2018 12:17:01 GMT

Hi Josh

If I understand you correctly - you want to update pole_condition based on the answer in quick_pick. If so then the following should work:

if(selected(${Quick_Pick},'ok'),'OK', if(selected(${Quick_Pick},'no_inspect'),'null', ''))

- if you select OK in quick_pick then we will select ok in pole_condition

- else if you select no_inspect in quick_pick then we will select null in pole_condition

- else we return nothing

Note that 'null' would be a choice in your list in the above.

I hope this helps

Thanks

John

Re: Survey123 Using Conditional Calculations to auto-populate fields

JoshHabel — Sun, 18 Feb 2018 18:40:16 GMT

John,

Unfortunately that did not work either. The only way i can get it to work is to turn the field with the calculate statement into a "text" field which of course defeats my purpose.

Josh

Re: Survey123 Using Conditional Calculations to auto-populate fields

JohnathanHasthorpe — Mon, 19 Feb 2018 23:47:37 GMT

Hi Josh

Sorry - I should have mentioned that calculations in select_one questions are not currently supported. The good news is that they will be at 2.7 and you can test the functionality out in the Early Adopter Community now.

Thanks

John

Re: Survey123 Using Conditional Calculations to auto-populate fields

SueJohnston — Fri, 20 Apr 2018 20:05:53 GMT

Hi John,

I'm working with version 2.7.72 now and i'm unable to get my calculation on a select_one to work. I want my select_one to pick "Not Started" if any of my other questions = "yes". i had this working as a hidden text field no problem, but we'd like to update this status field after the initial survey is collected. I haven't been able to find an example of how to accomplish this, i hope you can help.
Thanks!
Sue

Re: Survey123 Using Conditional Calculations to auto-populate fields

JohnathanHasthorpe — Tue, 24 Apr 2018 03:37:14 GMT

Hi Sue

Please see attached

Thanks

John

Re: Survey123 Using Conditional Calculations to auto-populate fields

SueJohnston — Tue, 24 Apr 2018 13:26:26 GMT

Thanks Johnathan, I was able to get this to work!

Re: Survey123 Using Conditional Calculations to auto-populate fields

TimFlynn — Fri, 14 Feb 2020 18:20:13 GMT

Is it possible to use multiple questions to auto fill a question? I've got a couple of inspection forms where it will say something along the lines of, "A 'No' to any of questions 1-5 results in a Failed inspection." I'm using Survey123 Connect version 2.4.6 (not able to upgrade without admin approval). I've got it set up as a select one and for right now that's fine, but if I can automate out any human error that would be great.

Would something like this work? I'm not sure how to add multiple conditions.

if(selected(${Q1}and${Q2}and${Q3}and${Q4}and${Q5},'Yes'),'Pass', if(selected(${Q1}or${Q2}or${Q3}or${Q4}or${Q5},'No'),'Fail', ''))

Thanks!

Re: Survey123 Using Conditional Calculations to auto-populate fields

JamesTedrick — Wed, 19 Feb 2020 22:05:54 GMT

Hi Tim,

Each question should be evaluated in their own selected() function and joined. In your case, if you want Q1-5 to be 'Yes', you do not need the second set of evaluations:

if(selected(${Q1}, 'Yes') and selected(${Q2}, 'Yes') and selected(${Q3}, 'Yes') and selected(${Q4}, 'Yes') and selected(${Q5},'Yes'), 'Pass', 'Fail')

Re: Survey123 Using Conditional Calculations to auto-populate fields

TimFlynn — Thu, 20 Feb 2020 12:06:02 GMT

James this worked perfectly, thank you!

Re: Survey123 Using Conditional Calculations to auto-populate fields

JohnWatson_EBA — Tue, 10 Mar 2020 16:03:18 GMT

James, I'm not sure if this goes here in this thread, but...I am trying to use an if statement for a calculation but I don't know if it will work. I have a calculate field that adds up all the other calculated fields. But not all calc fields will be filled in, these are set up with the relevant field. My calc field will work in my survey if I select everything in my select multiple, then the calcs all run, but how do I get it to run the calc even if fields are not selected, or filled in? So if I select 3 out 4 in my select multiple question, then calculate those values, the last calc field will not run. I need to select all 4. I want the option to run it with everything or anything selected and filled in. And I am not sure how to do that.