Export CSV file from main and subform
I choose Zoho over JotForm because of this subform control and the ability to hand one to many relationships. The reason I wanted that is that I want to import the form data into my MS Access relational database. So I have created a form in which I ask for medical information from my clients - medications and medical treatment. The main form is that clients identifying info - name, address, etc. There are then 2 subforms - one for medicines and one for medication treatment.
When I expert data to a csv file what I get is a bit odd. On the first row I do have field names from the main form, but for the subforms, I have the name of the subform on the first row as if a field name, then on row 2 I have field names for the subforms.
I know I can go into the csv file and hand edit - dragging the field names for the subform to the first row, I suppose, but I would like a less labor intensive solution. An ideas?