topic Re: Auto populate in Survey123 from existing feature attributes in ArcGIS Survey123 Questions

Auto populate in Survey123 from existing feature attributes

ShelbyPW1 — Tue, 01 May 2018 18:47:44 GMT

I am trying to use ArcGIS Online and Survey123 to create an inspection form that works against an existing feature. For example; I have a bunch of construction site points that I need to conduct various inspection on. I am having trouble getting some of the fields to auto populate in survey123 from the existing feature (Project Name, Project Type, Permittee, etc). If someone could point me in the right direction I would be very appreciative. I have attached a copy of my spreadsheet. Thanks.

Re: Auto populate in Survey123 from existing feature attributes

DougBrowning — Tue, 01 May 2018 19:01:14 GMT

I assume you mean pulling from Collector? If so your URL should look like this where the {} are from Collector and the others are the name of the field in Survey123 so Survey123field = {CollectorField}

arcgis-survey123://?itemID={FormIDHere}&field:Office={Office}&field:PlotID={PlotID}&field:PlotKey={PlotKey}&field:GapData={GapData}

See page 7 of this post for more

https://community.esri.com/groups/survey123/blog/2016/07/30/understanding-survey123s-custom-url-scheme?messageTarget=all&start=150&mode=comments

Re: Auto populate in Survey123 from existing feature attributes

TiffanyRufo — Tue, 01 May 2018 19:02:45 GMT

https://community.esri.com/groups/survey123/blog/2016/07/30/understanding-survey123s-custom-url-scheme

This blog post is my cheat sheet to passing values from a point/polygon in collector (Arc Online) to Survey123 fields

Re: Auto populate in Survey123 from existing feature attributes

RobBlash — Wed, 02 May 2018 12:53:07 GMT

Also see this post if any of the fields you're trying to pass have a domain (Collector will pass the description in the URL and not the coded value), which makes things a bit difficult.

https://community.esri.com/thread/213202-question-about-spaces-in-survey123-connect-name-fields-of-choices

Re: Auto populate in Survey123 from existing feature attributes

TimothyMichael — Wed, 02 May 2018 13:52:00 GMT

To make this easier (and to not have to refer to the documentation every time...) I made an Excel sheet to help me build the link to pre-populate items in Survey123. I attached a copy here, feel free to modify and use.

Re: Auto populate in Survey123 from existing feature attributes

ShelbyPW1 — Wed, 02 May 2018 14:20:52 GMT

Thanks everybody,

I've gone through and updated my spreadsheet but now I am getting a "The custom feature service submission url is not compatible with this survey (Request Error)." I'm not really sure to go from here. Thanks again for all of your input. I've again attached a copy of my spreadsheet.

Re: Auto populate in Survey123 from existing feature attributes

JamesTedrick — Wed, 02 May 2018 20:55:24 GMT

Hi Brett,

The submission URL setting is used when you are submitting to an existing feature service; you appear to have a URL to open Survey123 there.

Re: Auto populate in Survey123 from existing feature attributes

ShelbyPW1 — Thu, 03 May 2018 12:36:38 GMT

James,

Thanks for your help. I guess I'm a little confused. I chose the existing feature option in Survey123 Connect and chose the existing feature service I was hoping to auto populate from (construction site). Do I need to create another feature service for inspections and use the submission url for the actual construction site feature service? Thanks again for your help.

Brett

Re: Auto populate in Survey123 from existing feature attributes

JamesTedrick — Thu, 03 May 2018 15:18:16 GMT

Hi Brett,

If you chose the Existing Feature Service option, the submission_url should have looked something like https://www.arcgis.com/sharing/rest/content/items/0123456789abcdef0123456789abcdef when the form was first created; the first part will be different if you're using ArcGIS Enterprise; the very last part will be a different 32-character set that corresponds to the item ID of the feature service's content entry. That is the link to feature layer for submission and can't be altered. This is the first step for loading data from an existing feature service into a form for editing/revising. The second step is to enable the Inbox (see Prepare for editing existing survey data—Survey123 for ArcGIS | ArcGIS ); the Inbox functionality allows for the editing of the data in the feature service (as opposed to simply adding more information to the feature service, which is the default behavior). Note that editing existing data does not work in the same scenario as opening Survey123 via Collector (using the application-specific arcgis-survey123:// URL)

Re: Auto populate in Survey123 from existing feature attributes

RaviKamarajugadda1 — Fri, 04 May 2018 14:56:32 GMT

Hi Brett,

Do you have any kind of Excel or CSV file which shows relationship between Construction Site vs Project Name, Project Type and Permitee Etc.. so that you can upload CSV to Survey123 and use Pulldata() function. You can change appearance for the fields you want to AUTOCOMPLETE

Re: Auto populate in Survey123 from existing feature attributes

ShelbyPW1 — Fri, 04 May 2018 15:18:44 GMT

I think I figured it out. I was unsure where to copy the custom url that allowed me auto populate. I ended up attaching the custom url to a feature service pop up. Not sure if that is the best method but it worked for me. Thanks.

Brett

Re: Auto populate in Survey123 from existing feature attributes

NatashaDakouri-Hild — Sun, 09 Jun 2019 04:31:50 GMT

Hi all. I am having a similar issue. I created a survey using an existing feature service in AGOL through Survey123 Connect. The feature service has polygons (agricultural tracts) and fields that describe various attributes. That process went fine and the survey looks great. Using these instructions (Uhttps://community.esri.com/groups/survey123/blog/2016/07/30/understanding-survey123s-custom-url-scheme I added a custom attribute display url to the layer in AGOL to call up the survey form in Collector. Because I want the survey form to have the area and tract ID prepopulated I added the relevant fields too:

arcgis-survey123://?itemID=69c04a817b534bddb2eeef3d0f7c2832&field:Tract area={Area__m2_}&field:Tract ID={Code}

Basically I'd like to see this behavior: user goes to Collector, clicks on a polygon in the tract layer, and the link to the survey opens up with the name of that specific tract showing in the tract ID field of the survey and its area prepopulated. What am I doing wrong? While the survey is correctly linked in the Collector app when I edit the layer, the fields do not prepopulate. I did a test data entry and the survey simply creates a new entry.

I have enabled inbox btw.

Thanks!

UPDATE: okay, figured it out. So for those poor bastards who are doing this from scratch (like me), if you have an existing AGOL layer you want to connect to a new survey, here are the steps:

1. Make sure the layer is properly shared with the same group as the survey. Make sure your fields are finalized before the next step. Make sure the layer has sync and full edit abilities selected (and attachments enabled if you plan to have an attachment field in the survey). (If you enable the attachments first then do allow the edit/sync you may have to disable the attachments and enable again for some reason).

2. Create the survey (best to do this in Survey123 Connect). Make sure the survey uses exactly the same names and types of ESRI data as the layer on AGOL (check the schema in Survey123 Connect to be sure).

3. Publish the survey to the existing feature layer. This can be updated after you publish it from Survey123 Connect (make the needed changes and republish to the same layer).

4. Next, go to AGOL and open the map that contains the feature layer. From Content, highlight the layer in question and select Configure popups.

5. Select Custom Attribute Display. Click on the green Configure button and select the link icon.

6. Go to survey123.arcgis.com and select the by now published survey. Select Collaborate in the green ribbon, then from Link below select Open the survey directly in the app. Click that link next to the sentence (Learn more about this option) and copy survey link e.g. arcgis-survey123://?itemID=69c04a817b534bddb2eeef3d0f7c2832

7. Go back to AGOL and the Custom Attribute Display interface. In the URL field add the link above.

8. If you want some fields prepopulated from the AGOL layer, add the relevant fields with ampersands right after the survey link. E.g. arcgis-survey123://?itemID=69c04a817b534bddb2eeef3d0f7c2832&field:Tracts={Tracts}&field:Area={Area}&field:Code={Code}

Note that in the formula above the field names without brackets must correspond exactly (including any capitalization) with the survey field names where the information is to be autofilled and the field names with brackets must correspond exactly with the fields of the AGOL layer from where the autocomplete data is to be pulled.

I still can't stand how complicated all of this needs to be. ESRI, come on! This is key functionality, it shouldn't be this obscure to figure out. How about some better documentation? How about a push option to connect to an AGOL layer straight from the Survey123 app? Been a long, long day.

Re: Auto populate in Survey123 from existing feature attributes

DougBrowning — Wed, 12 Jun 2019 21:10:02 GMT

You can built a form right from a feature service.

Re: Auto populate in Survey123 from existing feature attributes

NatashaDakouri-Hild — Mon, 17 Jun 2019 14:42:14 GMT

Of course, I have uploaded the survey to an existing service. But that's not my problem -the issue was how to pass data already in some fields into the survey form to avoid redundant typing, and how to integrate the survey with Collector which shows you the specific polygons that are being added with attribute data. Very clumsy solution, but it works. ESRI needs to streamline this.

Re: Auto populate in Survey123 from existing feature attributes

NatashaDakouri-Hild — Mon, 17 Jun 2019 14:44:24 GMT

Also, once in the survey there seems to be no easy way of going back to Collector unless one hits the back button repeatedly. But I have now also built a call back code in the popup to speed that up a bit. Still not ideal if you're dealing with hundreds of polygon edits/survey adds in a day.

Re: Auto populate in Survey123 from existing feature attributes

YuyingLi — Tue, 13 Aug 2019 00:29:56 GMT

Hello - thanks for sharing. I had the very similar situation but it seems to always create a new record instead of editing the existing record? Or do I miss anything?

thanks,

Yuying

Re: Auto populate in Survey123 from existing feature attributes

JamesTedrick — Tue, 13 Aug 2019 20:30:38 GMT

Hi Yuying,

Currently, the field app only supports creating a new feature when opened via a URL, not editing an existing feature.

Re: Auto populate in Survey123 from existing feature attributes

YuyingLi — Tue, 13 Aug 2019 23:23:21 GMT

James,

Thank you for confirming it. I have a separate question – I thought with the latest 2.4, related table could be edited?

In Survey123, it seems I still couldn’t edit the related data? If still the case, how should I edit the record? In Survey123 app?

Yuying Li, GISP

D 858.712.8381 M 858.380.8024

hdrinc.com/follow-us<http://hdrinc.com/follow-us>

Re: Auto populate in Survey123 from existing feature attributes

JessicaJThompson — Thu, 01 Apr 2021 15:41:41 GMT

Hello James,

I believe I am trying to do something similar to @NatashaDakouri-Hild's work in 2019. It now being 2021, is there a way to do this just in Survey123 (Using Survey123 Connect 3.11.123 and hoping to put into Experience Builder or WebApp Builder for the survey team, though may just default to Survey123 App).

I posted a question today at the following (Re: Select Parcel (Polygon) in Linked Map & Pull D... - Esri Community), and was referred to this discussion.

Thanks for the assist!

Re: Auto populate in Survey123 from existing feature attributes

GeorgeHilton__GISP — Tue, 04 May 2021 17:06:15 GMT

This works very well, however is there a way to use the value being passed from collector to set the value of a note in Survey123 that is simply text designed for display only in the survey?