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.
Form calculation is not working when two of three fields are not filled inAsked by email@example.com on December 10, 2014 at 05:38 PM
I have three drop down fields in my form (two under Software Requested and another under Hardware Requested) that I want to calculate at the bottom with a total. I have calculation values set up for each option in the fields, and the calculation works great...if they happen to want to choose a product from each drop down. If they do not choose something on one of the drop downs, the calculation doesn't work correctly. For example, if I just choose something from the QuickBooks dropdown, the calculation doesn't work.
I am wondering if I have to account for the blank line at the top in the calculations? Or if I just have my formula set up incorrectly - maybe add some brackets around the calculation?
Yes. You are right in assuming to consider the first blank option in the drop down boxes. Please add another 0 for each dropdown in the calculation values so that it should work as expected.
Additionally, please enable the option Wait for input before including the field in calculation from the advanced options of Calculation wizard for the fields SALES TAX 8% and TOTAL TO BE CHARGED.
This option need not to be checked for ORDER SUBTOTAL field since it waits for all dropdown boxes to be selected.
Hope this information helps. Thanks!