topic Re: Concat ID from 1 hidden auto response & 1 user input response in ArcGIS Survey123 Questions

Concat ID from 1 hidden auto response & 1 user input response

DanielleGreer — Thu, 07 Jun 2018 04:43:59 GMT

I'm creating a survey for a state historical commission; I need to automatically populate a field to be used for ID creation. I need the "select_one" of the county name (CountyName) to automatically select the corresponding 2 character county abbreviation code (CountyAbbrev). I'm not sure how to make it choose the code once the county name is selected in a way that iI can then concat it into the ID number; I'd like (need, really) to keep the county abbreviation hidden, as well.

I have had success with getting the (CountyName) to create the ID:

concat(${CountyName},'-',${SurveyNum}) becomes CountyName-12345.

I need to be able to have

concat(${CountyAbbrev},'-',${SurveyNum}) becomes CN-12345.

I've not been able to find an answer to this particular situation.

Re: Concat ID from 1 hidden auto response & 1 user input response

JamesTedrick — Thu, 07 Jun 2018 19:44:55 GMT

Hi Danielle,

There are a couple of different ways to accomplish this. The easiest would be to have the name of the county choice list be the county code; the user would see the county name, while you can use the code in the concat function. Alternatively, you could create a lookup table and use pulldata to match based on the county (see Use existing data in your survey - the pulldata( ) function).

Re: Concat ID from 1 hidden auto response & 1 user input response

DanielleGreer — Wed, 13 Jun 2018 15:13:29 GMT

Thank you! That did exactly what I need--without even needing to use the pulldata function!