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.


  • Profile Image

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

    Asked by vfxbro 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. 

    Page URL:
    https://form.jotform.us/71219000203133

    Screenshot
  • Profile Image
    JotForm Support

    Answered by ashwin_d 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

    Answered by vfxbro 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

    Answered by vfxbro on May 03, 2017 at 04:27 PM

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

    https://&feature=youtu.be

  • Profile Image
    JotForm Support

    Answered by Kevin_G 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.