AnsweredAssumed Answered

Survey123 Using Conditional Calculations to auto-populate fields

Question asked by JHabel09 on Feb 17, 2018
Latest reply on Apr 24, 2018 by Suej

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

Outcomes