nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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)

Finde mehr Beiträge mit dem Tag

Accepted answers

Andrew-Bowne

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

All comments

CHedger1227

This is exactly what i was looking for thank you!

Andrew-Bowne

Here's a doc that might help:

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

CHedger1227

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

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.

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_A3C2F3566F974734B55ECECD31C6CA91

Hope that helps

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.