Community
Select to view content in your preferred language

Nested item selection using another variable content in the select_one question

1158
3
10-06-2022 05:48 PM
Status: Closed
Labels (3)
Lucas_Halphen
by
New Contributor II

The idea is to allow the select_one question to take the value of a variable (or the answer given to a previous question).  See the following example:

In the Survey sheet the proposed function capability is select_one ${variable_name}

Lucas_Halphen_0-1665102046369.png

In the choices sheet the value in the list_name table = stores.  The selected value is stored in vendor name as defined in that table.

If the name value is valid one, then it can be used in the next question with the form select_one ${  } or select_multiple ${   }

Lucas_Halphen_1-1665102080074.png

3 Comments
DougBrowning
by MVP Esteemed Contributor
‎10-07-2022 07:00 AM

I was able to do this using select form file then a field that has the calculated value of the csv name. You can also now use the new search appearance like this  

autocomplete search(${SpeciesListName}, "matches", "Plants", "Y")

here the field SpeciesListName is a calc to get the csv name also  ${SpeciesState} + 'LenticSpeciesList'

You would need to make each list a csv but it works.

Hope that helps.

 

Lucas_Halphen
by
‎10-09-2022 08:57 AM

Thanks for the alternate solution