Hi everyone !
I am currently building a questionnaire for a screening campaign and I’d like to create automatically calculated identifier based on the data in the questionnaire. So far, I have found this formula which seems to work well :
concat(substr(${Gender},0,1),round(${today}-${dateofbirth},0),substr(${Screening_place},0,3))
My question is on this specific part : round(${today}-${dateofbirth},0). I would like to understand how Kobo calculates this equation.
example : for the today date of 2020-04-25 and birthdate of 1995-08-24 I get the number series 27743. Does someone know the math behind it?
I have also thought of simply using the _id meta data variable. How could I make it visible in my questionnaire ? We need to give this number to the persons we interview so they can get their screening results. Our staff also needs to reopen the questionnaire and fill additional questions when they receive the person’s screening results.
thanks a lot !
Victoria.
I