-
Franciscan_UniversityAsked on October 1, 2020 at 10:07 AM
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
Page URL: https://form.jotform.com/202684216690154 -
Yvette_LReplied 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
- 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
- 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.