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; } } }

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

MichaelSlevin

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?

Better Energy Finance.xlsx

Find more posts tagged with

Accepted answers

dougbrowning

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.

All comments

dougbrowning

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.

MichaelSlevin

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)

dougbrowning

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

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.