Pulldata statement

[SLouq]

Just wondering if there is a pulldata statement which will pull data from a file hosted on an SDE database instead of a list created in the choices sheet for a Survey123 form. 

[DavidSolari]

You can check this section of the Survey123 docs for more info. Note that layer queries are flaky at best (and unusable at worst) if your users are working offline, if you need offline support then you'll have to regularly update a hosted CSV file that you link to the survey form. 

[PietaSwanepoel_esriza · Accepted solution]

Yes, can be done.

In Connect : Use the 'autocomplete search' functionality under appearance for a select_one drop-down.

In web: add dropdown to page, go to edit (at the options), go to From layer tab.

You reference a published service as your source of data in both cases.

[SLouq]

Thank you for the replies!