topic Survey123 autocomplete search on csv in ArcGIS Survey123 Questions

Survey123 autocomplete search on csv

ChristopherMask — Wed, 25 Oct 2023 16:43:35 GMT

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

Re: Survey123 autocomplete search on csv

abureaux — Wed, 25 Oct 2023 18:42:58 GMT

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?

Re: Survey123 autocomplete search on csv

ChristopherMask — Wed, 25 Oct 2023 18:49:41 GMT

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

Re: Survey123 autocomplete search on csv

ChristopherMask — Wed, 25 Oct 2023 18:54:42 GMT

So, the choice_filter now contains this statement:

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

That now filters the csv list.

Thanks

Re: Survey123 autocomplete search on csv

abureaux — Wed, 25 Oct 2023 18:58:15 GMT

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).