nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Populate Select_One list from feature service

Andrew-Bowne

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!

Encontre mais publicações marcadas com

Accepted answers

Anonymous User

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.

Anonymous User

Hi @KyleSchultz1,

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.

Anonymous User

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.

All comments

HeatherBell

Hi, I believe if you scroll back a while there is a solution.

DerekJuracek3

Hello, just wanted to check again, has this feature been implemented yet? Thank you,

NirmalOjha1

@NicoleParsons , it works. If you can't provide the sample file to @Anonymous User, then its difficult to know what or where the issue is. You can send the file with private message if you don't want to share the file publicly.

NicoleParsons

Hello @Andrew-Bowne were you able to get this to work?

Anonymous User

Hi @NicoleParsons,

What type of file are you linking to for the linked content for the select one? Is the file in the correct format for an external choice list?

Are you able to provide an example of your XLSForm (xlsx file and media folder files) and also the linked content file you have hosted?

Regards,

Phil.

NicoleParsons

Hello! I am trying to utilize this solution for a select_one dynamic list pulled from a feature service I need three columns pulled for the choices and the external document cannot be modified as it is updated on the back end. I am missing something in my xls sheet setup/expressions, I have not been able to successfully troubleshoot from the links you provided. If you can help Id be very appreciative. I also need to understand what to input in the choices sheet. Thank you!

HeatherBell

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.

Anonymous User

Hi @HeatherBell,

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.

HeatherBell

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

Anonymous User

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.

NirmalOjha1

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

Anonymous User

Hi @KyleSchultz1,

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

Regards,

Phil.

KyleSchultz1

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.

RosemaryHatch

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?

Anonymous User

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.

RosemaryHatch

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

Andrew-Bowne

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

Anonymous User

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.

Anonymous User

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.

gareth_finney

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

Andrew-Bowne

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

Anonymous User

Hi Andrew,

Regards,

Phil.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.