topic Re: Using pulldata to populate a text field from select_multiple? in ArcGIS Survey123 Questions

Using pulldata to populate a text field from select_multiple?

MichelleTanner — Wed, 18 Nov 2020 05:23:35 GMT

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

Re: Using pulldata to populate a text field from select_multiple?

Shwu-jingJeng — Wed, 18 Nov 2020 21:13:31 GMT

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_CF492D34EF6E49D6ADD4C941686F484F

Re: Using pulldata to populate a text field from select_multiple?

MichelleTanner — Thu, 19 Nov 2020 01:26:32 GMT

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.

Re: Using pulldata to populate a text field from select_multiple?

Shwu-jingJeng — Thu, 19 Nov 2020 18:06:52 GMT

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.

Re: Using pulldata to populate a text field from select_multiple?

m3 — Wed, 12 May 2021 17:08:40 GMT

How and why is this marked as the solution?

Re: Using pulldata to populate a text field from select_multiple?

Shwu-jingJeng — Fri, 14 May 2021 22:04:06 GMT

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?

Re: Using pulldata to populate a text field from select_multiple?

m3 — Fri, 14 May 2021 22:19:27 GMT

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.