- David RothwellAsked 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.
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.
- EliezerNAnswered 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.
- David RothwellAnswered on January 06, 2014 at 09:34 AMMany thanks.
- David RothwellAnswered on January 07, 2014 at 03:47 AMany update?
- JotForm Supportashwin_dAnswered 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.
- David RothwellAnswered on January 07, 2014 at 06:03 AMI 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?
- EliezerNAnswered 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.
- David RothwellAnswered on January 07, 2014 at 10:04 AMBrilliant!
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