What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to pass calculation with decimals to payment integrated field

    Asked by nemsd 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

    Page URL:
    http://form.jotformpro.com/form/41965656870973

    calculation decimals pass decimals pass calculation calculation payment calculate hrs decima
  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on August 19, 2014 at 01: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

  • Profile Image

    Answered by nemsd on August 19, 2014 at 02:01 PM

    Hi Jeanette,

    Thank you so much for your reply.

    Is this the only way to work around this?

     

  • Profile Image
    JotForm Support

    Answered by jonathan on August 19, 2014 at 04: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.

     

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

    Inform us if you need further assistance.

    Thanks.

     

     

     

  • Profile Image

    Answered by nemsd on August 20, 2014 at 02: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

     

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on August 20, 2014 at 03: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.

  • Profile Image

    Answered by nemsd on August 21, 2014 at 08: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!

     

  • Profile Image
    JotForm Support

    Answered by jonathan on August 21, 2014 at 09: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.