topic Re: How to retrieve la values from a table in ArcGIS Survey123 Questions

How to retrieve la values from a table

SanchezNuñez — Mon, 22 Jul 2024 18:48:18 GMT

Good afternoon,

I am creating a Survey for a project consisting in entering the address of several meters already listed in an excel spreadsheet. This Excel spreadsheet was imported into a FGDB table.

The Survey123 has a field Meter Number, that is a dropdown box. When selecting a value in the dropdown list, we would like to retrieve the record from the table and display a few fields, such as site number and meter type.

Is there a way to retrieve these values from the table?

Thanks

Re: How to retrieve la values from a table

abureaux — Mon, 22 Jul 2024 20:27:32 GMT

Typically, you'd upload a CSV and use it in an External Choice List.

If it it a feature layer though, you need to use pulldata(@layer).

Re: How to retrieve la values from a table

JoseSanchez — Tue, 23 Jul 2024 11:48:01 GMT

Thank you @abureaux

Found this link that explains how to load a dropdown box from a table: Survey123 Tricks of the Trade: Dynamic lists (Web ... - Esri Community

Re: How to retrieve la values from a table

abureaux — Tue, 23 Jul 2024 14:10:34 GMT

That's the web app version of what I linked above (External Choice List). Glad you found what you were looking for.

Depending on how complex you need to get, you may wish to consider using S123 Connect.