Select to view content in your preferred language

How to retrieve la values from a table

336
3
07-22-2024 11:48 AM
SanchezNuñez
Frequent Contributor

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

0 Kudos
3 Replies
abureaux
MVP Frequent Contributor

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).

0 Kudos
JoseSanchez
Frequent Contributor

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

0 Kudos
abureaux
MVP Frequent Contributor

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.

0 Kudos