I have a multi-select question that returns different statements based on the order of the the selection. That is not the intended outcome I am looking for (I want the user to be able to select in any order and return the correct target statement) but I am having issues allowing the user to select choices in any order and getting the correct statements to display.
Correct statements when selecting top to bottom:
dwold_0-1727099071436.png
dwold_1-1727099084199.png
Bottom to top selection (Reopening Business is selected first)
dwold_2-1727099165063.png
Selecting Reopening Business then Long_Term unemployement
dwold_3-1727099420246.png
I have attached my form and the pulldata table I am using
Solved! Go to Solution.
That is the expected outcome for what you have set-up.
In the file attached, these notes are showing the text:
abureaux_0-1727206276145.png
And those calculates are here:
abureaux_1-1727206314030.png
These calculates will 100% be different based on what order you selected items. That is how selected-at() works.
As for how to fix... I'm not sure off-hand. You have a surprising amount of things going on for such a small form. I feel like it could be streamlined a little.
That is the expected outcome for what you have set-up.
In the file attached, these notes are showing the text:
abureaux_0-1727206276145.png
And those calculates are here:
abureaux_1-1727206314030.png
These calculates will 100% be different based on what order you selected items. That is how selected-at() works.
As for how to fix... I'm not sure off-hand. You have a surprising amount of things going on for such a small form. I feel like it could be streamlined a little.