Input a different value into database for Survey123

[CHedger1227]

Hello All,

I am trying to do something that is different than the norm. I am trying to have my users pick their name from a drop down but have their employee ID populate the backend database. Is there a way to do this?

I am looking to do an  alias of some sort so I can join this to a different table without the people selecting their ID because they do not know it.

Example: (What is selected in the survey - Jane Doe)

                  (What is input into the database - 123)

[DougBrowning]

Take a look at pulldata.  You can have a CSV with the list and do a lookup when they pick their name.

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F35...

Hope that helps

[Katie_Clark]

This seems to me like it good be a good scenario for using the pulldata function? You could have them select their name from the dropdown, and then populate their ID into a new field that would either be a "note" type, or hidden. You could even assign bind::esri:FieldType to Null for the name dropdown so it wouldn't become a field in the schema, if for some reason you only wanted to record the ID.  

[CHedger1227]

This sounds like the way to go thank you I have not used this before thank you for explaining it.

[AndrewBowne · Accepted solution]

If your list of employees is short, you could simply create a select_one choice list.  Use their employee ID in the "NAME" field and use their proper name in the "LABEL" field.  You might find this easier then going the pulldata() route.

Here's a doc that might help:

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformessentials.htm#ESRI_SECTION1_63B0F...

[CHedger1227]

This is exactly what i was looking for thank you!