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.
Help needed in setting up nested calculation If conditions on my formAsked by psllcom on August 24, 2016 at 12:53 PM
Thanks in advance for your help. I'm a tad bit stuck on trying to do a calculation because I have so many variables.
I essentially need to do a nested if:
IF photoshoot options is standard photoshoot, AND video upgrades OR photo upgrades is filled, then calculate the value of video and photo upgrades.
Obviously, I could create 2 different conditions, one for standard and video and another for standard and photo, but that just seems so inefficient.
Also, is there a way to better view conditions? I've got so many right now from a lot of testing that it's hard to go through them to see what is valid and what isn't. At this point, it would almost be better for me to map it out on paper and delete all conditions and start over, which isn't all that efficient either.
I'm really liking jot forms. I just have to get this to work 100% before my boss will pay for it. It's certainly better than google forms, but I have to get all of my boss' requirements worked out first.
(Note: To use to form to see 100% what I'm referring to, sqft must be filled out (any number) - then the form will start expanding)
I understand that you want to calculate the photo and video upgrades if photoshoot options is Standard photoshoot. After analyzing the form, I think we can setup only one condition to check the photoshoot option since you are having calculation values for the photo or video upgrades. You can include these fields directly in the calculation wizard so that if they are selected they will be calculated automatically.
Also, is there a way to better view conditions?
Unfortunately, there is no other way to view the conditions at the moment. However, you may view the conditions in the old interface that might help you. Please try reloading the form builder by adding &old to the URL.
You may load the form again by replacing &old with &test to use the new conditions wizard later.
Please give it a try and let us know if you need any further assistance. We will be happy to assist.
I think I understand you are saying have one condition as:
If standard photoshoot is selected then calculate the 2 upgrades.
There's a slight issues with that because based on the sqft, different packages will appear or not as well as when the upgrades are selected. Thus, I have to have the additional condition as a check and balance to make sure that the fields in the other upgrades haven't been selected instead.
This is needed because if a user changes something in the form causing the shown and hidden fields to change and inadvertently checking the wrong thing before changing, would cause the calculation to be incorrect.
The form is currently configured to save the user input, so that the previous selections might affect the calculations.
I would like to suggest disabling the Continue Forms Later option.
Also, if you do not want to deal with the hidden values, you might consider tying the Clear Hidden Filed Values option set to Clear On Being Hidden.
If this does not help, you will need to redesign your calculations setup.
I tried going to the &old link and while it's better for some aspects, I like the new with other aspects.
Since i went to the &old, I seem to be defaulting to that. I tried the obvious &new, but I'm still on the old. How do I switch between old and new?
Oh, I'm dumb. I see the &test above in this thread now. Not sure how I overlooked that before. You can close this case again.
No problem. Please do not hesitate to get back to us if you need any further assistance. We will be happy to help.
Thank you for using JotForm!