Survey123 select_one filter by field

[ChristopherMask]

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

[ChristopherMask]

Can I do something like this?

autocomplete search('ResouceRates', 'matches','YearOfRate', ${CalendarYear})

[ChristopherMask · Accepted solution]

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.