Creating HH ID, member ID and repeating the HH member names in subsequent sections

[sushmadsouza22]

I have query about creating member ID and repeating the appearance household member names in the subsections. I used the following formula but it is showing error. I kindly request you to provide your guidance in this regard.

The formula used for creating Household ID and member ID are as follows

Household iD: concat(${Q1_C},’${Q2_C},${Q3_C},’${Q4_C})

Member ID: concat(${Q1_C},${Q2_C},${Q3_C},${Q4_C},${Q5_C})

The formula used to repeat the names of the respondent from HH Roster

pulldata(“Household_roster”,“Name_of_the_HH_member”,${Household_roster},position(…))

[Kal_Lam]

Welcome to the community, @sushmadsouza22! You could create a unique ID by following this community post discussed previously:

Automatically displaying unique ID number

Hi @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): [Picture%201] You will then see the household identification number in the output as follows: [Picture%202] You could also have a look at the support article on How to: Create Sequential, Unique Serial Numbers.

[sushmadsouza22]

Thank you for your response. Very helpful. Can you please guide me on how to create individula member ID as well