nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Encuentra más publicaciones etiquetadas con

Accepted answers

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.

All comments

DerrickWestoby

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!

PanGIS

Fantastic Derrick, it worked!

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

Thank you!

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.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.