topic Re: Help with dropdown list from a CSV file in ArcGIS Survey123 Videos

Help with dropdown list from a CSV file

YenniferCedeño — Tue, 26 Nov 2024 17:29:35 GMT

I am currently creating a form that must be filtered based on the user's login, it does not filter the list and additionally shows me the repeated options and with errors in the representation of the list, that is, the accents are shown with a ? sign.

I have previously worked without problems but lately I have not been able to correct this issue, could you please help me. I am sharing with you what I have so far.

Re: Help with dropdown list from a CSV file

DougBrowning — Tue, 26 Nov 2024 17:44:53 GMT

This means you have special chars in there. These in particular are very common if you copy paste from a PDF. Always use paste values and not just ctrl-v. Always.

One way to fix without starting over is to open the CSV in Notepad. Then you can see the special chars and remove them. Using excel hides all this on you.

Other way is start over and use paste values instead. This often works but not always.

Re: Help with dropdown list from a CSV file

JoseBarrios1 — Wed, 27 Nov 2024 15:50:29 GMT

Saludos YenniferCedeño

The reason that your accents ( and other characters) are shown with a ? sign is because you need to save your .csv file to UTF-8 encoding (see pic below). Also your "search" expression is wrong. It should be: autocomplete search('proyectos','matches','usuario', ${nombre_usuario}).