How to pass calculation with decimals to payment integrated field

  • nemsd
    Asked on August 19, 2014 at 11:43 AM

    Hi good people,

    My form needs to calculate hours in order to determine the price and the hours are in decimals. 

    I tried this http://www.jotform.com/answers/234379-Allow-Decimal-on-Custom-Quantity but it's not working for me.

    Is there a another work around for this? 

    Here is my form: http://form.jotformpro.com/form/41965656870973

    Thank you for your help!

    Misrak

  • Jeanette JotForm Support
    Replied on August 19, 2014 at 1:22 PM


    You might probably need to add a Calculation Field and then pass it into to the Payment integration

    Please study that guide, but we are here for further help.

    Also, Here is a demo form showing how this works: http://www.jotformpro.com/form/41413741780956

    In order to find out how to perform calculations in a form, please check this guide

  • nemsd
    Replied on August 19, 2014 at 2:01 PM

    Hi Jeanette,

    Thank you so much for your reply.

    Is this the only way to work around this?

     

  • jonathan
    Replied on August 19, 2014 at 4:22 PM

    Hi,

    In the Calculation of your form http://form.jotformpro.com/form/41965656870973 please make sure you enable the "Show empty decimal places" option.

    This will make sure that even zero(0) decimal places will appear on the resulting value.

    How to pass calculation with decimals to  payment integrated field Image 1 Screenshot 30

     

    I made a test of this on my form http://www.jotform.me/form/42306253041441 and it was working.

    How to pass calculation with decimals to  payment integrated field Image 2 Screenshot 41

    Inform us if you need further assistance.

    Thanks.

     

     

     

  • nemsd
    Replied on August 20, 2014 at 2:00 PM

    Thank you all for your help!

    Another related question. 

    The "Amount You Pay" field is passed to PayPal.

    In the PayPal report there are two types of entries for one transaction "Shopping Cart Item" and "Website Payments Pro API Solution". The Shopping Cart Item shows the payment purpose title "NEMSD-IA" but it's blank for Website Payments Pro API Solution.

    Could you please explain why there are two entries? 

    Thank you for your help

     

    How to pass calculation with decimals to  payment integrated field Image 1 Screenshot 20

  • Jeanette JotForm Support
    Replied on August 20, 2014 at 3:32 PM

    I assume you are seeing such information at your Paypal account, right? If that is the case, please provide the screenshot of the said 2 type of transactions so we can check and advise further.

  • nemsd
    Replied on August 21, 2014 at 8:34 AM

    Right, it's the PayPal account and like I stated in my request, i'm referring to the PayPal report.

    There are two entries for one transaction.

    Under the "Type" column there are two types:  "Shopping Cart Item" and "Website Payments Pro API Solution" for one transaction.  And if you scroll across the spreadsheet, under the "Item Title" column, you will see that only "Shopping Car Item" types display the payment purpose title "NEMSD-IA". We use this title to identify which form is used for the transaction as there are many forms that use the same PayPal account.

    It's very important to us that the payment title "NEMSD-IS" is displayed as it does.

    In the "Fee" and "Net" columns, you will see that the data corresponds to the "Website Payments Pro API Solution" type. And we need this data as well

    We need the data from the two types as it is the whole information about one transaction.

    My question again is why are there two entries for one transaction?

    How can we have all the information for one transaction under one entry?

    Here is the link to the spreadsheet: http://www.nemsd.org/Doc-Vault/paypalreport.xlsx 

    Thank you for your help!

     

  • jonathan
    Replied on August 21, 2014 at 9:42 AM

    I have created a separate post about the other question here

    http://www.jotform.com/answers/418918

    We will respond to you on that thread.

    Thanks.