Can Search Appearance Filter Options Out?

[MT_JenAmes]

I have a form for employees to submit maintenance requests for their work car. I'm trying to set up a form to pull all of the important information from the hosted feature layer of vehicle information so that I don't have to update the source data every time something is updated or moved. I have it set so employees select the department they work in, and then select the vehicle they drive. However, the vehicle information layer that the data is pulling from contains more points than I want it to show in a list. Can I use the filter column, filter text parts of the search formula to filter options OUT of the list?

For example, we have some equipment in our system that does not have an ID assigned to it yet, so I don't want those to appear, but currently they do, and just appear as empty bullets:

Is there a way to filter the search for not equal to null or something along those lines? Or to filter it to show multiple options? So instead of filtering type = cars, is it possible to filter it to type = cars and truck?

[ChristopherCounsell]

You could filter it in a few ways, such as by adding an appearance and column/text filter

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

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformsappearance.htm#ESRI_SECTION1_46A7...

But it sounds like the big problem is the 'null' IDs. You can bypass this issue entirely by creating a Hosted Feature Layer View that your survey pulls data from. In the view definition, add a filter to remove all vehicles with a blank ID. And whatever other vehicles you want omitted.

https://doc.arcgis.com/en/arcgis-online/manage-data/create-hosted-views.htm

[CESPEDESLUISITD]

None of the samples work for me, even doing it to the T, it doesnt populate anything on my select_one field.

I wish those blogs had better examples.

[DustyJordan]

Hi @MT_JenAmes ,

Did you ever figure out how to filter null values out of a CSV being used for Search() Appearance? 

I think I am running into a similar issue. I am trying to use a single master CSV array containing multiple columns used in various drop down lists. I can get the list to display, but it's including a bunch of blank options, which I believe are just the blank cells within the array. 

A way to filter by contains any text or is not null would solve this...I think. 

[MT_JenAmes]

Unfortunately, I have not. Sorry. 

The filtering is a great function, but I find it odd that it only filters as "contains ___" and there's no option for "is null" or "does not contain"