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