Join records from two surveys together

1202
3
07-16-2019 11:45 AM
OmairJaved
New Contributor II

Project Goal:

We would like to create an app that allows administrators to create project sites (one location) which contain trees each with their own locations. The admins require a "smart form" to enter all the information and then we will have people go out in the field and collect information for each tree. The latter will require both a "smart form" to input information as well as having easy access to all trees using a map view for quickly choosing a tree to collect information for.

Current Implementation:

Using Survey123, we are creating a survey to enter information about a project site which contains a repeat that allows  multiple trees to be associated with the project. After the survey is submitted and a record is created, field users can use the Collector app to select the trees based on their location. The popup when selecting a tree has a custom url link to another survey (which is a copy of the above survey but only uses the fields within the repeat) so that it is prepopulated with the existing tree information and the user can add the remaining tree information.

Problem:

When the user submits the custom url survey, a "copy" of the record is made in a separate database. The desired behavior is to have the original record update after the "copy" record is submitted using some kind of post processsing. What options do we have to achieve this? Is there is a simpler way instead of the current implementation we have?

0 Kudos
3 Replies
DougBrowning
MVP Esteemed Contributor

I did it using Relationship classes to tie 9 together.  See the post here  https://community.esri.com/thread/221263-mapping-with-survey123-within-a-polygon-or-admin-unit 

0 Kudos
OmairJaved
New Contributor II

Thanks for the reply. Are you referring to this comment? I haven't really worked much with geodatabases before. Is this something that would be done in ArcGIS Desktop or would I use some other program?

0 Kudos
DougBrowning
MVP Esteemed Contributor

Yes.  I use Desktop to combine and create.

0 Kudos