I am struggling to implement the choice_filter in Connect while referencing a csv file.
As shown below, I have a County question that will then cascade select for the Township question. If I don't have a choice_filter the Townships will show up in my survey, so I know I got the csv linked correctly.But I cannot get it to work with the choice_filter included. My "county" column in the township.csv file is not being recognized. In the screenshot posted, my survey is opened on the left. I have the counties in the Choices tab of the survey since there are only 87 of them. However, since there are thousands of townships I added them to an excel sheet and exported as csv. I have three columns for the csv: 'name', 'label', and 'county'. If I am understanding the below article correctly, then what I have should work, but the article only talks about having all of your choices in the survey or having them all in a linked csv. What I could not find in the article is what the csv is supposed to look like in order to create the "link" between the county selected and the townships displayed.
side note: I only have some of the counties filled in within the townships.csv file because it is going to take some time to reference all of them and I wanted to see if it would work first.
I feel like I am missing something really simple...
This is the article I am working off of: https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-choice-filters/ba-...
Type name label choice_filter
| select_one location_county | location_county | <i>County:</i> | |
| select_one_from_file townships.csv | townships | <i>Township/Unorganized Territory:</i> | selected(${county}, county) |
.png){kind=link}
