-
rempe9925Asked on December 5, 2016 at 10:15 AM
Hi
I create a form that works really well but now need to find a way to create a report on some specific fields and need to know how to do that.
As you will see in the attached screenshot and URL, the "order details" section is what i'm after. It's critical that i am able to sort my order details data by "language", as well as "device type". How can i go about that? currently, it mashes all the data together in a continuous cell, but i need to find a way to do it in a clean reporting format.
ThanksPage URL: https://form.jotform.com/63354079149159 -
JanReplied on December 5, 2016 at 3:46 PM
Unfortunately, the Grid Report or the HTML Table Listing report will show the data of the Configurable List widget in one column only. Inside the column, there's another table that divides the data properly.
If you integrate the form to Google Spreadsheet, here's how it looks like:
If you exported the submissions in Excel file, here's how it looks like:
If you want to split it up into multiple columns/cell, please try using the Text-to-Columns function in MS Excel. Here's a related link: https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7.
Hope that helps. Thank you.
-
rempe9925Replied on December 5, 2016 at 3:52 PM
thank you very much. The link for excel will help!!
-
JanReplied on December 5, 2016 at 5:21 PM
Glad to hear that. Let us know if you need further assistance. Thank you.