Create report for the last repeat only - help with syntax

PanGIS

Hello! 

 

I need to create a report the prints only the last repeat submitted.

I am implementing the flow in Integromat but what I get as attachment is all the inspections contained in the repeat:

 

I suppose it should be something like the following but, of course, it is wrong.

 

${#Repeat | stats:max,surveyDate} 

${/}

 

Thanks! 🙂

DerrickWestoby

 

I believe this will do it for you (or get you close)

${#repeat_name | orderByFields:"ObjectID DESC" | resultRecordCount:1}  ${field_in_repeat} ${/}

This will print out the records in "repeat_name" in descending order by ObjectID, with a maximum of 1 record returned.