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

  • vfxbro
    Asked on May 3, 2017 at 5: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. 

    Jotform Thread 1134827 Screenshot
  • Ashwin JotForm Support
    Replied on May 3, 2017 at 7: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!

  • vfxbro
    Replied on May 3, 2017 at 4: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. Using calculate fields conditions and the results are inconsistent Screenshot 20

     

     

     

     

  • vfxbro
    Replied on May 3, 2017 at 4:27 PM

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

  • Kevin Support Team Lead
    Replied on May 3, 2017 at 6: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.