AnsweredAssumed Answered

Survey123 Using Conditional Calculations to auto-populate fields

Question asked by JHabel09 on Feb 17, 2018
Latest reply on Feb 20, 2020 by Timothy.Flynn_ocfl



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')