Hai,
I am working on creating a unique Household ID and have developed an XLSForm for the purpose. The HH ID is intended to be generated using a combination of state, district, mandal, and block values. However, when I deploy the form, I encounter an error related to the HH ID generation.
Could you kindly guide me on how to resolve this issue? I’ve attached the relevant files for your reference:
- Unique HH ID: Unique ID (From Selected Variables) - Google Sheets
- List of districts, villages etc: https://community.kobotoolbox.org/uploads/short-url/skD8BKxog0IeTtKtXLnGyTqeYFo.xlsx
Thanks in advance
Hi @sushmadsouza22, can you also provide a screenshot of the error you are getting?
1 Like
Thank you for your response.
Please find the screenshot here
Hi @sushmadsouza22 can you check the required column of your note type question? Can you try writing FALSE in there and see if anything changes?
1 Like
No, it is still showing the error
@sushmadsouza22, kindly please check this highlighted part as advised by @hakan_cetinkaya:
That should solve your issue!
Hai,
Currently, when the state, district, etc., are in text format (in the type column), the HH ID is generated successfully. However, when I change these fields to select_one, an error occurs. I also want to include the names of the state, district, mandal, and village while generating the HH ID, and these names need to be selected from a predefined list.
I’ve attached the file I’ve been working on, but the choices for state, district, mandal, and village are not appearing. Could you please suggest how to fix this and proceed?
