Concatenation of answers

[nohandoye]

Hello,
I have a variable “Your Region” and a second variable “Interviewer Name”. I want a third variable (ID) to be generated, which is a concatenation of the answers to the first 2 variables. How do I do this? Thank you

[hakan_cetinkaya]

Hi @nohandoye and welcome back to the community!

There are some posts you can check to do create Unique id’s: If no one of those fit your needs, let us know

Automatically displaying unique ID number

Hi @Dhamai, Welcome to the community! Please see the image below to create an automatic display of the household identification number (you will need to do this in the xlsform): [Picture%201] You will then see the household identification number in the output as follows: [Picture%202] You could also have a look at the support article on How to: Create Sequential, Unique Serial Numbers.

Creating unique ID from the available variables using calculate

Hi @tanzilhuda, Please see the attached (slightly edited and refined version) xlsform where @Xiphware and @azadkhan had contributed significantly. It should now work smoothly even in the group in Enketo, KoBoCollect as well as ODKCollect. In the survey tab of the xlsform: [Image%201] In the choices tab of the xlsform: [Image%202] Screenshot on KoBoCollect: [Image%203] Reference xlsform: Unique-ID.xls (26.5 KB) GOOD DAY!

[Kal_Lam]

@hakan_cetinkaya,

[nohandoye]

Thanks you very much