Hello,
I'm trying to filter an external choice list based off of the answer to a previous question. The external choice (caid.csv) list contains the tens of thousands of unique identifying caids associated with either line, point or polygon feature types.
The user needs to be able to select the feature type (select_from featuretype (choices tab on xls form)) and then I need only the caids associated with that feature type selected (either line/point/polygon) appear in the dropdown list from the external caid.csv in the select_from_file caid.csv question type. The external caid.csv (held in the media folder) looks like this below for example.
name | label | featuretype |
111 | 111 | polygon |
112 | 112 | polygon |
113 | 113 | polygon |
4332 | 4332 | line |
4333 | 4333 | line |
4334 | 4334 | line |
43300 | 43300 | point |
I have tried using the following calculation in the select_one_from_file caid.csv question type choice_filter selected($featuretype},featuretype) but it still brings the caids associated with lines even though the featuretype selected is polygon. Any ideas? Thanks.