Payment Integration: seperate columns in spreadsheet

  • Profile Image
    ekbrothers
    Asked on December 18, 2017 at 03:22 PM

    We have a meat deposit form which allows individuals to place a deposit on multiple quantities of a product.  This form is integrated with Google spreadsheets and updates a spreadsheet in Drive.  I would like to pull the product type and the quantity so they exist in separate columns so as to be readily filtered.  Thank you!    

  • Profile Image
    aubreybourke
    Answered on December 18, 2017 at 05:06 PM

    Its not possible to separate the products into separate columns if you use a payment integration.

    The only way to do it is to make your own payment page (with standard fields). This must calculate your total and then pass that to your payment integration.

    How-to-Pass-a-Calculation-to-a-Payment-Field

    For example:

    1513633954The Easiest Online Form Builde

    https://form.jotform.com/73516052522954

    You can clone this:

    How-to-Clone-an-Existing-Form-from-a-URL

    Then your submissions will look like this:

    1513634729JotForm · Submissions: Gorman