Dear Experts,
I am not a programmer though I am preparing a XLSForm for data collection.
I caught in a trouble when developing the form. The problem I am facing is,
Automatic display of Household Identification Number in a box. For example,
Region Name: Barisal
District Name: Chandgaon
Cluster Name: Rahalia
Village Name: Pandgaon
Household Serial Number: 0012
Household Identification Number will be: 3 letter for Region Name-3 letter of District Name-3 letter of Cluster Name-3 letter of Village Name-Household Serial Number (will automatically display like: BAR-CHA-RAH-PAN-0012)
If anyone help to solve this issue to develop in XLSForm would be highly appreciated.
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):
Dear Kal_Lam,
It really works. Thank you so much for your support and cooperation.
One challenge observed, This might be my mistake not to mention.
While Household Serial Number will be exactly 4 digits, this would neither less nor more.
Hello,
just take care, This will NOT automatically control that this ID is unique allover your survey. A second enumerator could create the same for her/his form.
If you need an overall unique identifier you will find other threads in the community (… unique ID …)
