Cascading Selects Regex issue

[Jefcoat_Nathan]

Greetings,

I'm trying to use a simple cascading select using regex and a comma delineated list in the choices tab.  I read through a blog post outlining exactly what I wanted to do, but the second field (component in this case) will not allow me to select a value and no dropdown list is available to click.  It seems pretty straightforward and I feel I must be missing some minor detail. I would appreciate any insight someone might have.Choices TabForm TabSurvey Tab      

[Anonymous User · Accepted solution]

Hi @Jefcoat_Nathan,

What version of Connect and the field app are you using? From your screenshots it looks as if everything is configured correctly, however there must be something else causing the issue. On thing I noticed is some of the values in the choice list column have no spaces after the comma. This shouldn't make a difference but good to be consistent either way. I can  see you are using a reserved keyword "date" in the name column of the survey sheet. This may cause unexpected issues, refer to latest advanced template and "Reserved" tab for full list of reserved keywords.

Can you share your XLSForm (xlsx file and media folder files) so we can take a closer look?

You can also take a look at the sample "Choice Filters and Cascading Selects" available in Connect, this has a working example of using regex() in the choice filter column.

I just tested it out with the latest 3.12 version of Connect and field app and it works as expected:

Regards,

Phil.

[Jefcoat_Nathan]

Thanks for the response @Anonymous User !

I was using using 3.9 and upgraded to the latest version but I'm still having the same issue where the field the has a choice filter will not populate with choices.  I have attached the XLSForm (there are no media files) if you have time to take a look.

[Jefcoat_Nathan]

Well it turns out I'm just dense and got some logic wrong in setting up my column list.  It is all working fine now.  Thanks again.