topic Re: Autocomplete with one column in ArcGIS Survey123 Questions

Autocomplete with one column

EvanDarpini — Thu, 13 Apr 2023 19:07:07 GMT

I currently have a csv file attached to my survey that lists plant species. I have a select_one plant name with the calculation pulldata('USDA Plant Database common name', 'ScientificName', 'ScientificName', 'enter_name1') and appearance autocomplete

The Csv file contains an enormous amount of choices all from one column called scientific name. I want to avoid puttin each choice in the choices sheet of the Survey file. Is there anyway i can make the choices pulldata from the csv or do the choices have to be input into the survey?

All i want is as field tech input the name suggestions drop down for what they are looking for

ex: Royal

autopopulates: Royal Palm, Royal Poinciena, ect.

Re: Autocomplete with one column

EvanDarpini — Thu, 13 Apr 2023 19:32:59 GMT

okay i just copied the list into two columns no big deal. What i am actually looking for is how to setup and external choice list. I have seen it requires a select_one_from_file questions but that is not fuctioning on my current worksheet

Re: Autocomplete with one column

DougBrowning — Thu, 13 Apr 2023 19:46:12 GMT

My species list is over 60,000 to get all 11 states. Here is how I do it.

First I break it out by state since different plants may be woody or not for example and to only show plants that would be in that state. These all go in the media folder.

In the form I have a State list that they can pick or it passes in from Field Maps. I then do a calc field to create the csv name I need.
${SpeciesState} + 'LenticSpeciesList'

Then I use the newer search appearance to grab the correct state list like this in the appearance column. This loads after they pick a state only so the form loads fast.

autocomplete search(${SpeciesListName}, "matches", "Plants", "Y")

In my CSV I have the code as the name and in the label I have Code Scientific Name Common Name (4 spaces in-between each). This way a crew can search on anything they know and find the right plant. Code, Scientific, Common are all interchangeable. Each user knows plants differently so this is great.

Also what is cool if they say know its a willow they can just type willow and it shows them the options for that state.

Each state is close to 12,000 in the list and it is lighting fast.

I can also do things like only show them the woody plants

autocomplete search(${SpeciesListName}, 'matches', 'Type', 'Woody')

We only store the code in the data then our backend SDE has a lookup table with all the above if anyone needs it. This way we can adjust Indicators and all that by state with varying growth habits, etc.

I have species, LPI, Gap, forms and all of that if you want them DM me for the process to share.

Hope that helps it has been a big win for us. In another project we have smaller lists so I have a image for each choice even.

Re: Autocomplete with one column

EvanDarpini — Thu, 13 Apr 2023 21:11:55 GMT

I appreciate you so much you are extremely quick with the help and are all over this board. I have one more question. I have it autopoluating the names perfectly. The next question after refers to status. on the csv file i have the status of the plant in the 3rd column next to the names. how do i make my status question autopopulate based on the name typed in the previous answer. please see below for example of csv file.

Abildgaardiaovata

Abildgaardia ovata

Re: Autocomplete with one column

DougBrowning — Fri, 14 Apr 2023 13:50:37 GMT

You can do a pulldata on that csv. This is a different form but same way. Just give it the csv name and the species as the lookup on the name column.

pulldata("PFCSpeciesList", "StabilityClass", "name", ${Species})

(csvname, column to return, lookup column, lookup value)

Re: Autocomplete with one column

EvanDarpini — Fri, 14 Apr 2023 16:42:08 GMT

You are the man. Cheers