AnsweredAssumed Answered

Survey123 Connect Running Count Calculation

Question asked by COMAS_orsted on Dec 3, 2018
Latest reply on Dec 10, 2018 by COMAS_orsted

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

Outcomes