topic Re: Survey123 Connect Running Count Calculation in ArcGIS Survey123 Questions

Survey123 Connect Running Count Calculation

deleted-user-sNUdtFrn2yEY — Mon, 03 Dec 2018 14:12:43 GMT

Hello -

I'm trying to write a formula that will generate a running count as each survey is entered. I used the following:

type name label calculation

calculate runningcount Count count(${Not sure which type field is the best to use here})

This formula gives me the number one, but when the second survey is entered it still gives me a one

I'm trying to get the following:

SurveyID Running Count

12345 1 1

15678 2 1 + 1

33456 3 2 + 1

67891 4 3 + 1

Thanks in advance for your help with my question.

Best regards,

Colleen Madigan Schelde

Re: Survey123 Connect Running Count Calculation

JamesTedrick — Fri, 07 Dec 2018 19:54:34 GMT

Hi Colleen,

This can be done when you are counting repeats within one form (using the formula once(count(${FIELD})) in a question inside a repeat). There isn't a method to count between separate survey submissions.

Re: Survey123 Connect Running Count Calculation

deleted-user-sNUdtFrn2yEY — Mon, 10 Dec 2018 08:03:26 GMT

James -

Thanks so much for the follow up. Appreciate your input.

Best regards,

Colleen