Select to view content in your preferred language

Pick list from a field in a feature service?

539
17
Jump to solution
4 weeks ago
AmyRoust
Frequent Contributor

I'm struggling to interpret Esri's instructions for generating a pick list from a feature service for a select_one question in Survey123 Connect. I'm referencing the Search function.

Here's what I'm getting from the documentation:

In the choices tab, enter the list name (doesn't matter what I call it), the name (must be the field name in the feature service that I want to pull values from), and the label field (doesn't matter what I call it). Here's my config:

AmyRoust_0-1755272801416.png

 

Then, in the survey tab, I populate the type as select_one buildingname (with the part after the select_one statement matching the list_name value in the choices tab), the name (with the name of the field in the feature service), the label (does not matter what I put here). Here's my config:

AmyRoust_1-1755272938766.png

Then, in the same tab, same row, I have to populate the appearance column with the search() function and the correct parameters, which are supposed to be search(tableName, searchType, searchColumn, searchText, filterColumn, filterText). I can tell that tableName is the URL of the service (including the number of the sublayer), but after that, I get hazy. Here's what I have so far:

AmyRoust_2-1755273088307.png

That syntax does not actually generate a drop-down menu on the survey. If I add the autocomplete parameter, I get a blank drop-down.

Help?

 

 

17 Replies
AmyRoust
Frequent Contributor

Mystery solved. This only works with a hosted feature service, and I was using a user-managed service from my Portal.

0 Kudos
HannesVogel
Frequent Contributor

It also works with featureservices referencing from an enterprise geodatabase, it is not limited to hosted featureservices.

0 Kudos
AmyRoust
Frequent Contributor

@HannesVogel - Esri tech support confirmed today that it does not work with Enterprise user-managed feature services. They logged an enhancement request for me: 

Defect #: ENH-000179151

Synopsis : Add non-hosted layer types as an option when using pulldata/dynamic choice lists in ArcGIS Survey123 Connect

0 Kudos
HannesVogel
Frequent Contributor

@AmyRoust Ok that's interesting because it works on my side with Survey123 Connect and a non-hosted featureservice in ArcGIS Enterprise. I can provide ESRI Tech support or you maybe more details if anyone wants to see. Just let me know.

0 Kudos
AmyRoust
Frequent Contributor

@HannesVogel - what version of Enterprise and S123 Connect? Maybe it doesn't work because we're on Enterprise 11.3. And do you have S123 installed on your Enterprise deployment? I'm using ArcGIS Online.

0 Kudos
HannesVogel
Frequent Contributor

We are on ArcGIS Enterprise 11.3 as well, Survey123 Connect is up to date on my machine. S123 is enabled in our ArcGIS Enterprise but I don't have ArcGIS online involved in my setup, this is what confuses me in your answer.

0 Kudos
AmyRoust
Frequent Contributor

I bet that's the difference. I tried to deploy S123 in our Enterprise environment, but no one at Esri could figure out how to get it to work on a multi-machine deployment. I kept getting crytpic error messages during the setup process that no one could figure out. I finally gave up and decided to just use S123 in ArcGIS Online. I bet there is a permissions or access issue where ArcGIS Online does not know how to interpret user-managed Enterprise services. Maybe I'll try to deploy S123 in Enterprise when we upgrade to 11.5.

HannesVogel
Frequent Contributor

yes that's the difference - you try to access the featureservice from "outside"/AGOL, and I do everything within ArcGIS Enterprise. Good luck with the next deployment of S123 in ArcGIS Enterprise - I hope it will work for you! 

0 Kudos