CONCAT (String and numbers)

[barata_clicia1]

Hello, I would like to build a unique code using concatenation of previous questions, example:
1-State: MT
2-Project name: SIPA
3- Identity number: 56589785584
4- Name of person: Maria do Carmo Silva
3- Date of birth: 05/12/1980

Code formation: STATE + PROJECT NAME + last 3 digits of ID number + first letter of person’s first and last name + last 2 digits of year of birth = MTSIPA584MS80

Can you help me?

[wroos]

To get trailing digits you can use

• the mod operator, e.g. 123456 mod 1000 = 456. See XML Path Language (XPath) (and,Modulo - Wikipedia)
• the substr() function, e.g. substr( string(123456), 3, 6 ), see
  ODK XForms Specification.

The 2-last-digit year you can get with format-date( …, %y ), see ODK XForms Specification.

Hint:

• Type integer is limited to 9 digits, see Question Types - ODK Docs.
• Decimal is limited to 14 digits, see Question Types - ODK Docs.
• Bigger numbers would need type text with appearance number, see Question Types - ODK Docs.

[jbindrookobo]

Create a calculate variable and use concat() function to stitch all the codes together to get required ID. Use delimiter of your choice in between.

[Kal_Lam]

@wroos, @jbindrookobo,

[Kal_Lam]

@barata_clicia1, here are some workarounds on how you use the mod function, substr function and the format-date function. These workarounds discussed previously in the community should help you understand how they are used.