Hi all,
I’m working on a Survey123 form using the search() appearance with an autocomplete question. The goal is to filter results by beach code, survey year (2025), and nest final status ('TBD'). The solution needs to work in the Survey123 web app.
Here’s the current expression I’m using, which works for filtering by beach code and year:
autocomplete search("nest_ID_List?url=https://services.arcgis.com/Qv.../arcgis/rest/services/survey123_123...._results/FeatureServer/0",'matches','beach_Code',${beach_Code},'survey_Year','2025')
However, I'm struggling to add a condition that filters for nestFinalStatus = 'TBD'. When I try to include this in the where clause or as an additional match parameter, the autocomplete stops returning results or ignore the TBD filter parameter.
This code work but it ignore the TBD filter parameter.
autocomplete search("nest_ID_List?url=https://services.arcgis.com/QV.../arcgis/rest/services/survey123_1a8...1_results/FeatureServer/0",'matches','beach_Code',${beach_Code},'survey_Year','2025','nestFinalStatus','TBD')
Any suggestions on how to structure the expression correctly?
Thanks in advance for your help!
Note: The codes below does work in connect and mobile app but not in web-app:
1) autocomplete search("nest_ID_List?url=https://services.arcgis.com/QVE.../arcgis/rest/services/survey1....d1_results/FeatureServer/0&where=...'" + ${beach_Code} + "' AND survey_Year=2025 AND nestFinalStatus='TBD'")
JB
