I have a Reference Number field, I would like to auto-populate the field with the next number, i.e. if the last Reference Number was 8 then when I create a new survey the Reference Number will auto-populate with the number 9.
Anyone know how to do this?
Thanks.
Hi John,
Currently this functionality isn't supported within Survey123. Can you elaborate a bit more on how this Reference Number is used? A use case that is problematic to support is sequential numbering- when multiple people are collecting surveys, sequential numbering can't be guaranteed.
Thanks for the reply James.
Yes, it is sequential numbering that I am referring to.
Hi,
Is it possible to have sequential numbering within one users survey;
We are trying to emulate a pad of forms that are numbered sequentially and issued to a person; so Person 1 would be given a pad with forms numbered 1-100 , person 2 forms numbered 101-200 etc
When the forms are returned they can be audited to ensure all have been completed simply by checking the sequence.
So in Survey123 the use case would be along the lines of:
Person1 goes into the field and completes surveys
Survey 1 - Complete/Submitted
Survey 2 - Complete/Submitted
Survey 3 - Not Complete
Survey 4 - Complete/Submitted
How can the manager audit Person1 and discover Survey 3 has not been completed; if they had a sequential number then you could query the database and given Survey 4 is present there must have been a Survey3.
If the sequence had to be unique to each tablet/person then username_Survey1 would be the unique key to the survey.
Thanks
Steve
You can do this with SSMS or GeoEvent.
I got this to work for repeats
In a repeat have a field with a calculate (it can be editable)
Use this formula subbing in any field in the repeat (except itself)
once(count(${RecKey}))