Need some help with Document Template Field Mapping - Advanced script

[irene_mascari]

We are trying to automate some forms that our pending Employees need to complete during the Onboarding Process using Document Templates.

We are prepopulating the information that these users have already provided onto the form. 

Several of the forms need the person's Home Address to be populated. 

However, in our set up, the Home Address State field is set up in the sn_hr_core_profile table as a string field with choices. The field label is the full state name, eg. Connecticut. 

I need an Advanced Script to grab the field choice VALUE which is "CT" which is the value I need to display for state on the forms.

Any help with how to do this will be very appreciated. We just have not been able to figure out the correct syntax.