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

Can i display a note based on the number of options in a filtered list?

Trippetoe

Hello.

I'm using Survey123 Connect to create survey that contains a 'cascading select'. A contractor must first select their company name and then select an active Work Order Number. The Work Order Number options are filtered by the company name. There may be cases where a company does not have any active Work Order numbers. In those cases, i'd like to display a note that gives some details on who to contact, etc.

I'm imagining that the 'relevant' filter for the note would be something like 'count number of options in work order number question = 0'. So far, i can't figure out how to do that in Survey123 Connect. Does a function like that exist?

thank you.

Find more posts tagged with

Accepted answers

abureaux

If I select an option that doesn't have any results (in your case, no Work Orders), the string-length of the JSON is 0. And if anything is returned, then the string-length is >0. Your note could be keyed to that calculation (e.g., calc_length, above).

I just made a very lazy CSV called B.csv which contained a few options and uploaded it to Portal (below). Essentially, you would just need to maintain a Feature Layer of Work Order Numbers.

abureaux

As you mentioned, hiding the Work Order Number part until a company name is added would do the trick. Personally, I'd go (and have gone) this route.

However, there may be an alternative... I haven't tried this before, but I think this works in theory. If you include a second item in the WHERE clause of the search() it could reference a calculate in your survey and some field in the Feature Layer. The calculate could be something like if(${company_name}='','RandomContent',''). This second WHERE clause referencing both this calculate and something in the Work Order Number Feature Layer would never match so long as the company name was empty. But as soon as you add a company name, they could match (basically just trying to simulate 1=1).
That is a good thing with using the relevant method to hide an item: it clears the selections made.

I think the behaviour you are seeing may related to the autocomplete appearance, and I don't believe that can be changed. You could always swap to minimal appearance. Below is a Cascading Select showing that minimal clears the selection automatically:

All comments

abureaux

You can use string-length() to count the characters in the search response and determine if it contains anything.

E.g., In the Relevant column: string-length(${my_search})=0

Trippetoe

Hi @abureaux

Thanks for your suggestion, but it doesn't work as i need it to. It seems that your formula detects whether or not a value has been selected from the Work Order Number question. I need a formula that can detect whether there are any options available in the Work Order number question. Its possible that there are no options in the Work Order Number questions based on the filter value in place because of the previous question's (Company) answer (hopefully that makes sense!)

abureaux

My apologies for the confusion. The above formula would work with search(), but not cascading selects.

There is no explicit formula for detecting the number of items returned through a choice filter. You would have to keep tabs on which contractors do not have any Work Order Numbers.

As an alternative, have you considered using a Dynamic Choice List?

I put together an example as proof of concept, but I have a server issue to deal with. I will try to post later.

abureaux

I just made a very lazy CSV called B.csv which contained a few options and uploaded it to Portal (below). Essentially, you would just need to maintain a Feature Layer of Work Order Numbers.

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.