Autopopulate Geopoint based on select_one

[jfiacco]

Hi,

Does anyone know if there is a way to autopopulate the geopoint question in Survey123 based on the user's selection on the select_one question? 

I'm currently building out a survey for well inspectors and am trying to automate as much as possible. I'd like them to be able to select the well they are inspecting and have the survey populate an address/location in the background based on the well they've selected. I know I can automate the geopoint to collect data based on their location but I'd prefer to use a consistent lat/long from our data to populate points. Is this possible? 

Any help would be greatly appreciated! Thanks 🙂

[jcarlson · Accepted solution]

Yes, it's certainly possible. You'll need to use Survey123 Connect to do it. Check out the documentation for working with external content.

The example given is essentially what you'd want, in which your CSV would have information about the various wells (address, lat, lon, etc) and could pull them based on a selected choice.

Your table "well_details.csv" would look something like this:

Well	Lat	Lon	Address	Status
1	40	72	1232 Main St	Open
2	42	76	836 Clodhopper Ln	Closed

And so on.

Then the fields in your Survey123 form would look like this:

pulldata('well_details', 'Address', 'Well', ${well_id_question})

EDIT: I should mention, if you're trying to populate the geopoint specifically, you will need to concatenate the lat/lon from your CSV.