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

    Does your form have the ability to do simple math calculations?

    Asked by David Rothwell  on January 06, 2014 at 05:17 AM

    I like to prototype simple math calculations in excel, then i need to be able to create a form to replicate that.

    Can you do that?

    At the moment I have to pay to get these calculations hardwired.

    Example link attached.

    Many thanks!

    Looks like you have a great product.

    If you need any help running your adwords campaigns, let me know - I'm a professional as you can see from my website.

    Page URL:
    http://www.davidnrothwell.com/adwords-cashflow-calculator/

    calculations create a form excel professional
  • Profile Image

    Answered by EliezerN on January 06, 2014 at 09:30 AM

    With our Calculation feature you will be able to perform calculations on your form based on the entries of your fields, to find it just right click on the field where you wish to show the final result and choose Calculate Field.

    You can use the fields tags/variables by cliking each Form Field from the right side to build your formulas.

    Please give it a try and inform us if that fits your needs or if you need further assistance.

    Thanks

  • Profile Image

    Answered by David Rothwell  on January 06, 2014 at 09:34 AM
    Many thanks.
    ...
  • Profile Image

    Answered by David Rothwell  on January 07, 2014 at 03:47 AM
    any update?
    ...
  • Profile Image
    JotForm Support

    Answered by ashwin_d on January 07, 2014 at 06:02 AM

    Hello David Rothwell,

    My colleague in his reply above have already explained you how to do mathematical calculation. Are you unable to see his reply or you want to ask something else?

    Please click on the following URL to see my colleagues response :  http://www.jotform.com/answers/312789

    Do get back to us if you want to ask something else.

    Thank you!

  • Profile Image

    Answered by David Rothwell  on January 07, 2014 at 06:03 AM
    I asked an additional question that didn't get an answer --
    "One last question before I try it - can a calculated value be used as the
    input to another calculation?"
    Can you advise please?
    Thanks again.
    ...
  • Profile Image

    Answered by EliezerN on January 07, 2014 at 09:57 AM

    Sorry for not answering that question before, actually I cannot find it in your previous message, nayways here is the response.

    Yes it is possible, please take a look at this example form: http://form.jotform.co/form/40064121511840

    The Result 1 will be summed with the Additional amount value and the result will be shown in the Result 2 field. To accomplish that all you need to do is to Open the Calculation wizard in the field where you wish to show the total/result and then build the calculation formula by adding the tag of each field including the already "calculated value":

    Please inform us if you need further assistance with this inquiry.

    Thanks

  • Profile Image

    Answered by David Rothwell  on January 07, 2014 at 10:04 AM
    Brilliant!
    Many thanks.
    I will try it out. This could be extremely useful.
    I've had a *lot* of trouble finding a form generator that would do this (I
    presently use Gravity Forms which is great but struggles with this
    approach).
    ...