Help needed in setting up nested calculation If conditions on my form

  • psllcom
    Asked 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) 

  • Kiran Support Team Lead
    Replied on August 24, 2016 at 2:05 PM

    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. 

    https://www.jotform.com/index.php?formID=62238422768158&old

    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. 

  • psllcom
    Replied on August 24, 2016 at 2:54 PM

    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.  

  • Mike
    Replied on August 24, 2016 at 3:58 PM

    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.

    Help needed in setting up nested calculation If conditions on my form Image 1 Screenshot 40

    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.

    Help needed in setting up nested calculation If conditions on my form Image 2 Screenshot 51

    Help needed in setting up nested calculation If conditions on my form Image 3 Screenshot 62

    If this does not help, you will need to redesign your calculations setup.

  • psllcom
    Replied on August 25, 2016 at 2:36 PM

    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? 

  • psllcom
    Replied on August 25, 2016 at 3:01 PM

    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. 

     

    Thanks! 

  • Kiran Support Team Lead
    Replied on August 25, 2016 at 3:28 PM

    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!