topic Survey123 select or calculate active in ArcGIS Survey123 Questions

Survey123 select or calculate active

stormec — Mon, 23 Jan 2023 16:08:09 GMT

Hi, I have developed a Survey123 survey, in connect. I am using an external csv file and pulldata function to generate my selections, the files are attached. This is for construction sites within our city's MS4 stormwater responsibility. What I would like to do is create an active yes/no question within my project csv to update the survey. The point would be to only show selections that are currently active. As construction projects complete, they could be changed to active no, and no longer be visible within the selection drop down. However, I am not finding any tutorials or information on this type of action. I am not that savvy to solve this on my own. if I am going about this all wrong, please let me know, and the way to resolve it. Thanks, in advance!

Re: Survey123 select or calculate active

DougBrowning — Mon, 23 Jan 2023 16:47:43 GMT

Take a look at the search appearance type.

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

Re: Survey123 select or calculate active

abureaux — Mon, 23 Jan 2023 22:08:56 GMT

You could also go simple and just use the relevant or body::esri::visible columns.

A simple selected(${name},'yes') would do the trick in either of these columns would do the trick.

Edit, In this case, the reverse may be more helpful: not(selected(${name},'no'))

Re: Survey123 select or calculate active

stormec — Tue, 24 Jan 2023 17:58:55 GMT

Thanks for the responses. Based on the structure of the survey search() didn't seem to be an additive option. I tried adding the prompt, but had same results, as without. Unfortunately, there is no selection to use as precursor answer for relevance, as I understand it.

Solved. It is not beautiful, but I created an additional sheet in the csv file. Then, I manually move the information to that sheet when a project is completed. Save and update on ArcGIS online. This removes the choice from the drop-down menu and maintains the rest of the programming. Analogous to adding a new site. Thanks, again!