- JeremiahAsked on December 20, 2013 at 07:59 PM
What I am trying to do is create a calculator that our clients can use to figure out how many kilowatts they will need to do the industrial process they want.
I know the formulas, I just dont know how to apply numerical value to fields that are text or numerical values to numbers that are different that the ones that are displayed or inputted by them. I also do not know where I can input my formula to make the desired fields make the calculation in the correct maner.
The attached screenshot shows kinda what I want to do. My form will be omitting some of the fields.
To give you a litle more info the "Steel" drop down field for instance is equal to a value of 60. And the number of minutes they pick becomes a decimal.
I can provide greater detail if needed.
thanks so much!!!
- JotForm Supportashwin_dAnswered on December 21, 2013 at 01:19 AM
I would suggest you to explain the requirements in detail which should include the formula for your calculation.
I will try to quickly explain you how you can achieve the calculation feature in your form. You can take advantage of our "Calculate Field" feature and here are the steps to achieve this:
1. Load your form in editor.
2. Select the form field where calculated value needs to be displayed, click on the properties icon and then click on the "Calculate Field":
3. In the "Calculation Wizard" you can select the fields from the "Form Fields" and build the calculation formula. Few examples are available for you reference.
Here is a demo form I created for you: http://form.jotform.co/form/33384350606856? Feel free to clone this form in your account for a closer look. Here is a guide which should help you in form cloning : https://www.jotform.com/help/42-How-to-clone-an-existing-form-from-a-URL
Hope this helps.
Do get back to us with your calculation formula and we will help you build your form and achieve calculation feature.
- premierdepogrlAnswered on December 21, 2013 at 03:52 AM
Hi! I, too, am trying to create a calculating form but am running into issues. Please help ASAP!
I have attached the form here http://form.jotform.co/form/33531238062851
What I am trying to do is take the total # of pages and multiply it by the BASE PAGE rate plus the COPY RATE, get a subtotal and then ADD the ADD'L FEES for a BILL TOTAL. Can't seem to figure out how to do this! ANY HELP IS GREATLY APPRECIATED STAT!!!!
- JotForm Supportashwin_dAnswered on December 21, 2013 at 06:22 AM
I have already responded to you on the following thread: http://www.jotform.com/answers/307872-CALCULATING-FORM#1
- JeremiahAnswered on December 21, 2013 at 03:23 PMThank you!!! This should really help get me going. If I get stuck after this I will o into greater detail. Thank you again so much!!!
Sent from my iPhone
- ravenplayAnswered on December 23, 2013 at 01:17 PM
Jeremiah here again.
ok, so this answer has gotten me much farther (i guess since I was so focused on my first drop down field I missed this option for the other entry fields), but Im still at a loss as Im trying to use a multiple choice drop down box in two locations and I need these to both have numerical values that are different for each drop down option.
here in detail is what I need to do.
1. person chooses type of material first from drop down each material has a different numerical value. Aluminium= 36.12, Copper= 51.244, Nickel= 27.25, Titanium= 36.4 and Iron/Steel/SS= 60
2. person inputs length in inches
3. person inputs width in inches
4. person inputs height in inches
5. person inputs ambient temperature in ºF
6. person inputs application temperature in ºF
7. person chooses heat up time in minutes from a drop down menu. They can choose 30, 45, 60, 90, etc etc
my formula ends up like this L*W*H/1728*(NUMERICAL VALUE OF MATERIAL CHOOSEN IN FIELD 1)*(APPLICATION TEMP-AMBIENT TEMP)*1.2/3412... then the final calculation is an if statement. if the person chooses 30 or 45 minutes then the calculation up to that point needs to be multiplied. If they pick 60 minutes the calculation is complete and if they choose 90 minutes or greater then the final calculation needs to be divided.
Numerical values: 30 min= 0.5 45 min= 0.75 60 min=1 90 min=1.5 120 min=2 150 min=2.5
and so on up to 1440 min (24 Hours)=24
if sttements: if 30 minutes*.0.5, if 45 minutes*.75, if 60 min*1 (or do nothing further) if 90 min/1.5 if 120 min/2 if 150 min/2.5 and so on
- JotForm Supportardy0689Answered on December 23, 2013 at 01:51 PM
@ravenplay, thank you for updating us. Unfortunately, you can not attach numerical values for the drop down boxes. As they have default values of indexes. For example, if STEEL is the first item in the drop-down box its index value is 1. If you put that to "Calculate Field" it will have a value of 1 and not 60. No way to change that from the Form Builder except by using and embedding with the full source code and modify the HTML manually then host it on your server.
What I can advise is to separate them into sections with exact required fields but different calculation formulas by using Form Collapse field. So that if the user chooses "Iron, Steel, SS" it will show the related fields.
Please see this demo I have made for you.
To be able to accomplish the same feat, on regards with showing or hiding the sections, please refer to this user guide How to Hide or Show Multiple Fields at Once Based On a Single Conditional Entry.
Each fields are similar but with different calculation formulas. You can also do the same with the minutes to have differing calculations according to user choices. Please try this approach and let us know if you require further assistance. Thanks
- Robert LiguoriAnswered on September 23, 2015 at 03:35 PM
Do you still need this calculator built?