Purchase Order field all products are in single cell when exported to Excel

  • Profile Image
    TututheMoon
    Asked on August 17, 2014 at 04:32 AM
    I'm using purchase order tool and its still doing one cell for all the item :(
  • Profile Image
    jonathan
    Answered on August 17, 2014 at 04:32 PM

    Hi,

    I checked your form http://www.jotform.us/form/42206418557152

    If I understand correctly, you must be referring to the sub-products as those that are still in the single cell when the form submission is exported to Excel or spreadsheet.

     

    Unfortunately, with the way your Purchase Order tool is setup, we could not make a workaround that can separate the sub-products form the main items.

    If there is no sub-product in the main items, the main items will be in separate cell each when you export them to Excel.

    You will probably need to manually do the alteration on the Excel sheet after downloading the submissions.

    Hope this clarify the matter. Inform us if there is more we can assist you with.

    Thanks.

     

  • Profile Image
    TututheMoon
    Answered on August 18, 2014 at 08:31 AM

    I followed all the instruction I the wizard to set up but when I export it to excel the whole purchase order items area is In one cell instead of it separating as you showed above.

  • Profile Image
    jedcadorna
    Answered on August 18, 2014 at 10:59 AM

    Sorry but those sub-products can't be separated since they are in one product. You'll have to manually edit your excel file to separate the sub-products like what my colleague suggest you to do.

    This is how the payment products is designed even if you use other payment option you'll get same result.