topic Re: Displaying multiple note using relevant column in ArcGIS Survey123 Questions

Displaying multiple note using relevant column

dwold — Mon, 22 Apr 2024 13:03:27 GMT

I am trying to get a note to display based on a field name and number of selections. I can get the action to work when one selection is made, but when 2 selections are made it removes the original note and adds the 2 notes I don't want to display. I have been trying different things with in the relevant column but can't seem to get it to work. Any suggestions?

xls:

Form:

single selection working:

2 selections it adds 1 Target Statement and 2 Target Statement:

line 95: relevant statements I've tried using and/or interchangeable:

(${calc_selection}>=1) and (${target} != 'Situational_Briefings' and ${target} != 'Long_Term_Unemployed_and_Underemployed' and ${target} != 'Short_Term_Unemployed_and_Underemployed')

${calc_selection}>=1 and not(${target}='Situational_Briefings' or ${target}='Short_Term_Unemployed_and_Underemployed' or ${target}='Long_Term_Unemployed_and_Underemployed')

${calc_selection}>=1 and not(${target}='Situational_Briefings') or not(${target}='Short_Term_Unemployed_and_Underemployed') or not(${target}='Long_Term_Unemployed_and_Underemployed')

Anything you see I can try differently with my statements? @abureaux @DougBrowning @ChristopherCounsell

Re: Displaying multiple note using relevant column

DougBrowning — Mon, 22 Apr 2024 14:20:44 GMT

Since select multiple stores the data as a comma separated list when you have two values the list is A,B so that means = A cannot work.

Instead you should use selected

selected(question, value)

Checks whether answer is selected. This function is used for select_one and select_multiple questions.

selected(${question_one}, 'a')

See this page for more https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

Re: Displaying multiple note using relevant column

abureaux — Mon, 22 Apr 2024 14:27:01 GMT

Came here to say same thing.

Re: Displaying multiple note using relevant column

dwold — Mon, 22 Apr 2024 15:40:11 GMT

@DougBrowning thank you!!