topic Problem with Cascading select with choice filter in ArcGIS Survey123 Questions

Problem with Cascading select with choice filter

Siew_WeiGoh2 — Fri, 03 Nov 2017 13:31:46 GMT

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

Re: Problem with Cascading select with choice filter

Siew_WeiGoh2 — Fri, 03 Nov 2017 23:05:03 GMT

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

Re: Problem with Cascading select with choice filter

SMauri — Mon, 06 Nov 2017 09:57:50 GMT

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

Re: Problem with Cascading select with choice filter

Siew_WeiGoh2 — Tue, 07 Nov 2017 02:56:58 GMT

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!

Re: Problem with Cascading select with choice filter

SMauri — Tue, 07 Nov 2017 09:09:43 GMT

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

Stefano

Re: Problem with Cascading select with choice filter

Siew_WeiGoh2 — Tue, 07 Nov 2017 13:30:44 GMT

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

Re: Problem with Cascading select with choice filter

Siew_WeiGoh2 — Tue, 07 Nov 2017 14:03:31 GMT

Ah! YES!!!! I've found the source of the problem! - *where's the sweaty forehead emoji?*

I had some empty cells in the choices sheet on referenced column D on the cascading select which tripped the all the cascading select function on the form. Once I deleted these empty column D rows.. the form works perfectly!

Another lesson learnt!

Thank you so much for helping me out!

Cheers SW

Re: Problem with Cascading select with choice filter

SMauri — Tue, 07 Nov 2017 14:11:43 GMT

Re: Problem with Cascading select with choice filter

LindaSyers — Thu, 08 Mar 2018 14:49:20 GMT

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?

Re: Problem with Cascading select with choice filter

AndrewHargreaves2 — Fri, 10 Aug 2018 12:01:13 GMT

This issue is stalling my use of Survey123 too. I want to filter choices based on a previous select_one (Yes, No, Cancelled) ... but I don't want to filter choices based on all the choices of that previous select_one, just one of those choices (No).

James Tedrick‌ unless I'm able to use 'Yes or Cancelled' then I can't use a Choices_filter.

Re: Problem with Cascading select with choice filter

IsmaelChivite — Fri, 10 Aug 2018 12:10:19 GMT

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.

Re: Problem with Cascading select with choice filter

IsmaelChivite — Fri, 10 Aug 2018 12:11:50 GMT

Hi Andrew. It looks like in your case you may want to use relevant expressions instead of a choice_filter.