- AgPhdAsked on September 18, 2017 at 06:02 PM
Is there a way for all products in the merchandise order form to have their own column in the exported CSV or XLSX file? Currently, everything entered into the Merchandise Order Form gets thrown into a single column. Which makes sorting and filtering actual orders problematic. Please let us know our options here.
- JotForm SupportKevin_GAnswered on September 18, 2017 at 06:22 PM
Unfortunately, there is not a way to change how the data from the payment field is displayed on the spreadsheet or submissions page. It will be always sent as an array of data.
We could however open a feature request for this, please let us know if you would like to get this forwarded.
- AgPhdAnswered on September 21, 2017 at 11:53 AM
Thanks for the response. That feature would be nice for what I'm trying to do - we have 20+ items with multiple sizes and such that gets difficult to break down when the whole array is in one cell. We essentially have to manually re-do the array into columns in Excel when we export.
- JotForm SupportKevin_GAnswered on September 21, 2017 at 12:25 PM
Sure, I will open a feature request for this, although we cannot provide an ETA, we will let you know as soon as we receive any updates about it.