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 OR Statements in the Choice Filter

DarrenSchouls

Hi there,

I am currently putting a survey together using cascading selects and the choice filter. Everything works great until I tried to include an "OR" statement in a choice filter. The syntax I have been trying is below:

WetlandClass=${WetlandClass} and WetlandForm=${WetlandForm} and (WetlandAcidity=${WetlandAcidity} or WetlandPermanence=${WetlandPermanence})

Does the choice filter support OR statements? And if so could you provide an example of the syntax.

Thanks for your help,

Darren

Find more posts tagged with

Accepted answers

All comments

JamesTedrick

Hi Darren,

OR is supported in a choice filter - see the sample attached. You may need to check to make sure the combination of your statements make sense with the values selected.

CountyCascadeOrTest.xlsx

DarrenSchouls

Hi James,

Is it possible that the filter struggles when there are several AND statements as well as an OR statement? Everything works fine when I have 3 AND statements but as soon as I try to add the OR statement near the end several options for questions do not appear. Again the syntax in my choice filter is below:

WetlandClass=${WetlandClass} and WetlandForm=${WetlandForm} and WetlandAcidity=${WetlandAcidity} or WetlandPermanence=${WetlandPermanence}

JamesTedrick

Your statement is possibly ambiguous; normally with a mixture of AND and OR you need to use parentheses to make the order of operations clear. It would be helpful to see the combinations of choices and values to figure out if the logic is doing what you want.

DarrenSchouls

Hi James,

I have attached the XLS sheet for my survey. The issue is occurring on line 23 when the Salinity question is being asked. I added brackets into the statement within the Choice Filter but when I test the form the options that should appear for the "Wetland Salinity" field remain hidden. All of the choices are within the choices sheet, not the external choices sheet.

Essentially what I need the form to do is:

- If "Bog" or "Fen" is chosen for the "Wetland Class" field then the "Wetland Acidity" field will appear. Based on the answers to the "Wetland Form" and "Wetland Acidity" the appropriate options for the "Salinity" field should appear.

- If "Marsh", "Shallow Open Water" or "Swamp" are chosen for the "Wetland Class" then the "Wetland Permanence" field will appear. Based on the answers to the "Wetland Form" and "Wetland Permanence" the options for the 'Salinity" field will appear.

So far everything works as it should except that the options for the Salinity field just never appear. As soon as I get rid of the OR statement and only have 3 dependencies in the Choice Filter the options will appear in the Salinity field but only if all three questions in the Choice Filter are answered. I realize it might be a pain to test all this but any help would be greatly appreciated!

Thanks

WetlandAssess_V01.xlsx

JhoanUrquia

Hi James,

The IF statement is supported too? Im triyng to do a choice filter depending on the previous question. The column used for the choice filter would be conditioned.

Thnks a lot

JyotiRohodia

Same question! @JamesTedrick

Any inputs would be appreciated.

Thanks,

Jyoti

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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