Select to view content in your preferred language

Survey123 Connect Related Table Issue

1174
2
Jump to solution
07-05-2023 12:07 PM
ChristopherMask
Regular Contributor

The form creates a row in both the Parent Table and the Related Table. I would like the Survey to create a new row in the  FIAStaffLevels upon submitted survey. The issue is the survey creates a row in the SouthernRegionStateBoundary and the FIAStaffLevels. 

Currently, after a survey is submitted, I have to fix the GUID in the related table(FIAStaffLevels). Then, I removed the the row from the boundary table. 

Is there a setting in the connect123 to fix the issue?

Below are the applications for reference. 

 

Thanks in Advance

Survey:

https://arcg.is/1O0v0K1

 

Dashboard:

https://www.arcgis.com/apps/dashboards/edcebb159ddd4462926eaa6048f83013

0 Kudos
1 Solution

Accepted Solutions
ChristopherCounsell
MVP Frequent Contributor

A survey by default will collect new data. The survey you have shared will collect a new polygon, and one or more FIAStaffLevels records in a  related table. 

The related records will be related to the parent record of the survey (the new polygon you have created).

What you are looking to do is collect related records against existing points. There are two ways you can do this:

  • Survey123 Inbox > Update polygon and add related. NOT suitable for public surveys.
  • Survey123 custom URL targeting the related table only, and passing the state boundary globalid.

So what you should do is:

  1. Have a map with all your boundaries in it.
  2. Create a Survey only targeting the 'FIAStaffLevels' layer, NOT the whole layer.
  3. Add a parentglobalid field to the survey. Hide it. This will be populated by a custom URL.
  4. Create a custom URL from the map State Boundaries pop-up. The custom URL will launch the survey form and pass the globalid of the boundary into the hidden parentglobalid field.

Congrats, you can now add surveys against the existing boundaries.

A (dated) video showing this workflow is here:

https://youtu.be/vECznnoJHGk?t=2527

View solution in original post

Click here for more advanced ArcGIS Survery123 training: http://p.ctx.ly/r/9f6u This session provides a deep dive into authoring forms with ArcGIS Survey123 and discusses deployments of Survey123 for ArcGIS with your own ArcGIS for Server and Portal for ArcGIS.
2 Replies
ChristopherCounsell
MVP Frequent Contributor

A survey by default will collect new data. The survey you have shared will collect a new polygon, and one or more FIAStaffLevels records in a  related table. 

The related records will be related to the parent record of the survey (the new polygon you have created).

What you are looking to do is collect related records against existing points. There are two ways you can do this:

  • Survey123 Inbox > Update polygon and add related. NOT suitable for public surveys.
  • Survey123 custom URL targeting the related table only, and passing the state boundary globalid.

So what you should do is:

  1. Have a map with all your boundaries in it.
  2. Create a Survey only targeting the 'FIAStaffLevels' layer, NOT the whole layer.
  3. Add a parentglobalid field to the survey. Hide it. This will be populated by a custom URL.
  4. Create a custom URL from the map State Boundaries pop-up. The custom URL will launch the survey form and pass the globalid of the boundary into the hidden parentglobalid field.

Congrats, you can now add surveys against the existing boundaries.

A (dated) video showing this workflow is here:

https://youtu.be/vECznnoJHGk?t=2527

Click here for more advanced ArcGIS Survery123 training: http://p.ctx.ly/r/9f6u This session provides a deep dive into authoring forms with ArcGIS Survey123 and discusses deployments of Survey123 for ArcGIS with your own ArcGIS for Server and Portal for ArcGIS.
StephenMc_84
New Contributor

Create a custom URL from the map State Boundaries pop-up. The custom URL will launch the survey form and pass the globalid of the boundary into the hidden parentglobalid

I have a similar workflow setup using survey123 connect. My custom url generates the ParentGlobalID when I click on a point, but refuses to populate the field in related table. It works if I copy from it in from the URL perfectly. 

Anyone offer any further insight? Tried everything I can find online.

0 Kudos