topic Re: Pre-populate Select One/Select Multiple fields from CSV in ArcGIS Survey123 Questions

Pre-populate Select One/Select Multiple fields from CSV

FrancisMalik — Thu, 06 Apr 2017 15:22:39 GMT

I'm developing a condition assessment form for which I would like to have all (or most) fields populated with the previous assessment data, dependent on the asset selected by the user. So far, all fields I've used (text, integer, etc.) can be pre-populated using the pulldata() calculation from a csv in the survey's media folder. However when I use the same function for a Select One or Select Multiple field, my choice filter Select One field (where the user selects an asset) no longer functions. Can a Select One or Select Multiple field use the pulldata() function without disrupting my other fields?

*Many of my Select One fields are likert questions, with a scale of 1-5, N/A, UNK. These fields would contain the actual condition assessment data that I'd like to have pre-populated.

Re: Pre-populate Select One/Select Multiple fields from CSV

JamesTedrick — Thu, 06 Apr 2017 22:40:40 GMT

Hi Francis,

At this time select_one and select_multiple questions can't be calculated from within the form. They can receive values via url parameters if the data is being loaded in that fashion. I'm adding your request to the list of of requesters for this enhancement in our development log.

Re: Pre-populate Select One/Select Multiple fields from CSV

AndrewHansford — Fri, 02 Feb 2018 01:39:03 GMT

Hi JTedrick-esristaff‌ me again. Was wondering if this has been progressed? I am keen to achieve this in the form that I am developing as well. Cheers Andrew

Re: Pre-populate Select One/Select Multiple fields from CSV

JamesTedrick — Fri, 02 Feb 2018 18:38:59 GMT

Hi Andrew,

We have not addressed this issue yet. For reference, this is listed as BUG-000101154 in Esri technical support. We are in the process of prioritizing issues to address between DevSummit and the UC; I'll see if this can be addressed in that time frame.

Re: Pre-populate Select One/Select Multiple fields from CSV

SarahAllerton — Wed, 22 Jan 2020 00:44:22 GMT

Hi James,

Have you addressed this issue? I am looking to pre-populate select_one and select_multiple questions from an external_choices list using a calculation/pulldata.

Cheers.

Re: Pre-populate Select One/Select Multiple fields from CSV

JamesTedrick — Fri, 31 Jan 2020 19:10:52 GMT

Hi Sarah,

Select_one questions were able to be calculated as of Survey123 2.7. Select_multiples will be able to be calculated with the next release (3.9).

Re: Pre-populate Select One/Select Multiple fields from CSV

KristiLeeHalpin — Mon, 02 Mar 2020 21:09:06 GMT

Hi James,

What'ss the syntax to properly use this? I'm struggling with setting up the external choices list for select_one question type. We're building a survey to collect vegetation data. Any help you're able to provide is appreciated. Thanks

Re: Pre-populate Select One/Select Multiple fields from CSV

DougBrowning — Tue, 03 Mar 2020 14:27:59 GMT

It could be you are trying to use text in your query? You cannot for some reason.

So instead put the text in a field like this

type name label Calculation

hidden fulllist fulllist "Y"
hidden nonplant nonplant "NonPlant"
hidden woody woody "Woody"
hidden herb herb "NonWoody"
hidden none none "None"
hidden unknown unknown "Unknown"

Then use those fields in your choice filter

Type=${NonWoody} or Type=${None}

or for the full list

fulllist=${fulllist} this tells it to match the column fulllist with the value in the field ${fulllist} (turns into fulllist = "Y" then matches that column below.

Sample external_choices sheet

list_name	name	label	Type	GrowthHabitSub	Duration	Foliar	fulllist
PlantsList	N	N None	None	None
PlantsList	HL	HL Herbaceous Litter	NonPlant	NonPlant			Y
PlantsList	WL	WL Woody Litter > 5 mm	NonPlant	NonPlant			Y
PlantsList	NL	NL Other Litter (plastic metal decaying animal tissue)	NonPlant	NonPlant			Y
PlantsList	DS	DS Deposited soil overlying live plant base	NonPlant	NonPlant			Y
PlantsList	VL	VL Vagrant Lichen	NonPlant	NonPlant			Y
PlantsList	GR	GR Gravel overlying plant base	NonPlant	NonPlant	NonPlant		Y
PlantsList	CB	CB Cobble overlying plant base	NonPlant	NonPlant	NonPlant		Y
PlantsList	ST	ST Stone overlying plant base	NonPlant	NonPlant	NonPlant		Y
PlantsList	ABAN	ABAN Abronia angustifolia purple sand verbena	NonWoody	Forb	Annual	Y	Y
PlantsList	ABBI	ABBI Abronia bigelovii Galisteo sand verbena	NonWoody	Forb	Perennial	Y	Y

Hope that helps.

Re: Pre-populate Select One/Select Multiple fields from CSV

KristiLeeHalpin — Tue, 03 Mar 2020 17:31:51 GMT

Hi Doug,

That's helpful, but I'm still not doing something right. I don't want to use the cascade option, but maybe I have to in order to make this work? Or perhaps my syntax for the question is incorrect. This is what I have:

type   name   label   choice_filter
hidden   fl   FullList
select_one_external list_PlantList   spp1name   Species   fl=${fl}

And my external_choices sheet looks like this

Re: Pre-populate Select One/Select Multiple fields from CSV

DougBrowning — Tue, 03 Mar 2020 19:37:10 GMT

Looks like you have the list name wrong.

In the external_choices sheet you call it PlantList but in the type column you have select_one_external list_PlantList. Should just be select_one_external PlantList. Not sure why you are putting list_ in front of it.

Try that but the special char | may cause an issue. For sure make sure your external list has no Commas at all in it.

And yes choice_filter must have at least something in it. You can make it be the whole list like you are but it need something.

Hope that works.