Select to view content in your preferred language

Using pulldata to populate a text field from select_multiple?

6423
6
11-17-2020 09:20 PM
MichelleTanner
Regular Contributor

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

 

 

0 Kudos
6 Replies
Shwu-jingJeng
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...

0 Kudos
MichelleTanner
Regular Contributor

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

0 Kudos
Shwu-jingJeng
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 [email protected] if you prefer not to share it publicly.

m3
by
Frequent Contributor

How and why is this marked as the solution?

0 Kudos
Shwu-jingJeng
Esri Regular Contributor

Hi Michael,

In Michelle's case, we had helpped her with some report template syntax error to close this issue.

What issue did you encounter?

 

0 Kudos
m3
by
Frequent Contributor

I mostly gave up on it but you should not have a private answer marked as a solution as it provides no solution to anyone other than the OP.  Or the answer should be posted publicly.