Having an issue with select_multiple initial value based on pulldata().

JeffSilberberg — Wed, 19 Apr 2023 13:38:47 GMT

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")

# https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c

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 --

Re: Having an issue with select_multiple initial value based on pulldata().

JeffSilberberg — Sun, 30 Apr 2023 18:10:33 GMT

Resolved -- With the help of Esri Professional Services.

* Was missing some concepts in the Update of a feature layer process ..

* Was trying to use Excel functions since I was in Excel. But I wasn't really in Excel and can't use some of it's magic.

topic Having an issue with select_multiple initial value based on pulldata(). in ArcGIS Survey123 Questions

Having an issue with select_multiple initial value based on pulldata().

Re: Having an issue with select_multiple initial value based on pulldata().