Page 1 of 1

Improve Auto-increment

Posted: September 3rd, 2018, 12:00 pm
by arkagwa
Dear ALL

The current feature only works for highest number...example i have 1 to 1000 questionnaires. I have started entry from questionnaire number 1 to 500 then jumped to 800 up to 1000. May be the range of questionnaires with numbers 501 to 799 had problems and supervisor was still working on them. When i re-assume data entry starting with 501 auto increment switches to 1001 in the next case....instead of 502.

Dear Josh and other help on this feature or alternative solution

Good evening

Re: Improve Auto-increment

Posted: September 4th, 2018, 6:29 am
by josh
You can use the keylist function to get a list of all the id's of the cases that have been entered so far. Using that you can implement your own auto-increment like field that will fill in the gaps like in your case.