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.
S R 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):
You will then see the household identification number in the output as follows:
You could also have a look at the support article on How to: Create Sequential, Unique Serial Numbers.
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.
Thanks again for your support and cooperation.
Could you please give me the xls copy of this document
Please find the requested xlsform for the same.
Unique ID (From Selected Variables).xls (34 KB)
Have a great day!
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 …)