topic Re: Auto Populate field based on previous answer in ArcGIS Survey123 Questions

Auto Populate field based on previous answer

ModernElectric — Mon, 28 Aug 2023 19:21:54 GMT

I am working on designing and creating a survey for inventory check-out for new build(s) in the field by our electric linecrew. I have been able to program a series of drop-down entries for the foreman to choose from by looking at a table in one of our Hosted Feature Layers. They choose the inventory number in one drop-down and then choose the description of the inventory product in the next.

What I am trying to do is for the Description to auto populate based on the selection they choose in the inventory number.

See Attachment(s)

STOCK NUMBER #1 is the field the foreman selects the inventory number (looking at the table in the Feature Layer).

DESCRIPTION #1 is the field I would like to auto populate based on the selection in STOCK NUMBER #1

FEATURE LAYER TABLE is the table the survey is looking at for the drop-downs.

EXAMPLE: If Foreman selects 1040 in STOCK NUMBER, the DESCRIPTION would auto populate to Anchor Rod Triple Eye 1" X 8'.

The goal is to help the foreman and save time.

Thank you for any advice u can give

Re: Auto Populate field based on previous answer

ZenMasterZeke — Tue, 29 Aug 2023 15:02:38 GMT

Here's what I use to populate a name field based on an address selection. From a csv file, not a layer, but general process should be similar. Work is done in the pulldata function. See https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415

select_one_from_file streets.csv

sample_street

Street Address

text

owner_fn

Owner First Name

yes

pulldata(${csv_file}, "first_name", "label", ${sample_street})

Re: Auto Populate field based on previous answer

ModernElectric — Tue, 12 Sep 2023 14:34:31 GMT

Wanted to see if anyone else had this problem. I starting using the ESRI Survey 123 Connect Desktop App to design and edit the survey form and then publish it to AGOL. After creating a few surveys, others were not able to see the results. However, if I just created the survey from from My Surveys on the website, published and then recorded data, everyone was able to see them. Is this a problem with the 123 Connect app?