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

  • Profile Image
    youthprescotthockey
    Asked on October 06, 2017 at 09: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

  • Profile Image
    Jim_R
    Answered on October 07, 2017 at 02: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