Getting data from pre-defined set in.a field base on a selection

[esmatullaharifi]

Hi,
I have a set of data like this file “link removed” and ODK form like “link removed”.
I want that the ODK form to retrieve the name and age of relevant items for selected CDC_Code and load them in the group (repeater).
Is it possible to do so? If yes then how.
Thank you.

[Kal_Lam]

Hi @esmatullaharifi,

You could do the same using the pulldata function as outlined in the support article Pull Data () functionality in KoBoToolbox.

As a reference, you could also have a look at a simple workaround shared previously:

Trying to build a form that will use pulldata() function to verify barcode ID

Hi @henryakuete, Please see the images below to build a survey form that uses barcode as question type to pull data from the csv file. You could practice this by replacing the barcode (Code) of the csv file with the ones that you have from any of your books (this is the one that i had them with me). Just wanted to show you a demo that if you have a barcode number, you could manage them in your csv file and use the pull data function to get the desired information during your survey. Image 1 (i…

Have a great day!

[esmatullaharifi]

Thanks for your quick support.
I have two questions:

1. Do CSV files supported by ODK mobile app? If not then how I can include these data in the same form?
2. In the sample file for one code, there are many related rows in second file, then how I can retrieve all of them and place them in the repeater?
   Thanks

[Kal_Lam]

Hi @esmatullaharifi,

Regarding your first query:

@esmatullaharifi

1. Do CSV files supported by ODK mobile app? If not then how I can include these data in the same form?

Yes. You could have a look here to learn how to upload a csv file.

Regarding your second query:

@esmatullaharifi

2. In the sample file for one code, there are many related rows in second file, then how I can retrieve all of them and place them in the repeater?

Sorry could not understand this well. Could you kindly please explain it again (maybe with a simple example if possible).

Have a great day!

[esmatullaharifi]

Thank you so much for the clarification regarding my first question.
My second question in simple words:
The data to be pulled has 4 columns (CDC_Code, Household_Code, Name, Age) and in my ODK form, the first question is a dropdown called CDC_Code.
For each CDC_Code there is more than one row in the data file.
Whenever a user selects a CDC_Code then in the repeated group section Name and Age of related rows should appear. Suppose if we have 5 rows related in data file then the repeater group questions should be repeated 5 times and display that data.

[Kal_Lam]

Hi @esmatullaharifi,

Seems like you are trying to pull a multiple response data. Kindly please be informed that pulldata is able to pull the information but you should be specific (i.e. it should have an exact match).

Have a great day!

[esmatullaharifi]

So multiple pull is not possible?

[stephanealoo]

Hi @esmatullaharifi
You have to pull each column at a single instance i.e. using one pull instance. You can then use calculate functions if you need be to merge them.

Stephane