topic Re: Survey123 - Relevant Field based on value from more than one other field. in ArcGIS Survey123 Questions

Survey123 - Relevant Field based on value from more than one other field.

deleted-user-9zlChDJzM-SF — Thu, 03 Aug 2017 03:22:37 GMT

I am trying to create a Relevant statement that would enable a field if a condition is met in one field or if a different condition is met in a separate field. For example:

I want a 'Comment' field to become visible if ${IssueWithThing1} = 'yes' or ${IssueWithThing2} = 'yes'

Right now it gives me an error. Is there a way to make this expression work?

Re: Survey123 - Relevant Field based on value from more than one other field.

Anonymous User — Fri, 04 Aug 2017 00:01:09 GMT

Hi Shawn,

What is the error code you are receiving? The expression you have used is correct, example below:

${issuewiththing1} = 'yes' or ${issuewiththing2} = 'yes'

Regards,

Phil.

Re: Survey123 - Relevant Field based on value from more than one other field.

DanielMcIlroy — Mon, 14 Aug 2017 04:12:13 GMT

I have a related question, I am trying to make multiple values (options) pass the relevant criteria.

My idea was that it would be something like:

${issuewiththing1} = 'yes', 'sortof', 'abit'

or in my case:

${activity} = ('D', 'S', 'R')

where D, S and R are select_one options (five options, relevant question for three of those options)

I really wanted to avoid having to write it as

${activity} = 'D' or ${activity} = 'S' or ${activity} = 'R'

Advice is greatly welcome.

Re: Survey123 - Relevant Field based on value from more than one other field.

JamesTedrick — Sun, 12 Dec 2021 16:59:25 GMT

Hi Dan,

Aside from the length, is there a reason to avoid the last line?

One way you could approach it would be using a regex (Relevant expressions—Survey123 for ArcGIS | ArcGIS 😞

regex(${activity}, "D|S|R")

The | character separates alternatives to check for

Re: Survey123 - Relevant Field based on value from more than one other field.

JevitaWebster — Thu, 22 Mar 2018 21:47:42 GMT

this is sometihng im trying to do also, but i have a list of items 31 possibilities for the vaule i want to be seen or not seen. is there a way to do this so i wont have to type 31 vaules ${myfiled} = 'answer1', 'answser2', 'answer'?

Re: Survey123 - Relevant Field based on value from more than one other field.

Anonymous User — Thu, 22 Mar 2018 23:32:13 GMT

Hi Jevita,

Either way when you are attempting to show relevance of a following question based on 31 previous different answers you will need to type in the values into a calculation. The two options for this are the original way I suggested in this post with "or" statements using the question name and answer if they are from different questions, or as James pointed out, using regex statements when there is more than one value from the same question. Both ways require you having to enter (type) the values into the calculation that you want to be used to make the following question relevant.

Phil.

Re: Survey123 - Relevant Field based on value from more than one other field.

RobertMEIER — Tue, 21 Aug 2018 17:03:23 GMT

Thanks for this!

I was trying to figure out a way to set relevance on parts of a survey by multiple logins and the regex you showed helped me.

regex(${activity}, "D|S|R")

I created a csv:

UserGroup,UserList
City,JackJohnson|JillJohnson
Contractor,MarkSmith|MikeSmith

Then pulled the the user name lists into separate hidden questions:

CityUsers - pulldata('UserInfo','UserList','UserGroup','City')

ContractorUsers - pulldata('UserInfo','UserList','UserGroup','Contractor'')

now in the relevant column I just use this to hide or show based on who is logged in.

regex(property('username'), ${ContractorUsers})

regex(property('username'), ${CityUsers })

I looked for properties for either role or groups for the current user, but is doesn't look like that exists.

-bert

Re: Survey123 - Relevant Field based on value from more than one other field.

DanielMcIlroy — Fri, 24 Aug 2018 01:48:09 GMT

I realised I never actually got back to you on this one James. Yes, it was to just minimise the length. Although the user decided to go in a different direction and we didn't really need to pursue this option anymore.

Also, it reminded me about that old joke "If you have a problem that you need to solve with regex, well now you have two problems!"

Re: Survey123 - Relevant Field based on value from more than one other field.

LiamWhite — Wed, 16 Jan 2019 02:40:08 GMT

Hi Phil, should this method work for a select_one multiple choice question. I am looking to enable a questions based on whether the response to the multiple choice is: "yes" OR "maybe"

Thanks

Re: Survey123 - Relevant Field based on value from more than one other field.

Anonymous User — Wed, 16 Jan 2019 23:06:44 GMT

Hi Liam,

Yes, you can use similar logic for select multiple questions, you may just need to use the select() or contains() expressions to validate if the choices you want to use for the selection have been selected or are contained in the string that is generated when a user selects values in a select multiple. Have a look how the values are stored and then you can work out the way to check if the value you want is selected and then make further questions relevant or not.

Phil.

Re: Survey123 - Relevant Field based on value from more than one other field.

Cartografiae_Cadastro — Tue, 28 Jul 2020 14:32:12 GMT

Hi everybody!
I have a question about multiple selection in relevant.

So, I'm trying to write a expression in my Survey123, where a field has 10 elements, but when to select a previous option, result only 5. Example:

In my setor_relacionado has 5 Options

However, in segmento_ggms has 10 options. But, I would like to select, only, 5 when ggms (name) e Gestão de Geotecnologias e Modelagem do Sistema (label) was selected.

What expression do I have to write?

I trying

if(selected(${setor_relacionado}, 'ggms'), (${segmento_ggms},'Cadastro', 'Geotecnologias', 'PIFS', 'Crescimento_Vegetativo_Modelagem', Gestor'), (${segmento_ggms} = 'Gestor'))

Re: Survey123 - Relevant Field based on value from more than one other field.

Anonymous User — Tue, 28 Jul 2020 23:16:46 GMT

Hi Cartografia,

I don't believe what you are trying to do is supported, you can not filter a select multiple list via expression. The only way to filter a list is using choice filter and cascading selects. However, this is only supported in select one questions and not select multiple. Take a look at: Cascading and external selects—Survey123 for ArcGIS | Documentation .

If you can share your xlsx form file, we can take a look to see if there is a better way to configure and achieve the workflow you are wanting.

Regards,

Phil.

Re: Survey123 - Relevant Field based on value from more than one other field.

CédricVilleneuve — Wed, 18 May 2022 16:25:41 GMT

That last one is funny!!!

Re: Survey123 - Relevant Field based on value from more than one other field.

Anonymous User — Mon, 30 May 2022 03:31:57 GMT

Hi @LiamWhite,

Yes you can use relevant statements based on select multiple questions. You will need to configure your expression to calculate the relevance based on it containing the values or test you are trying to match. Remember the answer to the select multiple will be a comma delaminated string.

Regards,

Phil.