I have a survey123 form set up with repeats to complete inspections. The records are all associated with a group, each group may have multiple records per year in submitted to the survey. So there might be 3 inspections for Group A that all have 5 individual POIs. I want to create one report which shows all of the POIs that failed inspection over the course of a year for Group A. This is similar to a summary report, but I need to be able to show the individual POI data in the report. Essentially I am looking for a report that says Group A has 7 POIs that failed inspection this year and here's which ones. I don't need to include any data from the parent records.
We currently have a feature report that is generated when a new record is submitted, I would like to keep that format. My initial thought was to use python to find all the failed POIs for each group and create a bogus record in the feature class to hold those (as if it was an inspection with a bunch of failed points). From here, I could just generate the report using the existing template. This actually works, but my POIs have attachments and I can't figure out how to add those to the 'new' POIs so I can see them in the final report.
Is there a better approach here? Or a method to add attachments to a feature via python?
