Auto-fill question matrix based on ID

Hello guys,

I wanted to know how I could proceed to resolve this challenge with a question matrix:

  1. I have a list of participants in a CSV format which have unique ID.attributed individually
  2. I want to build an attendee sheet reporting based on it in such a way to work like this:
    2.1. The first fillable column is the ID
    2.2 The other columns will fill automatically based on the ID (name, sex)
    2.3 This way, the reporter will have minimum efforts need and it would also minimize entry errors.

Thanks already.

You could do this using the pulldata function as outlined in the support article Pull Data Functionality in KoBoToolbox.

You could also have a look at a workaround discussed previously:

Hey Kal. Thanks for the prompt answer. However I forgot to mention that this concerns specifically the question matrix type. I already know how to pull data with usual question types but I would like to make a table-like form which auto-fills.

Thanks

It’s possible! And you could do the same as outlined in the image as shared below:

In the survey tab of your xlsform:

In the settings tab of your xlsform:

Image 2

CSV file:

image

Data entry screen as seen in Enketo:

Reference xlsform:

Pulldata in Matrix Question.xlsx (11.5 KB)

CSV File:

Codes.csv (104 Bytes)

3 Likes

Thanks alot! this answers my question!

1 Like