I have created a form in JotForms in which my clients can input details about the medications they are currently taking (name, dosage, side effects, etc). So any given client could be taking 1 or 20 medications. This would correspond to a table in my Access DB, tblMedications where each medication is a new record, with a CllientID field to associate it with the right client.
So with JotForms I find I can export to excel. When I do that I get only two rows: a column heading and the second being the data. Rather than creating a row for each medication, it appears that every medication has a number in its header text like this:
Please List All Medications You Are Currently Taking >> 1 >> Medication Name
Below this column header we would have , "Prozac" or "Methocarbomol", the name of the medication. These types of column headers continue with same format: "Text instruction to user on the JotForm" >> Number corresponding to what should be a row >> What should be the Column Header that would correspond to field name in Access table.
So what I need is the number to correspond to a row, and the text that follows a column name. So here this is the first medication, and if I had a "2" it would be the second medication. And it belongs in a column titled "Medication Name". Can anyone help?
Bookmarks