When I close a form that has multiple orders, how can I get an itemized list breakdown of items & sizes so I can organize my orders?

  • Bauman_Andrew
    Asked on October 27, 2020 at 7:39 PM
  • Ashwin JotForm Support
    Replied on October 28, 2020 at 12:17 AM

    The only option available is to download the submissions in Excel file

    Unfortunately no, it is currently not possible to display products and quantity in a separate column of forms submission or tables page. Please note that the data of each field will be displayed in a separate column on forms submission or tables page. Since payment tool is also one single field, data of all the products selected will be displayed in one single column. If you want to see the data separately, here are the options available to achieve your requirement:

    #1. Download your form's submission data in Excel file and then split the data of payment tool in separate columns. You may like to take a look at the following guide should help you:   https://www.extendoffice.com/documents/excel/1786-excel-split-text-by-space.html 

    #2. Use regular form fields in form to list your products. You can then add the form calculation widget to calculate the amount and pass it to the payment field of your form. The following guide should help you:  https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field 

    Hope this helps.

    Do get back to us if you have any questions.