topic Re: Populate Select_One list from feature service in ArcGIS Survey123 Questions

Populate Select_One list from feature service

Andrew-Bowne — Wed, 07 Oct 2020 12:45:11 GMT

Hello,

Is it possible to populate a select_one list from attributes retrieved from a feature service? I assume I will need to use a custom javascript function to get the data. I have been doing a lot of reading and I can't find a definitive answer that says if this is possible or not. I'd like to pull the values of a two fields. One field would be the label ("Name") shown on the survey and the other would be the value ("GUID") that would be submitted with the survey.

A second part to this is... If this is possible, can this be executed when the survey opens? I'd like this list to be the first item a user chooses from when they start the survey.

Thanks!

Re: Populate Select_One list from feature service

Anonymous User — Mon, 12 Oct 2020 02:58:53 GMT

Hi Andrew,

You are correct, populating a select one choice list from a feature service URL (or any other type of data service from URL) is not currently supported. This is logged as enhancement ENH-000119959 and something that will likely be supported in a future release.

Using a JavaScript function and the pulldata() at JavaScript expression, this would be possible to achieve what you are wanting to do. However you will need to write your on JS function. If you want this to be the first question in your survey, this should also be possible if you use hidden/calculate questions before the first visible question, so that the values retrieved from the FS are available for the first question to be populated.

Regards,

Phil.

Re: Populate Select_One list from feature service

Andrew-Bowne — Mon, 12 Oct 2020 11:51:16 GMT

Thanks for the information, Phil. This is very helpful and look forward to this being supported in the future.

If I were to use a custom JS function to return field values as JSON, how would I parse those into a format that would be consumable by a select_one choice list?

Thanks,

Andrew

Re: Populate Select_One list from feature service

GarethFinney1 — Wed, 14 Oct 2020 00:33:05 GMT

Andrew

This is exactly the question I'd love to see answered. I can pull data for one off (single item) display in Notes, and or Text types, but to have a series of values populate a list and not rely on the list being defined in the choices, or external choices is key here..

any advice truly appreciated

thanks

Gareth

Re: Populate Select_One list from feature service

Anonymous User — Thu, 15 Oct 2020 22:31:36 GMT

Hi Andrew and Gareth,

Sorry for the confusion, it is not possible to populate or update a choice list (select one or multiple) from a JS function. It is possible to return a value from another source based on a query or calculation, or return a comma separated list or JSON object, however you still need to process it into the survey as a value into a question.

We are currently working on a new feature in beta, for 3.12 beta update, which will allow you to use a select one or multiple and use the search() function to query a feature service and populate the choice list directly. I believe this is what you are after. Keep an eye out for the next Early Adopter Community update and documentation, on how you can test this out in 3.12 beta.

Regards,

Phil.

Re: Populate Select_One list from feature service

Anonymous User — Fri, 06 Nov 2020 10:17:39 GMT

Hi Andrew and Gareth,

Good news, just letting you know that in the latest 3.12 beta builds available on the Survey123 Early Adopter Community we have made significant improvements to large choice lists which improve the survey load time in both Connect and the field app.

On top of this there are now some new ways you can manage your choice lists dynamically and update them without having to republish the survey, meaning choice lists can now be populated and updated dynamically from a CSV file or hosted table shared in ArcGIS or directly from a feature service using the search() function. Please check out the latest announcement on EAC and test out these new beta features with the latest 3.12 beta builds.

Regards,

Phil.

Re: Populate Select_One list from feature service

Andrew-Bowne — Mon, 09 Nov 2020 18:52:24 GMT

Awesome, thanks for the update. I'll check it out

Re: Populate Select_One list from feature service

RosemaryHatch — Fri, 05 Mar 2021 19:52:20 GMT

Hi Phil,

I was wondering if there is any more documentation on populating choice lists dynamically from a feature service? I seem to keep going in circles reading through the updates, and am hoping you can point me to the most recent development.

Thanks,

Rosemary

Re: Populate Select_One list from feature service

Anonymous User — Mon, 08 Mar 2021 22:25:02 GMT

Hi @RosemaryHatch,

The documentation for Linked Content using external choice lists from file or hosted file, and for pulldata() can be found here: https://doc.arcgis.com/en/survey123/desktop/create-surveys/publishsurvey.htm#ESRI_SECTION1_90818E24DF84492CBA5A35D5F0CC3AAE

For the search() functionality, which can be used to query a hosted feature service, that is still a beta feature and is documented in EAC here: https://earlyadopter.esri.com/project/article/item.html?cap=e69ef91f45744b98882c651f7b518eb7&arttypeid={5a8e51ed-4a87-43fe-a67d-2b7829af130f}&artid={F91C2CD4-2A42-4CA3-AC7D-755A5C34F811}

Regards,

Phil.

Re: Populate Select_One list from feature service

RosemaryHatch — Tue, 09 Mar 2021 14:16:06 GMT

Thanks Phil! The search feature is exactly what we are looking for in our workflow. Is there a timeline for when this will be released out of beta?

Re: Populate Select_One list from feature service

Anonymous User — Thu, 11 Mar 2021 00:46:32 GMT

Hi @RosemaryHatch,

We are planning to support this in one of the next upcoming releases, the main outstanding work is adding support to the web app, so forms that use the search() function working correctly in both field app and web app, and also a few improvements still in progress with the search() feature.

Regards,

Phil.

Re: Populate Select_One list from feature service

RosemaryHatch — Mon, 09 Aug 2021 15:33:39 GMT

Hi Phil,

Are there any updates to the search functionality? I've seen a couple posts that seem to mention using it, but still haven't seen any documentation.

Thanks,

Rosemary

Re: Populate Select_One list from feature service

KyleSchultz1 — Tue, 10 Aug 2021 15:43:22 GMT

Yeah, this is in desperate need of some documentation. I would like to perform the search query using the location and a distance within. According to the beta site this should be possible but can't find anything on how to do it.

Re: Populate Select_One list from feature service

Anonymous User — Fri, 13 Aug 2021 01:08:00 GMT

Hi @RosemaryHatch,

The search() feature is currently only beta and therefore only documented in the Early Adopter Community. This feature will be released in the upcoming 3.13 release, and will be available for both the Survey123 feild and web apps. The online documentation will be updated once 3.13 is released.

For now you can test out the search() feature using the 3.13 beta builds available on EAC.

Regards,

Phil.

Re: Populate Select_One list from feature service

Anonymous User — Fri, 13 Aug 2021 01:08:28 GMT

Hi @KyleSchultz1,

For now you can test out the search() feature using the 3.13 beta builds available on EAC.

Regards,

Phil.

Re: Populate Select_One list from feature service

NirmalOjha1 — Thu, 02 Sep 2021 18:21:35 GMT

Hi @Anonymous User ,

Is there any plan to support search function on featureservice when offline? Something similar to hosted CSV file, where the csv file gets downloaded when the device is online and the csv contents changed. I am looking for something similar where the table contents from the hosted featureservice(table) is downloaded when the device is online so it can be used in offline mode.

Thanks.

Nirmal

Re: Populate Select_One list from feature service

Anonymous User — Thu, 02 Sep 2021 23:46:08 GMT

Hi @NirmalOjha1,

Searching feature services using search() function when offline is not supported, and there are currently no plans to support this in a near future release.

Regards,

Phil.

Re: Populate Select_One list from feature service

HeatherBell — Tue, 23 Nov 2021 10:20:21 GMT

Hi @Anonymous User,

Is it currently possible to populate a select_one with a list of values pulled from a field in an online hosted feature layer. I don't need to spatially query it, though this looks useful for other applications. I just need the list of text values returned from one field to be used as a list of options in the select_one. I've tried a number of ways using javascript and pulldata() in Survey123 version 3.12 232 but cannot crack the exact method, it seems like it is possible from everything I have read but I can't find this exact method documented without using a spatial query.

The example would be, we have a hosted online feature layer with a list of projects that will be added to over time. Then we have an assets survey and associated hosted feature layer, where people choose a project name first and then add an asset (point to the map) where. I want the project name in the assets survey to be populated using a select_one list of field values pulled from the projects layer so that it is dynamic.

Thank you,

Heather

Re: Populate Select_One list from feature service

Anonymous User — Tue, 23 Nov 2021 10:29:59 GMT

Hi @HeatherBell,

Yes this can be done using the search() appearance direct to a feature layer/table, or you could use linked content to a hosted table or CSV. You will need to be using the latest version 3.13 of Connect and field app for this to work. Refer to following blogs and doc:

https://community.esri.com/t5/arcgis-survey123-blog/dynamic-choice-lists-using-search-appearance/ba-p/1060838

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformsappearance.htm#ESRI_SECTION1_46A700D2AABF47F1AE4D5004762DB372

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformessentials.htm#ESRI_SECTION1_34A4D88BA6A64C48AA0E113DC61099DD

Regards,

Phil.

Re: Populate Select_One list from feature service

HeatherBell — Tue, 23 Nov 2021 10:32:18 GMT

Hi @Anonymous User,

Great, thank you for the swift response. I'll see if I can figure it out with these documents.

All the best!

Heather.