Asset inspections using related tables in Survey123 and Collector

3676
10
11-12-2019 11:38 AM
StephanieBoyum
New Contributor II

Hello,

Ismael Chivite‌, James Tedrick

Our Public Works Department would like create an Asset Inspection workflow using Collector and Survey123. The idea is to view the asset on the map in Collector, tap on it, and be able to edit existing attributes if needed. In addition, there would also be an embedded Survey123 URL in the pop-up that would open a Survey123 form with questions related to asset inspections. Once an inspection has been submitted, we would like to view past inspection records by clicking on the asset in Collector and viewing the related records. The goal is to have the inspection related to the feature and not have a new feature created with every inspection.

I have set up a secured feature service with both the features to be inspected and an empty related table for inspections that are being related with GlobalID and GUID. I created a survey in Connect using the feature service as a template and set the survey submission URL to read a secured feature service that passes through AGOL (with credentials stored) from our ArcGIS Server.

Next, I open the survey from the pop-up in Collector (using the custom URL scheme) and fill out the form in Survey123. The problem I’m running into is when I submit the survey, it’s not just going into the related table, but it’s also creating a new feature in the feature class. I just want the inspection to be a related record to the asset I’m inspecting and not create a whole new feature for each survey. Is there a way I can set up this workflow so that each inspection (survey) is related to the asset I’m inspecting without creating a new point?

10 Replies
BlytheSpendlove
Occasional Contributor

Evan OlivierDoug Browning‌ Thank you both very much for your valuable input!

After lots of troubleshooting I figured out that my root problem was that instead of referencing the parent project boundary layer in the "form_id" column in settings, and then getting fancy with repeats, I needed to create a form that only referenced the child record. Otherwise it would create a new project boundary (parent) feature every time I submitted a survey to add a child record, even if I didn't give the user an option to change anything in the parent layer.

To keep the parent-child relationship intact, I pulled the GLOBALID field from the project boundary in the map (the custom url launches from the project boundary [parent] pop up), and made it equal to the GUID in the survey for that child record.

Thanks again very much for the help!

Best,

Blythe Spendlove

0 Kudos