I'm having difficulty getting Cascading Selects to work on a survey after it's been published and shared online. The survey was made in Connect and works well in both the Connect environment as well as the Survey 123 Desktop application, but once it gets published online the cascading selects appear corrupted and they cannot actually be chosen from the list (the appearance type is autocomplete). They also have the message "static_instance" and read the list_name, name, and label from the xlsx. form. Originally the labels for these choices had special characters, so I eliminated those in the event that was causing the problem, but I'm still seeing errors. When you try to submit your survey in the online environment, you get the error: "String or binary data would be truncated. The statement has been terminated".
I've tried publishing this survey with just cascading select, but also with Cascading Select and External Select. Neither time it works.
I have published surveys from Connect before with Cascading and External Selects and have had no problem with functionality. This is the first time I have ever seen this error.
I'm attaching some screen shots as well as the xlxs. form that the survey was made in if that helps.