Total $$$ from a payment form reported as numeric info in its own cell

  • BSBCRegistrations
    Asked on August 29, 2014 at 12:00 PM

    Need to have the Total $$$ from a payment form reported as numeric info in its own cell - not as part of the overall text field for the purchase. We are having to download and manipulate the excel sheet to pull the number and then make it numeric so we can run some calculations.

     

    Is this a possibility in an update?

  • Carina
    Replied on August 29, 2014 at 2:40 PM

    There is a workaround to achieve that which is to add the products outside the payment tool, in a normal radio-button.

    Then adding a Form Calculation that will display the total amount of the products.

     Total $$$ from a payment form reported as numeric info in its own cell Image 1 Screenshot 30

    Then we define the Payment tool as donation and to get the amount from the Calculation field:

     Total $$$ from a payment form reported as numeric info in its own cell Image 2 Screenshot 41

    You may test and clone the demo form:

    http://support.jotform.com/form/42405562679158? 

    Let us know if this is a solution for you.

    Thank you