JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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 to make calculation only when both conditions are true?Asked by wolfpaw69 on April 06, 2016 at 04:25 PM
I'm trying to make a calculation condition that basically needs two conditions to be met before it calculates.
First - If Termite Inspection is Yes
Second - and Location is "Varying Location"
Then calculated Travel Cost based on the two conditions above.
Right now if Termite Inspection is NO, then the location is calculated. Which it shouldn't unless Termite Inspection is Yes.
The screen shot is from the emailed Notifier
I took a look at your form, but could not find "Varying Location" field, so I checked by doing the following:
Location (Town or City) = Payson
Payson Sub areas = Whispering Pines
Termite Inspection = No
Now looking at it I see that 25.00 is added to it - but it is as per conditions on your form.
This is the one:
I do suggest checking it out on your form to disable it for the specific location that you do not wish that it is applied to, however if you wish that the condition matches each of the towns and that it is 0 if not termite selection, then you should add another condition that sets the field to 0 as long as termite selection is set to No and move it all the way up - above all other conditions.
That way it should make sure that the field is 0 until needed otherwise.
- My suggestion is to unhide the fields that you need to check and hide them only after everything is working right.
For starters, it seems like you understand what I'm trying to do. Good job. Some times its hard to describe the issues.
Next, I did try putting the condition listed below but it didn't work. It is at the top, I think. Actually, it shows it at the top, but I'm not sure if this is actually happening.
That is because the NO is selected by default. Preselecting the option won't trigger the condition so you need to keep it open/unselected.
Cool. Thanks. Looks like that worked.