topic Re: pulldata() to geopoint the facility being surveyed, not location of submitter in ArcGIS Survey123 Questions

pulldata() to geopoint the facility being surveyed, not location of submitter

branden_villalonaVillalona — Wed, 25 Mar 2020 17:23:39 GMT

I'm trying to do a pulldata() function to do the following: I have a list of facilities to choose from, and want the survey location to be recorded as the address of the specific facility that is chosen from the dropdown menu. The reason I need to do this is so that I can attach the survey to the facility when used as a service layer in AGOL. Does that make sense? I don't want the survey to be geocoded to where the person is when the complete and submit the survey.

I've been working on it the entire day and for some reason, it keeps returning the wrong X,Y coordinates for some and is returning nothing for others. Here is what I have:

NOTE: PortAddressC is the csv file

COMPANY is the list of facilities that match up to the port_authority_list

PLEASE HELP ME! I'm losing my mind.

Re: pulldata() to geopoint the facility being surveyed, not location of submitter

Jim-Moore — Wed, 25 Mar 2020 23:14:36 GMT

Hi Branden

At first glance your XLSForm looks okay (besides a superfluous closing parenthesis on the location calculation). Could you please provide your XLSForm and CSV so I can take a closer look? You can attach files to a GeoNet post using the 'advanced editor'.

Best,

Jim

Re: pulldata() to geopoint the facility being surveyed, not location of submitter

josevaldes1 — Thu, 26 Mar 2020 12:48:56 GMT

i have a similar problem and this is what i do to fix:

in this case ${patietcity} is porth_authority_list.

i need to check if my city is not selected and put a defautl lat lon of 0 0.

also check in the csv the values for port_authority_list is exact as in the the xlsx.

Re: pulldata() to geopoint the facility being surveyed, not location of submitter

JamesTedrick — Fri, 27 Mar 2020 18:52:49 GMT

Hi Jose,

your latcity and loncity should both only have '0' - combined, the caclulation in location would create '0 0'.