Select to view content in your preferred language

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

330
1
Jump to solution
04-19-2023 06:38 AM
JeffSilberberg
Occasional Contributor III

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 --  
0 Kudos
1 Solution

Accepted Solutions
JeffSilberberg
Occasional Contributor III

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.

 

View solution in original post

0 Kudos
1 Reply
JeffSilberberg
Occasional Contributor III

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.

 

0 Kudos