How to make items into separate columns?

  • Hatch_mtmaedel
    Asked on October 26, 2020 at 5:59 PM

    Hi there! My order form is working great except that when it imports the info to Google Sheets, the items are all in one cell rather than being put into a separate cell for each one. Can Jotform do this or do I need to manually do this from invoices?

    Jotform Thread 2656902 Screenshot
  • Jed_C
    Replied on October 26, 2020 at 10:07 PM

    Your options are:

    1). Create a custom payment field which you will need to separate the products into different fields.

    Guide: https://www.jotform.com/help/275-how-to-pass-a-calculation-to-a-payment-field

    2). You can try this workaround using the Excel's TEXT-to COLUMN function: 

    https://www.jotform.com/answers/1466144 

    Let us know if you have any questions or if you need further assistance.