Cascading Selects from Survey123

Question

I have an operations dashboard which is being fed with data from Survey123. The survey contains lots of cascading selects. I am using a combination of "List" and "Details" widgets on Operations Dashboard. Rather than data appearing in these widgets as the "label" column from Survey123, it is displaying the "name" column.

I have attached a screenshot below. S145 is the "name", and the "label" is "Aluminium" - this is what I need displayed.

TIA!

Capture.PNG

VeenaHosur_0-1663326658047.png

DerekLaw · Answer

Hi Josh,

Thanks for posting and letting me know this workaround. I learned something new!

Best,

JoshHarris2 · Answer

Hi Derek,

To get around this, I used jr:choice-name(). In the XLSForm, I added a hidden field beneath the field that was displaying the name instead of the label. I was then able to reference this new, hidden field in Operations Dashboard, which now displays the label.

The information regarding this functionality was picked up from here https://community.esri.com/groups/survey123/blog/2018/12/02/survey123-tricks-of-the-trade-xlsform-functions-for-lists

Many thanks

Josh

Capture.PNG

DerekLaw · Answer

Hi Josh,

> I don't think renaming the name column to match the label column is possible in this instance, as there are thousands of choices, some of which have duplicated labels.

As I stated previously, the elements in Operations Dashboard will display the name of the attribute fields from the feature service. And yes, you would need to provide a unique name for each individual column in the table. Unfortunately, there is no workaround, as the app is working as designed.

Hope this helps,