topic Automatically populate select_one answer with answer from geopoint pulldata(getvaluesAt) in ArcGIS Survey123 Questions

Automatically populate select_one answer with answer from geopoint pulldata(getvaluesAt)

BaileyBellavance — Tue, 04 Apr 2023 17:46:36 GMT

I made a survey that had been using a static select_one question and choice list to do some calculations based on an external spreadsheet with the pulldata function based on a user input from the choice list for Area. Works great really pleased with it, but the way I have it now, users have to use a separate map to determine the Area they fall into and then input that into the survey themselves.

I was looking to make it more dynamic using a geopoint where the users input their address and using the pulldata("@layer","getValueAt","attributes.name","URL",${location}) pop up with the Area automatically. I got this to work great as well, but when I try to pass this answer to use it in the calculations, I can't. The Area pops up fine on the survey, but it just won't calculate the corresponding questions I had made and the Area is red. The results of the pulldata(getValueAt) from the geopoint will only ever be the choices listed in the list for the select_one question so there won't be any issues because of that.

I'm just wondering if it's possible to use the geopoint results from the intersecting layer to automatically populate the select_one question and have the calculations work on the fly.

Re: Automatically populate select_one answer with answer from geopoint pulldata(getvaluesAt)

DougBrowning — Wed, 05 Apr 2023 04:50:08 GMT

The red means its not in the list. There could be some extra spaces or the case is different always use Paste Values in Excel.

Check out this post https://community.esri.com/t5/arcgis-survey123-questions/why-is-list-name-highlighted-in-red/td-p/756712

and https://community.esri.com/t5/arcgis-survey123-questions/what-does-red-italic-text-mean-when-using-a-custom/td-p/771096

Hope that helps

Re: Automatically populate select_one answer with answer from geopoint pulldata(getvaluesAt)

BaileyBellavance — Wed, 05 Apr 2023 14:34:41 GMT

Thank you! That was it, I was using the label value instead of the name from the choices list. Works great now!