Auto select from external choice list

[JaredRyan1]

@JamesTedrick @IsmaelChivite,

I'm currently trying to record the County FIPS number for the county returned by our locator (custom in portal) when using reverse geocoding.

The Background:

Currently we have the county FIPS number stored in and exteranal_choices tab our survey123 form, like this:

list_name	name	label	states_territories
county	AL01001	Autauga	AL

So that when the user selects the state_territories, they're given the associated list of counties to select from. We then store the name, in this case the FIPS, for reporting use.

While the state and county questions are populated by a select_one, the address, city, and zip are auto populated via reverse geocoding.

The issue:

My users want to be able to have the state and county fields auto populate just as the address, city, and zip do and not have to select a county or state.

This poses any issue since we're needing to collect the FIPS data and the locator does not provide it (as far as I have found). 

-SO-

Is there a way to auto select the correct FIPS from the external choice list that correlates to the state/county values returned by the locator?

Any pointers will be wildly appreciated!

[ZacharySutherby · Accepted solution]

Hello @JaredRyan1, 

If you are looking for this to be offline you will need a CSV that has what county each zip code is in. Ex.

zip	county	fips	state
92373	San Bernardino	CA06071	CA
92223	Riverside	CA06065	CA

From there you can use a pulldata() function to populate the information. 

If this is an online survey then you can do a point in polygon lookup either using a JavaScript function or the search() appearance. 

[JaredRyan1]

Thank you, Zach! 

I did end up creating a csv with the appropriate data in it, but I was using the "search" appearance. Would a pulldata function be more appropriate here then?

For the pulldata function, I've hosted the csv in or portal and added to the survey's linked content. Then downloaded it from the linked content page in the survey so that the csv and info file were added to the media folder. 

I'm using the follow calc with a positive return:

pulldata('external_choices','name','county',${county_rev_geocode})

Thank you Zach!