topic Re: How Do I Apply A Rule In The Relevant Column When Using Select_Multiple? in ArcGIS Survey123 Questions

How Do I Apply A Rule In The Relevant Column When Using Select_Multiple?

MichaelSlevin — Fri, 13 Sep 2019 15:09:06 GMT

Afternoon

I am building an inspection form on Survey 123 Connect and, depending on the answer to the question, an option should appear prompting the inspector to take a photo.

For example, when answering a question, our inspector is presented with four options:

Pass

Fail#1 - Broken

Fail#2 - Missing

Fail#3 - On Fire

This is configured in the "Type" column as a "select multiple".

I have managed to get it, so that if our inspector selects one of the fails, the photo prompt appears. However, as soon as multiple fails are selected then the photo prompt disappears - it should instead present photo prompts for all three fails?

Re: How Do I Apply A Rule In The Relevant Column When Using Select_Multiple?

DougBrowning — Mon, 16 Sep 2019 19:32:32 GMT

You can use or in a relevant. So field=1 or field=2.

Re: How Do I Apply A Rule In The Relevant Column When Using Select_Multiple?

MichaelSlevin — Tue, 17 Sep 2019 11:58:23 GMT

Yeah tried that but it hasn't worked.

The problem with using "Or", I think, is that it doesn't take account of the possibility of "And".

There are eight possible answers (see below) for an inspector to the question example above; am I just to type the eight possible answers into the Relevant cell using "Or"? Seems like there should be a simpler solution.

1. Pass (no photo prompt)

2. Fail#1 (fail 1 photo prompt)

3. Fail#2 (fail 2 photo prompt)

4. Fail#3 (fail 3 photo prompt)

5. Fail#1 and Fail#2 (fail 1 photo prompt and fail 2 photo prompt)

6. Fail#1 and Fail#3 (fail 1 photo prompt and fail 3 photo prompt)

7. Fail#2 and Fail#3 (fail 2 photo prompt and fail 3 photo prompt)

8. Fail#1, Fail#2 and Fail#3 (fail 1 photo prompt, fail 2 photo prompt and fail 3 photo prompt)

Re: How Do I Apply A Rule In The Relevant Column When Using Select_Multiple?

DougBrowning — Tue, 17 Sep 2019 16:11:01 GMT

Sorry missed that it is a select multiple. For those you have to use the selected function

selected(${Customers},'Other')

And yes you would have to write out all the or statements. Unless you can use a != or not selected somehow.