topic Create report for the last repeat only - help with syntax in ArcGIS Survey123 Questions

Create report for the last repeat only - help with syntax

PanGIS — Tue, 01 Mar 2022 16:28:02 GMT

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! 🙂

Re: Create report for the last repeat only - help with syntax

DerrickWestoby — Tue, 01 Mar 2022 19:44:39 GMT

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.

Re: Create report for the last repeat only - help with syntax

PanGIS — Wed, 02 Mar 2022 13:05:36 GMT

Fantastic Derrick, it worked!

With you example you also pointed me out to the right documentation.

Thank you!

Re: Create report for the last repeat only - help with syntax

DerrickWestoby — Wed, 02 Mar 2022 16:33:29 GMT

You're welcome!

Get in the habit of searching for @IsmaelChivite 's Survey123 blog posts as well. Assuming he's made one for the thing you're trying to accomplish, I find them a lot more helpful than some of the help docs.

Good luck!