Survey123 Connect Running Count Calculation

99
2
12-03-2018 06:12 AM
Highlighted
New Contributor III

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

Reply
0 Kudos
2 Replies
Highlighted
Esri Esteemed Contributor

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.

Highlighted
New Contributor III

James -

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

Best regards,

Colleen

Reply
0 Kudos