Survey123 autocomplete search on csv

[ChristopherMask]

Hello Community,

Not sure why I can't filter the csv by ResourceType, but could use some assistance if you have time. Attempting to autocomplete search on the ResourceRates.csv by using autocomplete search as seen below.

type

select_one_from_file ResourceRates.csv

appearance

autocomplete search('ResourceRates','matches','ResourceType','Equipment','ResourceType','Equipment')

choice_filter (not sure this matters)

selected(${CalendarYear},YearOfRate)

Christopher

[abureaux]

1. You are using a reserved name in your "name" column. You should change this as it may cause issues:

2. You have several lines in your CSV with empty data. This may cause issues. You should fill in those lines or delete them:

You shouldn't need the search() appearance at all if all you are just filtering a list. Instead, use choice_filter. Your current choice filter is set to a column with all the same data. I.e., If you enter anything other than "2023" you will get nothing. If you enter "2023" you will get everything:

What exactly are you trying to narrow this list down to?

[ChristopherMask]

The list should only show items where YearOfRate = 2023 and ResourceType = Equipment. 

[abureaux]

That makes the filter pretty easy:
selected(${CalendarYear},YearOfRate) and selected(${ResourceType},Resource)

Results in:

It appears that your CalendarYear and ResourceType fields are hidden calculates. If you use this choice_filter for your dropdown and experience any issues, ensure that 1) you have filled in those fields, and 2) those fields are returning the expected data. You can always temporarily show those fields for testing to ensure they are doing what you want (similar to my example above).

[ChristopherMask · Accepted solution]

So, the choice_filter now contains this statement:

selected(${CalendarYear},YearOfRate) and ResourceType = 'Equipment'

That now filters the csv list.

Thanks