topic Re: Search() and pulldata() with feature service in ArcGIS Survey123 Questions

Search() and pulldata() with feature service

RaynerCastro — Fri, 13 Jan 2023 11:51:53 GMT

Hello!

I'm designing a route control to record daily routes.

I have a select one question with search('nametable?url=...') for a list of buses from a feature service.

I would like other fields to auto-populate with the attributes when a bus is selected. It would be with the same bus feature service that I use before.

How should i use pulldata()?

Thanks!

Re: Search() and pulldata() with feature service

DeloresLoe — Fri, 13 Jan 2023 11:57:27 GMT

The query operation is performed on a feature service layer resource. The result of this operation is either a feature set or an array of feature IDs (if returnIdsOnly is true) and/or a result extent (if returnExtentOnly is set to true).

Re: Search() and pulldata() with feature service

JenniferAcunto — Fri, 13 Jan 2023 13:26:33 GMT

It sounds to me that you would be using the search appearance to populate a select one question and then based on the user's selection additional follow-on fields will autopopulate from the feature service. If that's the case, you would use pulldata @layer to grab the JSON of the entire record and then use pulldata @json to parse out individual attributes.

I would recommend looking at the Query Feature Layer sample in Connect for examples on how to build out the syntax.

Re: Search() and pulldata() with feature service

Tim-Woodfield — Tue, 15 Aug 2023 21:17:43 GMT

Did you end up having any luck with this?

Tagging @IsmaelChivite for any pointers with using the search() appearance and using that selection for the pulldata()

Re: Search() and pulldata() with feature service

IsmaelChivite — Tue, 15 Aug 2023 21:51:00 GMT

Attaching an XLSForm example:

I use search() to populate a country list using a World Countries layer
Then I use pulldata("@layer") to populate other questions in the form (iso code, land rank, etc) for the selected country

I followed the lead from @JenniferAcunto and created a simple example for you.

Re: Search() and pulldata() with feature service

Tim-Woodfield — Tue, 15 Aug 2023 21:54:29 GMT

Thank you! I was in the process of editing my post as I just figured that out. I added an extra step to pull the entire JSON first and then parse but will take that out and add the where clause to the @ layer calculations like you did. Keeps it simpler.

Thanks again,

Tim