I'm creating a Survey123 form where the user inputs information into a bunch of general text and decimal fields, and then inputs repeated information by using a repeat object in the survey.
Afterwards, one of the tasks the administrator of the data needs to perform is making regular exports of data to input them in an excel spreadsheet, where specific automatic calculations are made to the data, and where it's presented in a certain way necessary.
The export however, creates 2 CSV files, this of course being the fact because there are 2 related tables created when the survey is published: 1 main table and 1 table to store the repeated information.
I want to explore possible solutions where only 1 table is created / exported. This will result in a dataset with more and repetitive data i'm sure, but it would make the excel manipulation phase easier for the administrator of the data.
Any ideas would be greatly appreciated.
Yannick