topic How to populate a field from external select (external_choice) in ArcGIS Survey123 Questions

How to populate a field from external select (external_choice)

JoseBarrios1 — Wed, 25 Aug 2021 06:23:10 GMT

Hello Everyone,

I want to use external select to capture information from a large list (2,000) containing species name and other attributes. My question is... How could I pull the values from the external_choice sheet(tab) to populate a note or a text fields in my form using cascade select? I was able to get the species name using the choice_filter but I am confuse on how it works. I could not found any examples of how to use external select to pull data or populate other fields. Here is a pic of what I am trying to accomplish and a sample of my XLSForm. The form will be used on Web App only. Thanks for any help or suggestions!

Re: How to populate a field from external select (external_choice)

DougBrowning — Wed, 25 Aug 2021 14:48:00 GMT

Check out the bible page it has all you need. https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

For your form the example for Authority would be. Note external choice just creates a csv called itemsets in the media folder but you can now have this as an csv in the media folder and use select_one_from_file instead BUT not sure that works in the web yet.

pulldata('itemsets', 'Authority', 'name', ${sp_namexxx})

Re: How to populate a field from external select (external_choice)

JoseBarrios1 — Wed, 25 Aug 2021 20:27:26 GMT

Hi Doug,

Thanks for your suggestions. I did try the pulldata function as you suggested but it did not work for me. Unfortunately, the "bible" page does not have anything on external select or using external_choices sheet ( not a csv list).

Re: How to populate a field from external select (external_choice)

DougBrowning — Wed, 25 Aug 2021 21:00:51 GMT

Opps forgot to attach the excel. It for sure works using the formula above.