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

768
2
Jump to solution
04-04-2023 10:46 AM
BaileyBellavance
New Contributor III

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. 

 

0 Kudos
1 Solution

Accepted Solutions
DougBrowning
MVP Esteemed Contributor

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/75... 

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

Hope that helps

View solution in original post

2 Replies
DougBrowning
MVP Esteemed Contributor

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/75... 

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

Hope that helps

BaileyBellavance
New Contributor III

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