Note, this old link now appears broken.
…the sequential number I would like it to be incremented automatically on each submission from different investigator.
@allakagni please note that a globally unique incrementing number is fundamentally not possible without having a centralized service somewhere, to which all clients must call to be assigned one. This is obviously intractable when trying to fill in forms offline. Hence the usage of uuids instead for such purposes, which by the nature of their size and randomness are pretty much guarantteed wont ever be regenerated [the probablility of two clients ever generating the same uuid - called a ‘collison’ - is infinitesimally small…].
There are workarounds of sorts, eg you give every physical device a different starting number that it will increment its inernally-generated ids from, and making sure there is a sufficient gap between each assigned starting number to ensure they never overflow into another device’s number space… But this involves some pretty sophisticated workflows that you may not wish to embrace.
Hope that helps explain. Basically, if you require “The tenth and eleventh digit “XXXX” shown is an individual sequential code.” then this has to be assigned by a centralized service of some kind; it cannot be done by the client on-demand when out in the field (unless you only have one client submitting forms).
