topic Re: Select One from File Choice Filter in ArcGIS Survey123 Questions

Select One from File Choice Filter

LydiaWerner_MAC — Thu, 21 Apr 2022 19:53:00 GMT

I have an CSV choice list (3000+ records) to select species from for a survey question. I have two questions relating to species: species name and species guild. While the select_one_from_file works fine to select a species name, I am having trouble getting the extra column in my choices list CSV (guild) to populate any data. It returns zero records.

Any help would be appreciated! I've been trying for several hours to get this to work. We have users of this form that don't know the guilds for 3000+ species, so figuring this out would be huge.

Screenshot below shows the choice_filter (far right).

Re: Select One from File Choice Filter

abureaux — Thu, 21 Apr 2022 20:52:38 GMT

This calculation will pull the guild value automatically:

pulldata('speciesguildlist','guild','name',${speciesofanimal})

~~I think I am missing something though. The Species' Guild or Group is the same drop-down as Species of Animal?~~

Edit: Sorry for the delay, my browser wasn't cooperating. I believe I unconfused myself. The reason the original drop-down was blank for you was because of the choice_filter.

If all you need is to pull the data from the guild column when a species selection is made, then I would suggest removing that second drop-down and using a calculate field for that. If you want to display the result for the end-user, you can use a note field to reference that calculate field. See example below:

You may notice that if you add this calculation to your current drop-down that the resulting text is red. That is because it is displaying unexpected text (i.e., text from the guild column). This may cause issues with missing data, hence the suggestion above. Good luck!

Re: Select One from File Choice Filter

LydiaWerner_MAC — Thu, 21 Apr 2022 20:40:07 GMT

Wow, this worked! I am using one choice list with the species' name as the label and the guild as an additional column (each species is part of a guild). Thank you so much!

Re: Select One from File Choice Filter

Anonymous User — Thu, 21 Apr 2022 20:50:11 GMT

Lydia, Would you please post your revised choice list?

Re: Select One from File Choice Filter

LydiaWerner_MAC — Thu, 21 Apr 2022 20:52:12 GMT

@Anonymous User , based on the answer from @abureaux , I didn't change my list at all. I merely used the syntax suggested.

Re: Select One from File Choice Filter

LydiaWerner_MAC — Fri, 22 Apr 2022 18:07:42 GMT

@abureaux This is great! I have now used this in another form and I think this is a great solution for data that I want people to see, but not have to enter. Thank you!