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.
Do multiple calculations with one calculation widget and insert results into different summary fields? - RESOLVEDAsked by AA_C on December 03, 2016 at 11:36 AM
Is it possible to do multiple calculations with one cal-widget and insert different results into different fields?
For example my form 63315093011948 uses cal-widget to place a value into shipping/handling costs based on province selected, I would like the same cal-widget to place TAX rate into another field or do I have to create another cal-widget for that?
I have created an image of what I'm thinking about. The bottom section is what I'm asking about.
Currently you cannot for the Update/Calculate conditions as there is no "add" another DO action available in the calculation part. You can see that its only the IF rule that have the + option to add another IF rule.
But for the other conditional statement type, it is possible as both the IF rule and DO action have option to have multiple rules on them.
Take note though that with the Calculation action, you can still put multiple calculation by using formulas.
If you do create another conditional statement and if you targeted the same field (SUMMARY) it will overwrite the value.
Please tell us the multiple calculation you wanted to do on the same conditional statement. Perhaps we will be able to come up with a workaround for it.
Thanks.. I understand.
What I'would like to do is have the Province drop-down field calculate the S&H plus the TAX rate for that province. Right now it is calculating a 13% TAX rate for all Provinces which is incorrect.
So here are the two tables:
BC, AB, SK, MB = $18.50
ON = $16.00
QC = $17.75
NB, NS = $19.75
PI, NL = $21.25
The TAX table
BC, AB, SK, MB, QC = GST 5%
ON = HST 13%
NB, NS, PI, NL = HST 15%
A workaround would be helpful, Thanks,
On S&H table, you can use form calculation field so you can fetch the value easily without creating conditions. This is possible since you have already assigned calculation values on the provinces.
For the taxes, you have to create a calculation/update conditions like the following.
If province is equal to BC, insert 0.05 into Tax
Then on Tax Added field (HST), use the Tax field multiplied by the Sub Total.
E.g. SubTotal * Tax
Here's a cloned version with this changes https://form.jotform.com/63381858116966.
Feel free to clone this form if you want.
Thanks for pointing this out and the clone ... I will definitely make a copy... I did notice however that the clone has no total if NS or NB are selected... An easy fix for sure... OH!and the ON S&H only shows up as 16 not 16.00
...I don't have any time right now but I will look at it tomorrow.
On behalf of my colleagues, you are most welcome. I have updated the conditions so that the Total appears if NS or NB are selected. I've also set it so that empty decimal places will be visible for S&H. You can check out and clone the updated form using this link: https://form.jotform.com/63387988459986.
Thank you one and all for the help... Very!! much appreciated.