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 can I make a form which can add Total Amounts?

    Asked by vickileblanc on January 07, 2014 at 12:19 PM

    I am trying to create a form to add up and show total amount.  Amount but not link to a payment processor.

     

    Thank you,

    Vicki

    create a form show total create and
  • Profile Image
    JotForm Support

    Answered by KadeJM on January 07, 2014 at 02:51 PM

    Hi Vicki, It's possible to do that. We have added a basic Calculate Field Feature which can be used on the Textbox Field.

    Example Form: http://jotform.co/form/40015949675865 - Just choose 1 radio option for each and you will see that it has a value of 1-3 assigned to each of the Questions where the Textbox shows the Calculated Total. It is not associated with the Payment Integration Tools.

    Now, I'm not entirely certain what you had in mind so if you need further help just explain more about what you are trying to do and we'll lend a hand if you happen  to need it.

  • Profile Image
    JotForm Support

    Answered by KadeJM on January 07, 2014 at 03:10 PM

    Hi Again, I went ahead and tried to build a form based on Adding Two Total Amounts together. This for is much more advanced but might be similar to something you might be attempting to do and if not then it will at least show you ideas on what is possible.

    Example Form Version II: http://form.jotform.co/form/40066297323857

  • Profile Image

    Answered by biiainsurance on January 14, 2014 at 11:14 AM

    If I need to make a new thread I appoligize, looks like what you are showing is what I am trying to accomplish ....

    I am trying to do calculations as well. I can do either dropdown or radio buttons at this point but currently have dropdowns with conditions. Is there a way to assign a value to each one of the drop down options or how do I go about doing it on a radio button ?

    Currently the structer is like this

    Drop Down -> Choose 1 of 4 options
    Based on which option is chosen the user will get 1 of 4 different drop down boxes. These options will be what holds a value. If I must do radio then that is fine also but need to take this portion and multiply it by an input box and then divide that by a pre determined number. Once final number is calculated I need to submit that number to authorize.net as a payment. 

  • Profile Image

    Answered by biiainsurance on January 14, 2014 at 11:59 AM

    So I went in and updated the dropdowns to radio buttons. I have my conditional working correctly so based on selection in 1st radio group the user will get 1 of 4 new groups shown to begin calculating a rate. Also can these figures be carried into the authorize.net payment details ?

     

  • Profile Image
    JotForm Support

    Answered by TitusN on January 14, 2014 at 01:13 PM

    Hello, 

    Thank you for your response. 

    The Authorize.net form field can handle the products for you, as well as show you totals.

    You will need to have an Authorize.net account. 

    I would suggest that you use the Authorize.net wizard to add options to each item you want to sell: 

     

    Give it a go and let us know whether it meets this need: 

     

  • Profile Image

    Answered by biiainsurance on January 14, 2014 at 01:43 PM

    So with the authorize.net interface I should be able to create conditions as well ?

    http://www.jotform.us/form/40133764614147


    The is property coastal field depending on what is selected shows different options which I will need to tie in a value per option.

    Then multiply value of the chosen option, for instance .14 x estimated completion value to get premium due, the premium due amount is what they will need to pay for .. hope that makes sense 

  • Profile Image
    JotForm Support

    Answered by Mike_T on January 14, 2014 at 03:05 PM

    @Biiainsurance,

    This is not currently possible to prepopulate the Total field based on selected options from other form fields. It sounds like a good idea, and we can forward a feature request ticket to our Development Team. Please open a new thread with your request, so that we will be able to escalate it.

    Thank you.

  • Profile Image

    Answered by vickileblanc on March 01, 2014 at 02:10 AM
    I am trying to setup a form with options and each option has an amount. I need it to total all options selected. Your example below would be great but I do not have the calculate field to select.
    How do I get the Calculate Field to show?
    Thank you for your help.
    Vicki LeBlanc
    username: vickileblanc
    account: Premium
    Example of the form that I need...........
    class 1 - entry fee $500 - select
    class 2 - entry fee $400
    class 3 - entry fee $300 - select
    class 4 - entry fee $200
    class 5 - entry fee $100 - select
    Total of selected = $900
    Submit button should submit form to designated email and the sender email.
    ...
  • Profile Image
    JotForm Support

    Answered by BDAVID on March 01, 2014 at 10:54 AM

    Hi, you can use one of our payment integrations to have a total amount set on your form based on the selection, you could add a purchase order:

    Select: Sell Products, Users can select multiple products, and Show total on the form.

    Add the options:

    This will be the result:

    Hope this helps you. On regards of performing calculations on your forms, you can use our calculation widget, let us know if you have more quetions.

  • Profile Image

    Answered by vickileblanc on March 01, 2014 at 07:30 PM
    How would you suggest handling the class events on the report? I need the classes in separate cells in the worksheet. Currently it puts them all in one cell.
    Thanks for your help.
    Sent from my iPhone
    ...
  • Profile Image

    Answered by Cesar on March 02, 2014 at 01:02 AM

    Kindly elaborate further on what you are trying to achieve. As I do see that you are speaking of a report. But at the same time you also speak of calculation fields. In the case you are referring to separating a class per field. Then you will need each class to have their own field, as opposed to displaying or selecting all classes on the same field.

    Kindly provide a screenshot of where you are dealing with this issue. That way we can review it further.

    Thank you.

  • Profile Image

    Answered by vickileblanc on March 03, 2014 at 04:00 PM
    Sorry for the confusion. I am trying to create a form that captures entries for a horse show. I would like the person to be able to select several classes with prices, show the total of class prices when form is ready to submit. After submitting the report, send confirmation email to the sender and designated recipients.
    After the above.... The report should have each selected class (Products) in a separate field/cell in the worksheet. Currently it puts all the classes with total in one field.
    Can you help?
    I have attached screenshots of what I currently have setup.
    Thank you.
    Vicki
    ...
  • Profile Image
    JotForm Support

    Answered by TitusN on March 03, 2014 at 04:39 PM

    Hello Vicky,

    Thank you for the clarification - please bear with us - we cannot recieve notifications on this support thread.

    Please upload your screenshots by using this linked guide.

    We look forward to your response.

  • Profile Image

    Answered by vickileblanc on March 03, 2014 at 06:10 PM
    Okay, I just sent the 2 images.
    Thank you,
    Vicki LeBlanc
    ...
  • Profile Image
    JotForm Support

    Answered by TitusN on March 03, 2014 at 06:20 PM

    It appears we have yet to recieve your screenshots.

    Sorry about that.

    Please email the screenshots to support@jotform.com

    Use this as the email subject matter: 313613-How-can-I-make-a-form-which-can-add-Total-Amounts

    Thank you for your patience.

  • Profile Image

    Answered by vickileblanc on March 05, 2014 at 01:30 PM
    Did you receive the screen shots?
    ...
  • Profile Image

    Answered by pinoytech on March 05, 2014 at 03:01 PM

    Unfortunately, we did not receive the image that you are trying to attached. Can you please try to only share to us URL of that image/screenshot?

    Thanks,

  • Profile Image

    Answered by vickileblanc on March 05, 2014 at 04:20 PM
    The image I was sending is of the worksheet on JotForm. Do you not understand what I am trying to achieve?
    I need to create a form with class entries. The person can select several class entries, which have different prices. The form should total all entries selected at the bottom. When you go to the JotForm Report is shows all the class entries in 1 cell in the worksheet. I need each entry to be in a separate cell in order to sort by entry.
    Thank you,
    Vicki
    ...
  • Profile Image
    JotForm Support

    Answered by TitusN on March 05, 2014 at 06:10 PM

    Hello,

    Sorry about that, and thank you for sticking through this.

    To summarize:

    1. You have different categories of products which you want totals to be shown at the bottom

    2. You want each of the product categories to appear on their own column on the spreadsheet/HTML Submission Grid Layout:

    I did a test demo that might help build your solution.

    Please clone this form and test it (http://form.myjotform.com/form/40636718862563) - would it be something you would consider to use?

    Let us know.

     

  • Profile Image

    Answered by vickileblanc on March 16, 2014 at 01:00 AM
    Can you help?
    ...
  • Profile Image
    JotForm Support

    Answered by NeilVicente on March 16, 2014 at 06:12 AM

    @vickileblanc

    The solutions provided so far by my colleagues, especially the authorize.net payment field suggestion, should address your needs.

    When you go to the JotForm Report is shows all the class entries in 1 cell in the worksheet.

    When you say worksheet, are you referring to an Excel worksheet generated from the submission? If so, separating the products selected and dumping them to their own respective columns should be doable by using Excel functions.

  • Profile Image

    Answered by vickileblanc on March 16, 2014 at 12:10 PM
    Need answer to the Excel part. How can you separate the products when submitted?
    Thanks,
    Vicki
    Sent from my iPhone
    ...
  • Profile Image
    JotForm Support

    Answered by Welvin on March 16, 2014 at 01:54 PM

    Hi Vicki,

    Do you mean to separate each product selected from the form into another column? Unfortunately, that is not possible with our current outputs. All selected products will be stored into one single column (text wrap).

    Thanks

  • Profile Image

    Answered by vickileblanc on March 17, 2014 at 01:50 PM
    Is there a way to create a text field for each product and have the user enter the amount, as a selection, then have it total at the bottom of the form?
    Example:
    (text field) Class 1 = $500: (user fills in $500 in the blank box) $500
    (text field) Class 2 = $300: (empty)
    (text field) Class 3 = $200: (user fills in $200 in the blank box) $200
    Class Totals = $700
    ------------------------
    Excel worksheet generated would show each class in a separate column...... Correct? Can this be done? Generate a total in example above?
    Thank you,
    Vicki
    ...
  • Profile Image
    JotForm Support

    Answered by TitusN on March 17, 2014 at 03:24 PM

    Hello Vicki,

    From your initial support request, it seems having a payment processor is not the key requrement, rather the ability for your form to:

    1. Collect totals for categories

    2. Sum up the categories in sub-totals

    3. Have a grand total at the bottom of the form

    4. Have each of the products appear on their own cells on an Excel spreadsheet export, right?

    If yes, then all four requirements can be done.

    Just to satisfy your previous request, I've prepared a demo form:

    http://www.jotformpro.com/form/40755702735961

    Using the Form Builder, you can basically make your form to calculate any outcome - using elaborate equations and formulars with the form calculation widget.

    I guess the reason why we are stubmling from suggestion to suggestion is because we are not exaclty clear on what you want to accomplish  - why not lay it out for us exacly what you want your form to do, and we shall be happy to assist.

  • Profile Image

    Answered by vickileblanc on March 17, 2014 at 03:50 PM
    Yes, you are correct.. No payment processing is needed from the form. See below the form I am trying to create. The Entry Fee's should total at the bottom of the form. The Excel worksheet generated should create a column for each Class selected by the user.
    Thank you for your help.
    Vicki
    2014 Online Entry Form
    Owner:
    NCHA #:
    Address:
    City, State:
    Zip:
    Telephone:
    Cell:
    SS# Required:
    Horse's Name:
    Registration #:
    Rider:
    NCHA #:
    Address:
    City, State:
    Zip:
    Owner/Rider Signature:
    Email Address *
    Check payable to:
    Owner
    Rider
    SS# of Check Recipient:
    Classes to enter (select all that apply):
    3-Year Open Futurity - $8000.00 added (EF $971)
    3-Year Non-Pro Futurity - $2500.00 added (EF $621)
    4-Year Open Derby - $8000.00 added (EF $971)
    $200,000 Limited Rider 4-Year Open (EF $500)
    4-Year Non-Pro Derby - $5500.00 added (EF $911)
    $200,000 Limited Rider 4-Year Non-Pro (EF $500)
    4-Year Unlimited Amateur Derby - $2500.00 added (EF $621)
    4-Year $50,000 Amateur Derby - $1000.00 added (EF $431)
    5/6-Year Open Classic - $8000.00 added (EF $971)
    $200,000 Limited Rider 5/6-Year Open (EF $500)
    5/6-Year Non-Pro Classic - $5500.00 added (EF $911)
    $200,000 Limited Rider 5/6-Year Non-Pro (EF $500)
    5/6-Year Unlimited Amateur Classic - $2500.00 added (EF $621)
    5/6-Year $50,000 Amateur Classic - $1000.00 added (EF $431)
    Entry Fee:
    ...
  • Profile Image
    JotForm Support

    Answered by TitusN on March 17, 2014 at 04:21 PM

    Here's a demo of how that would work with the form calculation widget:

    http://www.jotformpro.com/form/40756367334964

    Go ahead and take a copy of that form using this linked guide.

    Let us know if that helps.

  • Profile Image

    Answered by vickileblanc on March 17, 2014 at 05:20 PM
    This is the form I originally created, or very similar. The problem is the selected classes are still all in one cell / column. They need to be separate. The reason why is so that the person working with the Excel spreadsheet can sort and create lists of entries. Example: Class 1 spreadsheet would show all horses entered. We need to create a spread sheet for each Class to show entries.
    ...
  • Profile Image
    JotForm Support

    Answered by TitusN on March 17, 2014 at 05:41 PM

    Oh My - sorry about that.

    Modified: http://www.jotformpro.com/form/40756367334964

  • Profile Image

    Answered by vickileblanc on March 18, 2014 at 12:00 AM
    Excellent!! How did you make the label invisible?
    Thank you for your help!!!
    ...
  • Profile Image
    JotForm Support

    Answered by ashwin_d on March 18, 2014 at 04:26 AM

    Hello vickileblanc,

    On behalf of my colleague, you are welcome.

    Upon checking my colleague's form, I found that following custom css was injected to hide the labels:

    em {

    color: transparent;

    }

    .form-radio, .form-checkbox {

    float: left;

    }

    Thank you!

  • Profile Image
    JotForm Support

    Answered by TitusN on March 18, 2014 at 07:22 AM

    And remember to wrap the labels in <em>Your label</em> tags.

    They will dissapear soon after you add them - thats fine - you will know they are there if the label is Italicized.

    In your case, the other three labels should be:

    <em>For Horse Listed Above</em>

    Then add in the CSS my colleage has shown.

    Sorry, I forgot to explain that earlier.

     

  • Profile Image

    Answered by vickileblanc on March 18, 2014 at 12:30 PM
    Thank you so much!!!!!
    ...
  • Profile Image

    Answered by vickileblanc on March 18, 2014 at 02:30 PM
    Where do I find the label to wrap?
    ...
  • Profile Image

    Answered by Cesar on March 18, 2014 at 05:35 PM

    All you need to do is to edit the label to the left of the radio button or checkbox. By wrapping the label with the tags as described by my colleagues.

     

    Here is a screencast adding the tags: http://screencast.com/t/5BjkqIfaW

    Do let us know if you need further assistance, kindly create a new thread so that we may assist you further. As this is no longer related to the original topic of this thread. Thank you.