Help in CONCAT()

[apulikkal]

I used the following to concatenate two integers:
→ concat(${interview_code},${id})

I am able to see that it is working on the webform however, it is not working while testing on kobocollect. Please help

[wroos]

Did you check your form with the online validator?
You may add concat(string(…), string(…)).
See ODK XForms Specification.
For joining numbers you can often use multiplication plus addition. E.g. 1000*${sectionNumber} + ${householdNumber} if the household number is 1 to 999.

[Kal_Lam]

@apulikkal, here is also a good example of concat that has already been discussed in the community forum previously:

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.