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; } } }

Survey123 connect Using one answer to autofill another

Kjcomp10

Alright Survery123 community I need your help.

I am trying to have one survey question answer another survey question from a choice_list or a .csv or even a feature service.

Here is the situation.

The survey will ask the users what location they are at. When they answer each location has a specific site code associated to it. I would like the correct site code to auto-populate when the location is selected.

From what I can find this is possible using the appearance search functionality in the form.

Here is the link to using the search() appearance

I have tried to follow this format but clearly I am doing something wrong.

search(‘tableName’, ‘searchType’, ‘searchColumn’, ‘searchText’, ‘filterColumn’, ‘filterText’)

Any help would be wonderful.

I have attached the forms below. Since i am doing this wrong I cleared the appearance column out to start over.

Survey123.JPG

Form 2.xlsx

Armories.csv

RobertAnderson3_0-1721128772284.png

ChrisUnderwood_0-1721128425606.png

MappyIan_2-1721125832946.png

Find more posts tagged with

Accepted answers

AndyMcClary

Hi Ken,

If I'm understanding your question correctly the pulldata() function should do what you want. Try putting something like:

pulldata(Armories, sitecode, name, ${armory})

in the calculate column of the sitecode field and you should be good to go. Documentation on the pulldata function is in the Work with external content section of https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

All comments

Katie_Clark

Hi Ken,

Where is the CSV file located that you are pulling data from? Is it hosted in AGOL? Stored in the media folder?

Kjcomp10

Hey Katherine,

I created the csv and saved it in the media folder.

The other option here is that this information is also in a point feature service in our ArcGIS server which is federated to our portal enterprise.

AndyMcClary

Hi Ken,

If I'm understanding your question correctly the pulldata() function should do what you want. Try putting something like:

pulldata(Armories, sitecode, name, ${armory})

Kjcomp10

I will give that a go and let you know if that works out.

Thank you for the help.

Kjcomp10

Thanks Andy,

pulldata(Armories, sitecode, name, ${armory}) worked great just needed to add ''.

So..

pulldata('Armories', 'sitecode', 'name', ${armory})

I appreciate your help.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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