Using pulldata to populate a text field from select_multiple?

382
3
Jump to solution
11-17-2020 09:20 PM
New Contributor III

Is it possible to use the pulldata() function from a select_multiple question type? 

What I am trying to do: 

I have a normal select_multiple question. If the user selects something in that question, I want certain text to appear below. I am using an external csv lookup file in the Media folder because these lookup tables can get pretty lengthy. If the user selects multiple options, I want all the options in the lookup table to appear. 

However, I cannot seem to get the question to display any text! When I change my first question type to select_one it works just fine. Am I missing something in my syntax? I've included screenshots below if that helps. 

pulldata('Findings_Citations_Lookup','Citation','FindingCode',${SS2_f})

 

 

Reply
0 Kudos
1 Solution

Accepted Solutions
Esri Regular Contributor

Hi Michelle,

Could you share your XLSForm and the associated csv file with us to look into this further?

You could mail it to my email sjeng@esri.com if you prefer not to share it publicly.

View solution in original post

3 Replies
Esri Regular Contributor

Hi Michelle,

Unfortunately, the pulldata() function can't be used to populate the values of select_multiple questions.

Please see the Note in our Online Help for this limitation:

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_CF492D3...

Reply
0 Kudos
New Contributor III

Shwu-jingJeng,

I believe my request is actually the opposite. I want to use a select_multiple to populate a text field using the pulldata() function. Does that make sense? I've attached a screenshot of the relevant section in my xls form for more context. 

 

Screenshot 2020-11-18 172601.png

Reply
0 Kudos
Esri Regular Contributor

Hi Michelle,

Could you share your XLSForm and the associated csv file with us to look into this further?

You could mail it to my email sjeng@esri.com if you prefer not to share it publicly.

View solution in original post