topic Re: Input a different value into database for Survey123 in ArcGIS Survey123 Questions

Input a different value into database for Survey123

CHedger1227 — Wed, 05 Jan 2022 14:16:08 GMT

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)

Re: Input a different value into database for Survey123

DougBrowning — Wed, 05 Jan 2022 15:05:29 GMT

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_A3C2F3566F974734B55ECECD31C6CA91

Hope that helps

Re: Input a different value into database for Survey123

Katie_Clark — Wed, 05 Jan 2022 15:06:04 GMT

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.

Re: Input a different value into database for Survey123

CHedger1227 — Wed, 05 Jan 2022 15:22:15 GMT

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

Re: Input a different value into database for Survey123

Andrew-Bowne — Wed, 05 Jan 2022 15:47:57 GMT

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_63B0F9AA1A05458BB4B86F2A1A05AA78

Re: Input a different value into database for Survey123

CHedger1227 — Wed, 05 Jan 2022 16:04:10 GMT

This is exactly what i was looking for thank you!