topic Re: Creating a conditional statement in ArcGIS Survey123 Questions

Creating a conditional statement

CaseyRagain — Tue, 22 Aug 2017 21:57:47 GMT

Hello, I'm having trouble with how to write a 'relevant' conditional statement based the answers to previous fields. Here is some background information.

I have 5 fields:

NEEDED, type - select_one, choices - yes or no
CORNER_TYPE, type - select_one, choices - CD, IT, D, ID, CS, I
RAMP1
RAMP2
RAMP3

My conditional statement is:

When the field Needed is Yes, ramp fields are enabled/disabled based on the Corner_Type:

If Corner_Type is CD (Continuous Double) or ID (Island Double), Ramp1 and Ramp2 fields are enabled.
If Corner_Type is D (Diagonal) then only Ramp1 is enabled.
If Corner_Type is IT (Island Triple) or I (Incomplete) then all ramps are enabled.
If Corner_Type is CS (Continuous Single) then all ramps are enabled

Is it possible to write out all of the above scenarios in just one function?

Thank you in advance.

Casey

Re: Creating a conditional statement

RalphBeishline — Wed, 23 Aug 2017 16:00:14 GMT

Can you confirm that bullet point three and four are both meant to say 'enabled'?

If so, I'd try this and see if it works as you need.

name	relevant
RAMP1	${NEEDED}='yes'
RAMP2	${NEEDED}='yes' and ${CORNER_TYPE}!='D'
RAMP3	${NEEDED}='yes' and ${CORNER_TYPE}!='D' and ${CORNER_TYPE}!='CD'

If bullet three or four is meant to disable all RAMPs, just add another ${CORNER_TYPE}!=

Re: Creating a conditional statement

JamesTedrick — Wed, 23 Aug 2017 20:18:36 GMT

Small modification - RAMP3 also needs

and ${CORNER_TYPE}!= 'ID'

RAMP3 could also be expressed by the valid values (as there are 3 valid values and 3 invalid values); this is the pattern I would use if the number of invalid values is larger than the number of valid values:

${NEEDED}='yes' and (${CORNER_TYPE}='IT' or ${CORNER_TYPE}='CS' or ${CORNER_TYPE}='I')

Re: Creating a conditional statement

deleted-user-qzyyiYme1rz9 — Fri, 25 Aug 2017 18:47:37 GMT

James's reply is one way to do it. Here is another approach. Both should work for you.