How to construct a "not in list"-type expression

Question

I'm trying to construct an expression for the body::esri:visible column to hide a question group if the response to a previous question is one of several possible values. First the user selects a Facility Profile from a select_one question. Then if that selected Facility Profile is 5, 6, 7, or 8, then hide a question group. (These values are actually text strings in my survey)

I can get ${FacilityProfile}!='5' to work, but how can I make an expression along the lines of ${FacilityProfile} not in ('5'.'6','7','8') to work?

DanielRaleigh · Answer

Have you investigated Cascading Select?

I haven't used the body::esri:visible column option, but I use Cascading Select for one of my projects. Within that form, the workflow proceeds in this fashion:

If I choose Option A, I want to see SubOptions 1, 2, 3

If I choose Option B, I want to see SubOptions 4, 5, 6, 7

If I choose Option C, I want to see SubOptions 8, 9    (etc.)

...further down the form, I prompt specific questions to appear or disappear based on the initial "Option" choice, and can even specify if I want a question to appear if OptionA/2 was selected, but not if OptionA/3 was chosen, for instance.

If that might be helpful to you, please let me know and we can try to connect on this topic.

BrianHall7 · Answer

Yes, I suppose I could use 'or' between the expression elements. I'm facing some pretty huge expressions, so I was hoping to shorted them a bit.

BarbaraWebster1 · Answer

Hi @BrianHall7,

You could write each body::esri:visible expression separated by an 'and' operator. For example:

${FacilityProfile}!='5' and ${FacilityProfile}!='6' and ${FacilityProfile}!='7' and ${FacilityProfile}!='8'

- Barbara