How can I separate the products in the payment field into separate cells?

  • youthprescotthockey
    Asked on October 6, 2017 at 9:12 PM

    What is the easiest way for me to get a list of all products ordered from all submissions. For Instance, I have 4 t-shirts to offer all with varying size options and would ike to be able to have it transferred to a list to make ordering easier. I tried to integrate Google sheets and figured i would just sort the columns based on the sizes and styles ordered, but all the products just show up in one cell, they are not broken down in seperate cells and I am unable to sort them as I need. The end result is, I need to know how many of each size and style I need to order. 


    https://form.jotform.com/youthprescotthockey/-tshirt-ordering-form

  • Support_Management Jotform Support
    Replied on October 7, 2017 at 2:59 AM

    From how you described it, you have 2 ways to approach this:

    1. The long way - Re-create your form so it won't use the built-in products within the payment field.

    a. Use regular form fields that will serve as your products (e.g. textboxes, dropdowns, checkboxes, radio buttons).

    b. Assign Calculation Values to these fields so they can be used for tallying the total later.

    Related guide: How-to-Assign-Calculation-Value

    c. Use the Form Calculation Widget to compute the total.

    Related guide: How-to-Perform-Form-Calculation-Using-a-Widget 

    d. Then, pass the calculated result to your payment field.

    Complete guide: How-to-Pass-a-Calculation-to-a-Payment-Field 

    2. Or keep your form as is then split the details in the Payment Field within Excel.

    a. Download your submission data to Excel.

    Complete guide: How-to-Export-Form-Data-to-Excel 

    b. Afterwards, refer to these online resources on how to split data from a single cell to separate columns.

    Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard

    Split-data-into-several-columns-based-on-carriage-returns