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.
