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!
Solved! Go to Solution.
Opps forgot to attach the excel. It for sure works using the formula above.
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})
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).