Description :
I have a Kobo form which contains some calculated fields.
I would like to download my collected data in .xls format with keeping for the calculated fields the formula. Is there a way to do it ?
I tried with the web interface and the API (V1 & V2) but when I download the data I had the calculated field name and the values computed by kobo. I loose the formula.
I need to keep the formula in my Excel data file because I have sometimes to correct some data.
The only way I have in mind to solve this issue, it’s to also download the excel form file which contains the formulas and to make a mapping based on the variable name with a program (Excel or Python). But this way is really not convenient specially when you have groups because the variables name mismatch between the two files.
Thanks for your help,
Example :
Form file
Download data file
For my calculated field B, I only have the computed values and I lose the reference to the formula