I have a property inspection feature layer and a related table for the inspection details. Each time an inspection is performed I want to create a report, but I don't want the report to include details of every previous inspection done on the property; I just want to include the details from the latest inspection (related table entry).
date_field = (select max( date_field ) from table)
Thanks for the response TL2. So would I apply this in the syntax on the form template?
Or as a filter on the related table in the web map?
Or I see there is a filter option within the Survey123 page when under the 'Data' tab?