I'd like to pull the quantity from the Payment Field to Excel

  • Franciscan_University
    Asked on October 1, 2020 at 10:07 AM

    1601560701 5f75e07df380c Quantity Update Screenshot 10

    Is it possible to pull the Quantity from within the payment part to either pass to another field? I need the quantity to appear on an Excel spreadsheet

  • Yvette_L
    Replied on October 1, 2020 at 1:05 PM

    Thank you for contacting us.

    I'm afraid it's not possible to take the quantity from the Payment Field with the above conditions.

    However, I've cloned your form and created a workaround, please see the form here:

    https://www.jotform.com/202744721679967

    The solution is that you

    1. Add a new Number element on the form (called TOTAL PRICE on mine), and by adding conditions you'll copy the Dinner reservations value there
    2. Add another new Number element (QUANTITY FROM TOTAL PRICE), and with conditions divide the TOTAL PRICE by 65 so you get the quantity

    Please kindly note that you'll have to change on the second condition "65" inside the calculation if the price of the reservation changes.

    Feel free to clone this form to your account, here's the guide how to do that: https://www.jotform.com/help/42-how-to-clone-an-existing-form-from-a-url

    Hope this information helps.

    If you have further questions, please let us know.