Hi. Forgive me, I've seen threads with a similar question, however I'm still struggling. I'm on Survey123 3.12 and the survey if primarily accessed via a web browser. here's the gist of it.
Is this in a building?
If yes is selected a .CSV of building names, numbers, and it's location gets pulled:
That .CSV also contains a location field in "+37.75722499_-122.4556317" format.
I want the geopoint to center at the location of the building selected.
If no is selected I want the normal geopoint behavior of the user clicking the location.
I know this is pretty basic stuff. I just can't get it functioning correctly. Thanks.
Solved! Go to Solution.
thanks, yeah, I looked at that and I'm still flummoxed. the "Lookup search against a local file" section is basically what I'm trying to do, but it's actually even more complicated with the concat Lat/Long calculation.
I've just need to pull one X_Y value based on a choice list calculation
Based on the sample I think you need to use 2 columns. No real way to sperate strings in 123.
So have a lat column and a long column and pull them separately. Then use them in the calc of the geopoint. Just follow the image and it should work.
If you can post your form that will help.