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; } } }

How to keep dynamic search() list empty until a previous selection is made?

JoseBarrios1

Hello Everyone,

I’m building a survey in Survey123 Connect with dynamic choice lists using the search() appearance.

Example expression: search("RCWParticipantsTable?url=https://services.arcgis.com/...../FeatureServer/0&orderByFields=ParticipantID",'matches','PropertyKey',${PropertyKey})

The expression works as expected to populate the list. However, when the survey first loads, the question displays all records from the feature layer before it gets filtered by the previous selection.

I tried using the relevant column to control this, but that approach still causes performance issues and completely hides the question (whereas I want it to remain visible).

In my case, I have six select_multiple questions that all use the same dynamic list (via the search() appearance) to choose a person from a pool of 2,220 participants. Loading the entire list six times has a significant performance impact.

Does anyone have a suggestion for keeping the dynamic choice list visible, but preventing it from showing all records until it’s filtered by another question?

Thanks in advance for any guidance!

UPDATE Note:

I’d like to highlight that after publishing the survey, the issue occurs in both the mobile and desktop versions of the app. However, the survey works as expected ( list is not pre-loaded) in the web application.

Find more posts tagged with

Accepted answers

Neal_t_k

@JoseBarrios1 I forgot, there is some different syntax for web vs field app unfortunately and I don't know why.

web: concat("COUNTRY?url=https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/World_Countries/FeatureServer/0?orderByFields=FID DESC")

field app/connect: concat("COUNTRY?url=https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/World_Countries/FeatureServer/0/&orderByFields=FID DESC")

It really makes it difficult because to use this you have to chose 1 type of form.

All comments

JoseBarrios1

Hi Neal,

Thank you so much for your help with this. It’s been challenging because the query, (using ?), doesn’t even work in Connect, although it works fine on the web. It’s difficult to tell if the query isn’t functioning properly until the survey is published. Since my survey is primarily intended for web use, I’ll go ahead and implement the workflow you suggested as a solution.

Thanks again for your time and support!

Neal_t_k

@JoseBarrios1 I forgot, there is some different syntax for web vs field app unfortunately and I don't know why.

web: concat("COUNTRY?url=https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/World_Countries/FeatureServer/0?orderByFields=FID DESC")

field app/connect: concat("COUNTRY?url=https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/World_Countries/FeatureServer/0/&orderByFields=FID DESC")

It really makes it difficult because to use this you have to chose 1 type of form.

JoseBarrios1

Hello Neal,

Your approach works great on Connect, the mobile app, and the desktop app. However, it fails to load the list on the web app (see attached image). Unfortunately, the app is primarily intended for use on the web.

Strangely enough, my current workflow behaves the exact opposite: it loads the full list on Connect, mobile, and desktop, but works as expected on the web app.

Thanks everyone for the helpful suggestions so far — I appreciate the support in resolving this issue!

DavidPike

I had another simpler idea which seems to achieve a partial objective. I think it can be tweaked into a full solution with some more testing/development:

Simply set the url "https://services.arcgis.com/...../FeatureServer/0" as a Hidden question called url. and set it Relevant on the previous question being completed e.g. Calculation

string-length(${previousQuestion})>0

You then have your next question Appearance

autocomplete search(${url})

of course, you'd have to modify the search parameters with the filter from the question result also, but that's the basic concept above.

Neal_t_k

@DavidPike I haven't tested but I would think a if statement would work for this case

if (${PropertyKey}="",concat("<url>","&resultRecordCount=300"), concat("RCWParticipantsTable?url=<url>&where=",${whcl}))

Neal_t_k

@JoseBarrios1 Check out this example, I believe the question "Country4" is the example you are expecting to see, but there are several other working examples that you can see how they interact. Hopefully you can adapt to your feature layer.

It appears with the "matches" syntax I was making it too complicated.

Form 9.xlsx

DavidPike

Yes I'm having a long think about how to dynamically update the record count value after, subject to the relevant/previous question being completed.

It's surprising the filter value isn't then returning 0 records when blank.

Could you set a default value for the previous question such as "No Response" or a special character etc. that might then-kick in the filters.

Setting a fixed &resultRecordCount=300 for the moment might offer you some performance boost until a solution is found (I understand you've said it's not feasible as a real solution - which I agree with)

Note for posterity it is resultRecordCount, not maxRecordCount as I previously put.

Last one would be check you have the latest version of connect / republish a new test survey from the XLS etc.

JoseBarrios1

Hello Neal,

Thank you so much for taking the time to look further into this. I'm currently trying to implement your suggestion, but I'm having some difficulty adapting your code to fit my URL query. Would you mind taking a look at what I have so far?

Specifically, I need to use orderByFields=ParticipantID so that the "Add Participant" option appears last in the list. I’m also using matches instead of where, as I couldn’t get where to work correctly in my case.

Here is the current search() appearance expression I’m using:

autocomplete search("RCWParticipantsTable?url=https://services.arcgis.com/...../arcgis/rest/services/..../FeatureServer/0&orderByFields=ParticipantsID",'matches','PropertyKey',${PropertyKey})

Any guidance you can provide would be greatly appreciated!

Thanks,

Neal_t_k

Here is a working example of what I described above. The search does not get applied immediately, when the form is initiated the list is empty, The list doesn't get populated until the appropriate selection is made.

Form 9.xlsx

JoseBarrios1

Hello Everyone,

Thank you all for your suggestions and support. Unfortunately, I still haven’t been able to find a solution to the issue. Let me try to explain the problem I’m encountering in more detail, particularly as it relates to how choice lists are rendered and filtered in Survey123. Let me try to explain the problem I’m encountering in more detail, particularly as it relates to how choice lists are rendered and filtered in Survey123.

Survey123 Performance Issue: Survey123 is loading full datasets into choice lists before applying any filters based on previous questions. This result in long loading times and significant performance degradation.

Here are some example of the workflow: On Page 01- Site selection

{State} – user selects a U.S. state
{ProjectType} – user selects a project type (Federal, State, Private)
{ProjectName_ID} – should display only relevant projects based on the selected State and ProjectType

Expected Behavior:

The {ProjectName_ID} field should:

Stay empty until both {State} and {ProjectType} are selected
Display only the filtered list of project names (10–264 records depending on filters)

Current Behavior:

All 1,200 records from the ProjectName_ID feature layer load immediately, before of prior selections
If the selected ProjectType isn’t available for the chosen State, the {ProjectName_ID} list shows all 1,200 records, rather than remaining blank
Only after both fields are selected does the filter apply correctly

Another example on Page 2 - Participant Activity Section

This page includes 7 questions using the search() appearance to capture different participant roles (Submitter, Researcher, Tagger, Observer, etc.)
Each question pulls from a list of 2,000 participant-role records linked to a {PropertyID} selected on Page 1

A participant can have multiple roles.

Expected Behavior:

Each {Participant_Name} field should remain empty until a {PropertyID} is selected.
Display results in autocomplete mode based on previous selection

Current Behavior:

Each of the 7 text fields loads the entire 2, 000-record list before any filtering is applied
This means 7 × 2,000 = 14,000 entries are rendered upfront
autocomplete and minimal appearances are ignored in survey123 connect in this layout. The autocomplete work as expected when publishing the form on the field app and web app.
Performance is severely impacted until filters kick in.

Current Workflow Setup

Using autocomplete appearance
Form is structured using:

Pages layout, dynamic-grid field-list, Inside a repeat

What I’ve Tried

Reviewed all relevant documentation and tried workarounds provided here. Tried tweaking MaxRecordCount, but it doesn’t solve the issue: The filtered list varies from 10 to 264 records, so setting a static cap isn't viable

Haven’t yet implemented the suggested workaround to set MaxRecordCount to 1 until previous questions are answered – I'm unsure how to do this dynamically

Summary of the Core Problem

Survey123 is rendering full lists before applying filters based on previous answers.
This leads to unnecessary data being loaded, unfiltered lists being shown to users, and severe performance issues — especially when using search() appearance within repeats or dynamic-grid layouts

DavidPike

there might be a few hacks. You could have a MaxRecordCount (always return max 10 for example) query parameter added to the service URL, or set it to 1 until a previous question is answered, then alter the variable size.

You could also have your search/filter parameter preset in the same way to some default value, which then updates dependent on that previous question being answered.

MattEdrich

Interesting challenge! When you say "all records from the feature layer", does that mean all attributes for each record of the unfiltered query? If so, you might have some performance gains if you make use of the optional (`filterColumn', `filterText') parameters of the search appearance; though I don't think this would necessarily stop the initial search going out.

If you're already filtering down to the column you care about to populate your dynamic choice lists, then I would recommend trying to break up the search query itself into using some parameters that are given by the user in their session. From the example you gave above, this could be done like so:

text | ParticipantID | What is your participant ID?
select_one dynamic_choice list | firstSearch | What are you searching for? | appearance = search("RCWParticipantsTable?url=concat("https://services.arcgis.com/...../FeatureServer/0&orderByFields=",${ParticipantID}),'matches','PropertyKey',${PropertyKey})

Total guess there if that will work, but assuming you can do that with the search appearance, I think the survey form would not be able to make any queries until it has all the values it needs from the user.

A wilder suggestion, which I am definitely not sure is possible, would be to try and pull the data (which you are currently getting in the search appearance) for the choice list as a JSON object into the survey using pulldata("@javascript" or "@json") and then making specific pulldata("@json") calculations to build your choice lists. If that is possible, it would certainly boost performance in your survey since you would only have to query the URL once and could continually use that same response as many times as you wanted in the survey.

Neal_t_k

What would happen if you calculated your url parameters in a separate helper question, and made that question relevant on another question. That would mean there is no url until it becomes relevant.

url1: calculation: concat ("RCWParticipantsTable?url=https://services.arcgis.com/...../FeatureServer/0&orderByFields=ParticipantID",'matches','PropertyKey',",${PropertyKey}) relevant: string-length(${PropertyKey}) > 0

your search appearance in your visible question would be something like this: autocomplete search(${url1})

but the question ${url1} wouldn't be relevant until other conditions met. So the list should be blank until ${PropertyKey) is filled in and that url is calculated

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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