Using "calculate fields" conditions and the results are inconsistent.

  • Profile Image
    vfxbro
    Asked on May 03, 2017 at 05:07 AM

    Understanding this will require an extensive look at the many conditions used to setup this customized shopping cart. The total at the bottom of my form will randomly work off and on. Additionally the "Approximately 5 Minutes Highlight Video ($1,100)" field should automatically be checked on when the packaged is set to Sapphire but it often isn't. 

  • Profile Image
    ashwin_d
    Answered on May 03, 2017 at 07:21 AM

    Hello vfxbro,

    I'm sorry for the trouble caused to you. 

    I did check your form and found that you have added 36 conditions to insert value in several form fields. Based on your conditions, I am not sure if I have understood your calculation requirement correctly.

    I would suggest you to please list down all your calculation requirement and we will try to help you. 

    We will wait for your response.

    Thank you!

  • Profile Image
    vfxbro
    Answered on May 03, 2017 at 04:23 PM

    I need the value in "Total" to equal the sum  of the following fields:

     

    Amount, vid total, 5 total, 60 total, 30 total, DVD amount, raw footage total, and drone total.

     

    I currently have the following condition used to fill the "Total" field. However I'm finding that sometimes it randomly will and won't work when changing the value of attributing fields. 

     

     

     

     

  • Profile Image
    vfxbro
    Answered on May 03, 2017 at 04:27 PM

    Additionally, here is a short video further illustrating the problem.

    https://&feature=youtu.be

  • Profile Image
    Kevin_G
    Answered on May 03, 2017 at 06:49 PM

    I have cloned your form and I can see it works on my end; however, I would suggest you to check your conditions and make sure there are not conflicts between them, additionally, I would suggest you to set calculation values to your fields options, this way the condition does not capture the entire string, that may be causing conditions to intermittently work.

    This guide will help you setting up calculation values to your form: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    Please, if after assigning the values your conditions still do not work, please let us know.