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.