I intend to generate a '6 ’ character unique ID for each of my respondents.
Which of these random number functions would be the most effective to do the job, interms of performance.
@Kal_Lam , yes! using a random functions. for just 6digits numbers
I dont want to use this formular:
concat(substr(today(), 0, 4), substr(today(), 7, 5), substr(today(), 10, 8), substr(now(), 13, 11), substr(now(), 16, 14), substr(now(), 19, 17))
It works best in Enketo webform.
I need formula that goes fine in kobocollect.
The rand function i stated above ;which one of them works with no repeats?