Inspections Data Management - looking for suggestions

[Tiff]

Hello all! I'm hoping to gather input and suggestions about best practices and data management when it comes to mapping inspections - such as outfall inspections and evaluations, stormwater inspections, etc.

Here are two options in mind, with examples:

1. A feature layer for storm drains/outfalls/etc. AND an unrelated feature layer to map outfall inspections (e.g., one point for each inspection) with a common ID.

2. A feature layer for storm drains/outfalls/etc. AND a related table containing all outfall inspections.

I know best practices for data management will often point towards #2; however, there are such limitations to visualizing data and trends with related tables using ArcGIS Online as well as other potential data collection issues (bugs associated with AGOL arcade calculations with related tables), I'm wondering if anyone has more to share regarding either option, what their organization does, and any advantages/pitfalls that they've experienced.

Thank you!

[Tiff]

Hey @MGAL, I'm not actually sure where the discrepancies are with Field Maps, but I've had a good experience with using Field Maps to track related records. Where I've gotten stuck is using the FeatureSetByRelationshipName function in Arcade (mainly because of having to confirm and track down the relationship name, lol). 

Looking at the roadmap post you linked though, maybe I'm misunderstanding the functionality? In any case, improvements to related records is absolutely what I'm looking for and definitely needed - albeit a little late... Thanks again!!

[MGAL]

Where I've gotten stuck is using the FeatureSetByRelationshipName function in Arcade

---

Now I'm curious! What do you mean by track? And where exactly are you tracking it in Field Maps? 

[Tiff]

So what I have been able to do is create a field map with a feature layer and associated related layers or tables, and use field maps to add related records. I'm not sure if that is the limitation you've run into!

Two examples below. It looks like they've changed the appearance to include related records at the bottom (looks much more intuitive than the chain-link button they used to have on the bottom right of the map: 

Now you can see that it includes "Sampling Plots" as a related table (example #1) and also alternatively you can see the "Related" chain-link icon at the top (example #2).

[MGAL]

Sweet - thanks for this. I opened the map that I created here on mobile and this worked? Weird seeing as it gave me a "not supported" message in Field Maps designer. 

thanks again!