-
alphaemcAsked on January 11, 2018 at 3:41 PM
I used a widget to create the form at the URL below. However, when exporting to an Excel report, it dumps all of the widget data into a single cell. How can I modify or create the report so that each field of widget data is placed into separate cells under their own column headings (see attached "Requested Excel Report Format.PNG")?
Page URL: https://form.jotform.com/73485813190157 -
MarvihReplied on January 11, 2018 at 4:34 PM
Unfortunately, all data coming from a widget is grouped up in a single cell. This is how it is built same with the other widgets.
However, there is a workaround for this which is discussed on this thread.
https://www.jotform.com/answers/290516-How-to-separate-payment-product-data-into-separate-excel-columns
This should also work on your "Matrix Dynamique" widget.Let us know if you need further help.
-
alphaemcReplied on January 11, 2018 at 5:43 PMThank you but this will not work for me. Can you suggest an alternative to using the widget that will give me what I want?
Regards,
Steve Roche
Director of Operations
Alpha E.M.C.
1511 East State Road 434, Suite 3017
Winter Springs, FL 32708
Office: 407-542-0300 x117
[cid:image001.jpg@01D23362.0B4C5850]
... -
MarvihReplied on January 11, 2018 at 6:22 PM
I don't think it is possible since we cannot change the settings (Single cell per widget)on how the submission data is recorded to excel.
You might want try using a Grid Listing Report.
And copy the data inside the table manually to your Excel file, data will be on each cell after pasting to Excel.