How can I integrate the "products" page into individual cells in my excel report?

  • wfecrebates
    Asked on May 7, 2018 at 4:31 PM
  • Mike_G JotForm Support
    Replied on May 7, 2018 at 6:01 PM

    I'm afraid there is no option within the form for you to be able to do that. However, you can do the workaround below to the Excel file of your submission to separate products into columns.

    First, you need to anticipate the maximum number of lines the payment field in your form creates in the Excel file.

    I just assumed you are referring to the 2018 Emerging Technology Conference form in your account, is that correct?

    I created a clone version of that form and made a test submission with all the products in the payment field selected.

    In the Excel File, the payment field has a total of 5 lines.

    1525729160t17 36 40 Screenshot 10

    Since that is the case, you need to insert 4 columns after the payment field in the Excel file.

    1525729272t17 40 34 Screenshot 21

    After that, select the entire Payment field column in the Excel File and click the "Text to Columns" option under the DATA tab.

    1525729416t17 41 59 Screenshot 32


    Then, on the Convert Text to Columns Wizard, select "Delimited" and click Next.

    1525729756t17 45 30 Screenshot 43

    On the next page, deselect all the Delimiters except for "Other". Put your mouse cursor on the "Other" box and press CTRL+J on your keyboard. Then, click Next.

    1525729870t17 47 22 Screenshot 54

    On the last page, you don't have to change anything and just click Finish.

    Here's the result:

    1525730411t17 56 Screenshot 65

    Here's also a reference that you can use — https://www.howtoexcel.org/tips-and-tricks/how-to-separate-data-in-a-cell-based-on-line-breaks/

    I hope this helps. If you have other questions or concerns, please feel free to let us know.