ODK Collect v1.27.2 and data collected is send to a google sheets in google drive.
Hello ODK users,
I want to ask how to get a desired output. I am currently using xlsform to build the form. I have a select_one question like the following:
and in the choices part I have:
Let´s assume we have 3 inputs from 3 different forms:
What I get as an ouput in google drive is a table that looks like this:
And what I would like is to have a column for each possible answer in which a 1 is added depending on the answer like this:
How could be a simple way to do this? I can modify the output file with R, however, I want to know how to get the data in the desired output using only ODK.
Thank you for your help,