I am working on creating a Survey123 for staff to conduct inspections on assets on a biweekly basis. There are dozens of questions (with images) for each inspection. There is an email field for whoever is responsible for maintaining that asset, which ideally will be used to send out an automated feature report to that email after each inspection.
Feature reports seem to include ALL repeats related to that feature, but I would like to generate a report for only the most recent repeat. We would not want all repeats to be put into one report, and don't want to accidentally send out the wrong one either. It will likely be a fairly long report for just one record as well.
Is this workflow possible? Are there ways the survey and/or feature template need to be set up to achieve this?
Note: I believe I saw some resources or other posts on how to sort the records such as by alphabetic order i.e., by state or creating an index field for records to obtain the first one, but not sure if that would apply here. We do have a date inspected field (in the related table).