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.
How can I add a calculation to my form that is based on multiple parameters?Asked by vigon1988 on January 05, 2015 at 11:47 AM
I'm trying to create a form that will calculate shipping weight and dimensions according to specific parameters (see screenshot).
The user inputs net weight and quantity (among other things) and I want there to be an output that shows dimensions and tare (gross weight). How would I go about putting these calculations into my form?
parameters create a form calculations quantity create
Calculations in your form can be achieved by using the form calculations widget:
Here is our guide on on using and setting up this widget:
You would need to assign calculation values to each field and then setup the equation you desire. The result will be displayed in the calculation widget field.
There are also several other calculation widgets that may be able to accomplish what you are looking for:
Though the one I first posted has the easiest functionality.
If this is not what you were looking for, please let us know and we will be happy to see what else we can do.
Thank you for your response. I'm still having trouble adding calculations to this form, because I need to add logical functions (like Excel IF functions). Is there any JotForm calculation widget capable of doing logical test functions?
How do I make it so:
(gross weight) field (is less than or equal to)
I need a nested IF function, which would look like this:
=IF (gross weight is less than or equal to 10, output 1.77) OR (gross weight is less than or equal to 30 but more than 10, output 5.31) and so on
Here's the formula from Excel which is calculating tare based on gross weight (M6):
I'm not sure if it is possible to achieve this but I will run further tests and will get back to you once I have more details.
Let us know if we can assist you further.
If I understood you right there are 6 different fixed outputs. If this is correct, I chose a simpler solution that is using a dropdown field where user will select one of 6 weight categories. And according to the selection it will update a form field with a specific value.
You can test and clone the demo form:
The conditions I added to this form was update a form field value:
Let us know if this is a solution for you.