Payment Integration: seperate columns in spreadsheet

  • ekbrothers
    Asked on December 18, 2017 at 3: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!    

  • aubreybourke
    Replied on December 18, 2017 at 5: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 Screenshot 10

    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 Screenshot 21