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

    Basic formula not calculating. Not sure why.

    Asked by wolfpaw69 on December 15, 2015 at 05:12 PM

    I've got a formula that charges more for homes as they get older. When I get to 2011 or newer, its not calculating correctly.  It should be 0 but returns 150, the same for extremely older homes.  Not sure why.  Can you help?

    Page URL:
    https://form.jotform.com/53127112452141?

    Screenshot
    same OR correctly a
  • Profile Image
    JotForm Support

    Answered by Kevin_G on December 15, 2015 at 07:16 PM

    Hi,

    I have checked your form and I can see you have some conditions that are not working, I would suggest you to delete them or disable in order to avoid issues :

    Also , I could fin the condition that is adding the value to your field, disable it and try to fill the field with the 2011 year, I would suggest you to change it in order to not affect another conditions.

    Please, let us know if it works.

    Regards.

  • Profile Image

    Answered by wolfpaw69 on December 24, 2015 at 02:30 PM

    I disable that calculation and it still returns $150

  • Profile Image

    Answered by wolfpaw69 on December 24, 2015 at 02:33 PM

    I actually deleted the line of code that produces $150 and I still get a $50 result.  It there a time delay between saving and viewing?

  • Profile Image
    JotForm Support

    Answered by BJoanna on December 24, 2015 at 04:00 PM

    It seems that you were able to resolve this issue. I have tested your form and when I entered 2011 in Year Built field I got a $0 result in Age Cost field.

    Yes, sometimes there is a delay between saving and viewing. In that case you can reload your form of log out and log back in to your account. 

    Feel free to contact us if you have any other questions. 

  • Profile Image

    Answered by wolfpaw69 on December 24, 2015 at 06:57 PM

    Still happening...this was taken just a few minutes ago.  I do see yours returned a $0.  This is in google.  I'll have to try IE

  • Profile Image
    JotForm Support

    Answered by BJoanna on December 25, 2015 at 02:32 AM

    I have tested form you provided http://www.jotform.us/form/53127112452141, one more time and I was not able to replicate mentioned issue. 

    However from screenshot you provided, I think that you are working on your other form http://www.jotform.us/form/53564138647160, on which I was able to replicate mentioned issue. 

    To fix this you need to follow steps provided by my colleague Kevin_G and disable or delete conditions for fields that are deleted form your form and to delete or disable condition 84, which is passing value 150 to your Age Cost field. 

    I have cloned your form http://www.jotform.us/form/53564138647160 and disabled mentioned conditions on my cloned form. Here is my cloned form: https://form.jotform.com/53580777124965 

    Feel free to clone it.

    Hope this will help. Let us know if you need further assistance.