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

Problem with Cascading select with choice filter

Siew_WeiGoh2

Hi,

I am not sure what I'm doing wrong here but I am having issues with Cascading Select. I have tried changing autocomplete to minimal, but it still doesn't made a difference

My survey setting:

My choice sheet:

I am not getting the result I'm expecting - unable to select segment:

Please advice.

Thank you

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

IsmaelChivite

Hi Linda. You can rename the tables in the Table of Contents in your ArcMap and ArcGIS Pro document and then publish the service again. The Feature Service names your tables and layers according to the table of contents in your document. You do not need to rename your tables and layers in SDE.

LindaSyers

I had this issue too. After a lot of hair pulling, I figured out that it was because my table name had periods in it. This is done by default when a feature class is created in the SDE, so it is published with a prefix of geodatabase.DBO.table_name. Since the form is published from an existing service, I can't change the name in the form to remove the periods.

Does anyone have a work around for this?

Siew_WeiGoh2

Yes. Your XLS is what I need.

I copied the relevant sections into my XLS form BUT it didn't work

I then tried my formula on your XLS sheet and guess what... it worked!

I even test changing Row 8 to 'calculate' and 'note' and all of them worked on your XLS form.

This is bizarre. It is not the first time I had issues with the Cascading Select function not working as expected. Has there been any report on buggy cascading select? Unless I am still missing something... I'm suspecting there is something that is buggy with my XLS form?

- Any suggestion on what's next or how to fix?

Thanks SW

SMauri

Look at this very simple Excel...and tell me if I understand what you need.

Stefano

Cascading Select.zip

Siew_WeiGoh2

Hi Stefano,

Thank you for pointing out my errors. I have tried the modification but am still having trouble for the cascading select to work.

Survey tab:

Choice tab:

I've modified the structure of my form slightly by using 'calculate' instead of 'select_one' to grab the the 'track code'. It should work since it's returning the correct track code (row 28).

I'm struggling to see where I stuff up!

SMauri

Hi, double error I can see.

Column D name must be the same of list name "track"
Choice filter you must like this one:
Track=${track}

More info here: https://community.esri.com/groups/survey123/blog/2015/10/22/cascading-selects-and-external-selects

Stefano

Siew_WeiGoh2

Worked out why my Cascading Select didn't work! So it's working now once I changed the column header in the choices tab from "corridorCode" to "state" (Column D). This suggests that there are set lists of column headers one has to use when utilising additional columns in the choice tab. Is there a specific lists, listed somewhere?

Thanks

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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