nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

ResourceRates.csv

OFS - Wildfire Reporting Tool.xlsx

BoatRide.zip

kml_arrows.png

SierraNevada_1-1730314594006.png

SierraNevada_0-1730314550557.png

Find more posts tagged with

Accepted answers

ChristopherMask

So, the choice_filter now contains this statement:

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

That now filters the csv list.

Thanks

All comments

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

So, the choice_filter now contains this statement:

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

That now filters the csv list.

Thanks

ChristopherMask

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

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.