Payment Integration: Is it possible to have the data in the payment field separated?

  • AgPhd
    Asked on September 18, 2017 at 6: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 Thread 1250893 Screenshot
  • Kevin Support Team Lead
    Replied on September 18, 2017 at 6: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. 

  • AgPhd
    Replied 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.  

  • Kevin Support Team Lead
    Replied 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.