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!