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

    I need a grand total calculation for my Form

    Asked by bronxman721 on August 15, 2013 at 10:41 PM

    I am creating a check reimbursement form and need to have all of the amount fields under the expense Information Collaspe tab to  add up to a grand total.  

    How Do I do this?

     

    Here is the link to my form

     

    Also is 

    Page URL:
    http://form.jotform.co/form/32047807314854

    grand total check expense
  • Profile Image

    Answered by khrisell on August 16, 2013 at 05:17 AM

    Hello,

    It is possible using your form source code but since this is outside of our scope of support, we have to find free time for this so we can work on your request but we can't promise anything yet however, we will do our best to provide you the code as soon as possible.

    Also, if you'd like to capture the grand total result to your email notifications, we'd suggest to add a separate text box to your form and label it grand total so we will use it for populating the grand total result when the form field changes.

    I'll get back to you with once done. Thank you!

  • Profile Image

    Answered by bronxman721 on August 16, 2013 at 12:47 PM

    Thanks for your quick reply,

     

    I did  include the grand total field on my form under the expense information section after the last amount.

     

    Thanks

     

    David

  • Profile Image
    JotForm Support

    Answered by Mike_T on August 16, 2013 at 02:57 PM

    Can you please confirm that you would like to sum the manually entered values from the Amount fields (8 inputs)?

    If I misunderstood the request, please let me know.

  • Profile Image

    Answered by bronxman721 on August 16, 2013 at 03:18 PM

    Yes there will be eight input fields that will make up the grand total.

     

    Anyway to make the fields default to currency?

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by Mike_T on August 16, 2013 at 05:02 PM

    We do not have a currency field validation, but this might be possible with a custom script.

    We will need some time to write the script, so we will get back to you with the update to this thread.

  • Profile Image
    JotForm Support

    Answered by Mike_T on August 16, 2013 at 10:11 PM

    1. You will need to get your form source code.

    2. Copy the scipt code from this page.

    3. Paste that script code after the closing < / form > tag.

    Example:

    https://shots.jotform.com/mike/examples/summing8.html

    I have added the currency format to the Total field, but removed that formatting from amount fields since it was blocking the calculations.

    Thank you.

  • Profile Image

    Answered by bronxman721 on August 19, 2013 at 01:20 PM

    I am using wordpress, therefore do I just paste my form code on the page, then paste the code you supllied me and then run the form from my wordpress page eliminating just the basic sript I normally use to embbed forms on my pages?

  • Profile Image
    JotForm Support

    Answered by Mike_T on August 19, 2013 at 02:45 PM

    You are right, you will need to use the form source code embedding method along with the custom script. Please note that you will need to use a Text tab to embed the code.

    If you need any further assistance on this, please let us know.

  • Profile Image

    Answered by bronxman721 on August 19, 2013 at 03:48 PM

    Thanks,

     

    What do you mean when you stated that I will nedd a text tab to embedded the info.  Do you mean I cannot text the code wth the visual tab on in word press?

  • Profile Image
    JotForm Support

    Answered by Mike_T on August 19, 2013 at 03:51 PM

    That is correct, I think that the visual tab will handle the code as a plain text, so you will need to use the text tab instead.