topic Re: pulldata function not working with external_choices in ArcGIS Survey123 Questions

pulldata function not working with external_choices

ErickWiggs2 — Mon, 24 Apr 2017 14:54:54 GMT

Howdy,

I am trying to use the pulldata function to autopopulate my survey based on an external_choices return.

I have set up the external select as a cascade based on a field in the choices tab:

As you can see here, once the Zone is chosen, it will give back those addresses within the zone.

The external_choices table is set up with the name = a UID for the label = address. For example:

What I am attempting to do further into the survey is auto-populate coordinates via the pulldata function based on the name UID.

pulldata('MLGW_AreaA','X','Premise',${PREM_CODE})
pulldata('MLGW_AreaA','Y','Premise',${PREM_CODE})
where the file name is MLGW_AreaA and the file looks like this:

all of this should work. but it is not.
I have attempted to change the field it's pulling the data from to both the Premise and the Address fields, but nada.

I should state that I am using vers. 2.0.29

Any suggestions??

Re: pulldata function not working with external_choices

ErickWiggs2 — Mon, 24 Apr 2017 15:54:51 GMT

I have figured out my issue. I just switched over from using the premise UID to just the address.

I attempted to use the int(), string(), and number() functions on the Premise UID but those didn't work. Altering the link to be the Address (and thus just a string) seems to work wonders.

Re: pulldata function not working with external_choices

JamesTedrick — Mon, 24 Apr 2017 17:36:10 GMT

Hi Erick,

As you point out, the issue is probably a text conversion - you may want to try explicitly setting the name values in your choice list to text in the Excel sheet (by default, they're saved as numbers).