Select to view content in your preferred language

Multi-select returns different statements based on order of selection

299
1
Jump to solution
09-23-2024 07:00 AM
dwold
by
Frequent Contributor

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

 

0 Kudos
1 Solution

Accepted Solutions
abureaux
MVP Frequent Contributor

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.

View solution in original post

1 Reply
abureaux
MVP Frequent Contributor

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.