topic Re: != In relevant field - Is this still not acceptable in ArcGIS Survey123 Questions

!= In relevant field - Is this still not acceptable

LeonardBarnhill — Thu, 18 Feb 2021 15:24:02 GMT

This question was brought up in 2017, is the use of "not equal" still not acceptable in the Relevant field? I have the statement selected(${StrucDetail} != 'JCT') that generates an error message when the XLSForm is saved:

"Error evaluating field 'StrucDiam': The problem is located in Relevant expression for S{StrucDiam} ... cannot handle function 'selected' requires 2 arguments ...

There is a long list of Choices for the StrucDetail select_one STRUCTYP and this is the only one not needing a diameter .

Suggestions please

Re: != In relevant field - Is this still not acceptable

DougBrowning — Thu, 18 Feb 2021 16:28:58 GMT

First you have the parens in the wrong spot. Should be selected(${StrucDetail}) != 'JCT'. But I think selected returns true. So just selected(${StrucDetail}) may work.

You only really need to use selected for select multiple. Did you try just ${StrucDetail} != 'JCT'?

Hope that helps

Re: != In relevant field - Is this still not acceptable

LeonardBarnhill — Thu, 18 Feb 2021 17:12:28 GMT

The second solution did the trick ... ${StrucDetail} != 'JCT'

Using this format is preferred for select_one queries? I have been using the selected... You can also see the use of parens in the begin group relevant field matched my use of parens in the errant statement. Does the "not equal" expression change how parens should be used? I am just trying to understand the use of parens - this is a constant problem trying to guess when the close parens is after the name field and when it should be after the parameter.

Thanks for your time