Survey123 select_one filter by field

Question

Hello Community,

I want to filter select_one_from_file ResourceRates.csv. to the current year, so the appropriate rate can be returned form the linked csv.

Purpose to use the field ${CalendarYear} to filter and only return rates where ${CalendarYear} = ${YearOfRate}.

Is the possible using autocomplete search?

Christopher

OFS - VFD Fire Occurrence Survey.xlsx

ResourceRates.csv

JeffreyThompson2_0-1730232911573.png

Eng.jpg

ChristopherMask · Accepted Answer

set appearance to autocomplete

added this to choice_filter  selected(${CalendarYear},YearOfRate)

This worked and now rates for each year can be added to csv and the survey will filter out based on the year.