Input a different value into database for Survey123

205
5
Jump to solution
01-05-2022 06:16 AM
CHedger1227
New Contributor III

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)

Thank you
0 Kudos
1 Solution

Accepted Solutions
AndrewBowne
Occasional Contributor III

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...

View solution in original post

5 Replies
DougBrowning
MVP Notable Contributor

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

Katherine_Clark
MVP Regular Contributor

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
New Contributor III

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

Thank you
0 Kudos
AndrewBowne
Occasional Contributor III

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
New Contributor III

This is exactly what i was looking for thank you!

Thank you
0 Kudos