Unique ID from Selected Variables - Error: ODK

Hello,

I am trying to create and unique ID from selected variables.
I added a calculation column on my xls form to use the concat() expression.

I followed the steps of the article : Creating unique ID from Selected Variables.

The following error message appears when I deploy the form :

Error: ODK Validate Errors:

XForm is invalid. See above for the errors.
: Invalid calculate for the bind attached to “${ID}” : null in expression ( ${Prenom_c} ,‘-’, ${Nfamille_c} ,‘-’, ${Age_c} ,‘-’, ${District_c} ,‘-’, ${Cellule_c} )

The following files failed validation:
${Plan} d’accompagnement - Projet Parent .xml

Result: Invalid

Even if I use the XlsForm validator, I am still not able to understand my errors.

Can someone please help me on this ?

Thank you!
Nadia

Plan d’accompagnement - Projet Parent .xlsx (16.6 KB)

Hi @Nadia_EDUFAM seems like you forget to add concat function before the:
(${Prenom_c},‘-’,${Nfamille_c},‘-’,${Age_c},‘-’,${District_c},‘-’,${Cellule_c})

So changing that to:
concat(${Prenom_c},‘-’,${Nfamille_c},‘-’,${Age_c},‘-’,${District_c},‘-’,${Cellule_c})

should solve the issue.

2 Likes

Ahhhh thank you so much!! It works now :blush:

2 Likes

@hakan_cetinkaya, :clap: :heart: :partying_face:

2 Likes