Select to view content in your preferred language

Survey123 Connect Related Table Issue

563
1
Jump to solution
07-05-2023 12:07 PM
ChristopherMask
New Contributor III

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 Regular 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

0 Kudos
1 Reply
ChristopherCounsell
MVP Regular 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

0 Kudos