Is it possible to use both first and last name to uniquely identify a respondent and populate fields the child form with other relevant data (age, sex, medicines received) collected in the parent form?

[iancg]

Good day! I would like to use dynamic data attachments as follows:

1. The parent form will be used to collect data for a scabies prevalence survey.
2. The child form will be used to collect follow-up data for respondents diagnosed with scabies and received treatment.

Currently, respondents do not have a unique identifier. Is it possible to use both first and last name to uniquely identify a respondent and populate fields the child form with other relevant data (age, sex, medicines received) collected in the parent form?

In the support article example, it seems that the Identification Number (C_SN) is necessary to identify a respondent and fill-in the necessary data in the child form from the parent form?

[Kal_Lam]

Welcome back to the community, @iancg!

@iancg

In the support article example, it seems that the Identification Number (C_SN) is necessary to identify a respondent and fill-in the necessary data in the child form from the parent form?

If you have a variable that can hold the concatenated version of the variables in the very parent form, you should be able to link the variables to your child form based on the same variable.

E.g., if you have an id variable from a concatenated variable, say name, age, sex that is stored in your parent form. The variable would be like name-age-sex. You could use this variable to pull the information to your child form. But the thing is that you will need to know the value of this variable that is entered in the parent form.

The dynamic data works like the pull-data function. The only difference is that the values are stored in a CSV file in a pull-data function, while in dynamic data, the values are stored in a parent project. Without knowing the value from an identifier, even in a pull-data function, you would not be able to pull the values stored in the CSV file.

I hope I was able to explain your query!

[iancg]

Thanks for the quick response, @Kal_Lam ! Is it possible for Kobo to create a concatenated variable automatically? I like the idea of using name-age-sex as a potential ID variable instead of generating a specific ID variable.

[Kal_Lam]

@iancg, you will need to design this on your part. The system will then support that variable if it is stored.

[JaidenKason]

@Kal_Lam

If you have a variable that can hold the concatenated version of the variables in the very parent form, you should be able to link the variables to your child form based on the same variable.

E.g., if you have an id variable from a concatenated variable, say name, age, sex that is stored in your parent form. The variable would be like name-age-sex. You could use this variable to pull the information to your child form. But the thing is that you will need to know the value of this variable that is entered in the parent form.

The dynamic data works like the pull-data function. The only difference is that the values are stored in a CSV file in a pull-data function, while in dynamic data, the values are stored in a parent project. Without knowing the value from an identifier, even in a pull-data function, you would not be able to pull the values stored in the CSV file.

I hope I was able to explain your query!

I noticed your answers selected as the best solutions in this community, I also require some little help regarding my project, do you have some time for me to guide me using your expertise. I would be thankful.