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

auto select all the multiple choices without requiring users to select manually

KushShah

Hi

I want to select all the multiple choice values returned from the search expression in appearance column of survey sheet. The choice values/list are populated from feature REST end point service field column called 'Operator' . Is there workaround to have automatically selected on the check boxes of the form? Additionally the default column stores pre-populated values checked but I don't know upfront the default values cause they will be returned only after intersection of geopoint with the feature service.

Another alternative way that solve my issue is to auto display values from the choice options into the text box i.e. Operator1, Operator2 etc. or whatever returned into select_multiple show_pipe that I want to display horizontally instead. I have attached the test expression below.

I appreciate for any suggestions. Thanks!

test1.xlsx

KrisFoster1_0-1620418668020.png

Vind meer berichten getagd met

Accepted answers

Neal_t_k

@KushShah This might work for you depending on how long the list is, But if you make of list of all possible answers that could show up in the search() and put that list in the default column, any item that is populated in the filtered search should show up checked.

The list should be separated by commas but no spaces e.g.:

Operator1,Operator2,Operator3,Operator4...

An excel cell can hold 32,767 characters. So this will only work if you entire list has less characters than that.

edit more thoughts on the list: If your list is longer and you can subdivide some how, You could make a csv with that subdivision and the truncated list, then use the calculate column and pulldata to get the subdivided list from the csv.

All comments

Neal_t_k

The list should be separated by commas but no spaces e.g.:

Operator1,Operator2,Operator3,Operator4...

An excel cell can hold 32,767 characters. So this will only work if you entire list has less characters than that.

Neal_t_k

As a followup, you can by-pass excels character limit by putting the entire list in a csv, and using pulldata to populate the list. You would just have to use a text editor and not excel to make the csv.

csv OperatorList.csv:

Name, List

OpList, "Operator1,Operator2,Operator3,Operator4..."

xlsx:

note OpList OpList hidden Calculation: pulldata('OperatorList', 'List', 'Name', 'OpList')

Then in the calculation field of your search question: ${OpList}

Neal_t_k

Another follow-up it, appears I didn't take testing far enough. While it appears to work on the search question, it actually ignores the filter and selects everything. So that won't work.

KushShah

Hi @Neal_t_k

The first solution helps for me and that is exactly what I wanted. I hope I wouldn't max out the excel cell characters.
while your solution works for me, I am also curious, on this workflow. let say the operator multiple choice are shown (without checked). And when Operator1 is checked, I want to show the related/corresponding TypePipe1 on the other ShowType form box. Assuming that on the REST feature service 'Operator' field stores (Operator1, Operator2, Operator3...)values and TYPEPIPE field stores (Typepipe1, Typepipe2...etc.), how to filter and display TYPE values based on selection of Operator values? Do I have to put both fields list values in the 'choice' sheet of the xls document?

I really appreciated for taking your time resolving into this. Thanks alot!

Neal_t_k

Yes, both field lists on the choice tab and then setup another search question. Something like:

search('TYPEPIPE?url=https://services2.arcgis.com/FiaPA4ga0iQKduv3/arcgis/rest/services/Natural_Gas_Interstate_and_Intrastate_Pipelines_1/FeatureServer/0", 'matches','Operator',${Operator})

Neal_t_k

This might also select the whole list you put in the default column regardless of how the question appears, Check what it actually returns compared what you are expecting it to return.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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