nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey123 Using Conditional Calculations to auto-populate fields

JoshHabel

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

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

SueJohnston

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

JohnHasthorpe

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

JoshHabel

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

JohnHasthorpe

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

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.