Select to view content in your preferred language

Limiting possible responses with select_one_from_file

185
3
07-08-2025 08:33 AM
ClaireSavage
New Contributor
Hi everyone!
I am developing a Survey123 form for our team to conduct plant surveys.  The surveys are done at several different parks and the protocol differs a bit between them, so I had decided the best thing for us would be to create a survey for each park (I'm sure I could make it all one survey, it just makes me nervous to have only one more complex survey plus the team would prefer to not have to select park ID over and over). The species data comes from a linked csv as it is pretty large and it needs to be easily edited. Ideally, the survey will guide users towards species that are present at that park to avoid typos. Additionally, some questions are about woody species while others are for non-woody species and I would like to constrain responses based on the Lifeform column in our csv. I am dreaming of using just one csv of species names for all the surveys rather than making a separate csv for each park and life form.  I haven't found a way to do this yet though, is it possible? The closest tool I have found is choice filters, but it seems this must reference previous questions/responses rather than columns from the datasheet. 
 
I have attached a sample of the data. The parks are represented by all the columns after Lifeform. To get a list of species that are present at a certain park I was planning on excluding 'NP'. I am writing the survey on connect and it will be accessed via the Survey123 app on a tablet or smartphone.
 
Thanks!
0 Kudos
3 Replies
Neal_t_k
Frequent Contributor

choice filters would be the correct path for this. 

An example for the choice filter for one of your parks would be

ARCH != 'NP'

You would then just hard code the choice filter based on the park and corresponding column in your CSV.

ClaireSavage
New Contributor

Thanks for your response Neal. Could you explain what you mean by hard coding?

0 Kudos
Neal_t_k
Frequent Contributor

This (ARCH != 'NP') doesn't pull any information from fields in your form, i.e. it is not a variable, but static text i.e. hard coded.   You would just change the 4 letter park code corresponding to your column headers in your csv. for in each survey.

0 Kudos