I have a Select_multiple list_a in my Survey 123 Connect. That is properly working for an ADD in that it shows the icons in compact form for the choices available. BUT I can not seem to set an initial list value when it's a update transaction based on the results from pulldata()..
I have tried using the textjoin() function in Excel to build a comma delimited list, this does not appear to work in Survey and I can not find a compatible function to set the default list .
There are Six entries in the list and I can get the Six values back from the Layer fine. The selected values are represented with an X in the field in the later -- An if I put the values in a note field they are coming back properly. With a textjoin() it would look like this, but as a single line in the cell -
# Build a List for the MultiSelect of which items should be checked already --
# Tested manually with a concat("Free_Parking", ",", "Paid_Parking")
#
textjoin(",", 1,
if(${Free_Parking} = “X”, “Free_Parking”, “”),
if(${Paid_Parking} = “X”, “Paid_Parking”, ””),
if(${EV_Charging} = “X”, “EV_Charging”, ””),
if(${Free_Park_and_Ride} = “X”, “Free_Park_and_Ride”, “”),
if(${Free_Park_and_Short_Walk} = “X”, “Free_Park_and_Short_Walk”, ””),
if(${Wheel_Chair_Accessible} = “X”, “Wheel_Chair_Accessible”, “”))
Hoping someone here has some ideas. Since it's a read only list / set of fields for now I don't have to worry about parsing the list back into the schema fields for update, but that could also be a consideration down the road-
TIA --
