topic Re: Autopopulate a field based on previous question in ArcGIS Survey123 Questions

Autopopulate a field based on previous question

GeoWorld13 — Mon, 09 Mar 2026 02:32:20 GMT

I have a select_one question asking for County. Based on that selection, I want to calculate/assign a Region. I want that Region to be auto-populated based on the County selection.

what I currently have in the calculation cell: pulldata("@choice",'region','name',${jurisdiction})

Survey design and results:

See what I am doing wrong?

@DougBrowning

@jcarlson

Re: Autopopulate a field based on previous question

hmorgan — Mon, 09 Mar 2026 10:04:24 GMT

You’re very close. The issue is that your pulldata() syntax is incorrect for XLSForm. In pulldata(), the second argument must be the column you want returned, not "@choice".

Correct Syntax

Use:

pulldata('region','region','name',${jurisdiction})

Explanation

pulldata('file','column_to_return in the csv','lookup_column in the csv','lookup_value')

So in your case:

file → region (the name of the CSV file without .csv)
column_to_return → region
lookup_column → name
lookup_value → ${jurisdiction}

Meaning: Look in the region.csv file, find the row where name = selected jurisdiction, and return the region value.

Re: Autopopulate a field based on previous question

GeoWorld13 — Mon, 09 Mar 2026 23:29:59 GMT

@hmorgan thanks for the reply! That worked!