Relevant rule for multiple choice selection in S123 Connect xls form

Question

Hello,

I am creating a form using Survey123 Connect where I am trying to have the various invasive species questions visible based on a select multiple question that allows the user to select each invasive present at a given site. The goal is to have each group of questions appear based on any combination of the selected species (listed below). There is a group that is acting as a repeat for each species in the list.

So far, I am only able to get one to appear at time despite trying a variety of types of formulas. I apologize in advance since I have seen some similar inquiries to this and have yet to succeed in using some of the tips/suggestions.

Thank you!

Birdvetch

Canadathistle

Commontansy

Narrowleafhawkweed

Orangehawkweed

Oxeyedaisy

Fieldsowthistle

Quackgrass

Reedcanarygrass

Whitesweetclover

Meadowhawkweed

Yellowtoadflax

Waterweed

ZacharySutherby · Accepted Answer

Hello @JacobPearse,

For select_multiple you'll need to use the selected() function to evaluate if a choice was selected. Would you be able to explain what you mean by "various invasive species questions visible" will each invasive species have an associated question?

If that's the case, in the relevant column for each invasive species question you'd use selected(${select_multiple_species}, 'birdvetch') for the Birdvetch invasive species question.

DuncanC · Accepted Answer

Each group is only linked to one checkbox right?  You should just need to use the answer from above the way I read this.

${invasivetypes} = 'Birdvetch'

That fails when your lists becomes 'Birdcetch, anytexthere', now the strings don't match.

selected(${select_multiple_species}, 'birdvetch') instead asks if that list (the data saved in the field for the select_multiple) contains your item, which is does so relevant is flagged and your group should show.

If it's not working try the other variation of label or name, check the capitilization.  It'll be that.

dougbrowning · Accepted Answer

Above is correct.  Cannot use = must use selected since it just a big string.  I would also consider using a repeat instead since having long strings of species in the data makes it really hard to use going forward.