What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    Can multiple purchase lines be separated in reports?

    Asked by brucekowalczyk on June 04, 2015 at 01:40 AM
  • Profile Image
    JotForm Support

    Answered by Charlie on June 04, 2015 at 03:36 AM


    If your making an excel report, you can manually separate the purchases on a new cell or row.

    But if you are looking on separating them automatically, unfortunately, it is not possible.

    If you wish to show each product on separate columns, in an excel report, that's possible if you'll recreate the products using the plain form fields instead of adding them directly in the payment tool. 

    Using text boxes, radio buttons and other field types, you can calculate the price using form calculation widget then passing it directly in your payment total field. If you'll use radio buttons or check boxes, you can assign calculation values on their selections, here's a guide: http://www.jotform.com/help/301-How-to-Assign-Calculation-Value.


    I made a test form that you can try, here it is: http://form.jotformpro.com/form/51541770203951. Try cloning it, make a test submission and see in the excel report on how it looks.

    I hope that helps.