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

    Why Wont Notifications Return Negative Calculations?

    Asked by StudioBe on January 24, 2014 at 11:32 AM

    Was this whole calculation thing really ready to be released? I have a form that calculates our daily goals. It returns either a positing number if the goal is exceeded or a negative “ – “ if we are short. The positive numbers transfer just fine to the notifications. However, any negative numbers are returned as “0” on the notification. Is this another bug? This needs to be fixed asap. Starting to wonder what I am paying for if nothing works!

    calculations positive exceeded
  • Profile Image
    JotForm Support

    Answered by NeilVicente on January 24, 2014 at 12:18 PM

    We are terribly sorry for the inconvenience, but I'd like to inform you that we have already reported the bug via this ticket:

    http://www.jotform.com/answers/322283-Calculations-Not-Recognizing-0-

    We'll contact you as soon as there is progress made. Thank you very much for your patience.

  • Profile Image

    Answered by StudioBe on January 24, 2014 at 12:24 PM

    THIS IS NOT THE SAME BUG! It calculates it just fine and spits back a negative number. It just doesn’t transfer to the notification email. Instead of say $-500 like it says on the form, it puts a 0 into the notification email. Can you please read my post before you answer it?

  • Profile Image

    Answered by StudioBe on January 24, 2014 at 12:25 PM

    Do you understand what I am saying? The form works to calculate the negative number. It just doesnt put that negative number on the notification email. Instead it says "0".

  • Profile Image
    JotForm Support

    Answered by NeilVicente on January 24, 2014 at 12:32 PM

    Yes, I do understand what you mean, and I'd like you to know that this bug is related to the first one you have reported.

    I have added your findings to the report ticket.

    Again, thank you for your patience.

  • Profile Image

    Answered by StudioBe on January 24, 2014 at 12:39 PM

    How is this related to the first bug? The first bug was about how a numbers field would not calculate a zero. This is totally different. I am talking about a number field that WILL calculate a negative number. However, it will NOT transfer that negative number to an email notification. How is this the same? When can I expect to see it fixed

  • Profile Image
    JotForm Support

    Answered by NeilVicente on January 24, 2014 at 12:43 PM

    We cannot give an ETA for resolution, but we will inform you immediately when it gets fixed.

  • Profile Image

    Answered by StudioBe on January 27, 2014 at 11:17 AM

    I need to know if this is going to be fixed soon or if I should find another provider? I cannot use these forms to calculate goals for my business if they will not return a negative number. The form itself works great, it’s just the notification that defaults the number to zero. Please can someone at least provide me with a work around?

  • Profile Image
    JotForm Support

    Answered by ardy0689 on January 27, 2014 at 11:40 AM

    Hello,

    We really do apologize for this inconvenience. I have reviewed the nature of the issue but it involves notification emails. If the negative number is becoming 0 from the email, I can not think of a workaround for this situation as the handling of Notification Emails is hard coded deep into the JotForm system. Only our developers can fix this issue. Rest assured that there is already a developer assigned to this ticket. We will update you here on this thread for any resolution. However, like what my colleague has posted, we can not give yet a proper ETA for this. Please accept our apologies. Thank you

  • Profile Image
    JotForm Support

    Answered by NeilVicente on January 27, 2014 at 09:00 PM

    @StudioBe

    I have just released a fix for both problems

       - Calculations not recognizing 0
       - Negative result not being returned

    Let us know if encounter any other problems.

    Kind regards

  • Profile Image

    Answered by StudioBe on January 28, 2014 at 10:59 AM

    Neither problem is fixed! It is still acting the exact same way!!!!

  • Profile Image

    Answered by StudioBe on January 28, 2014 at 11:04 AM

    Still won’t calculate using a zero. AND it still wont return a negative number. I fail to see where you fixed anything!

  • Profile Image
    JotForm Support

    Answered by EltonCris on January 28, 2014 at 11:46 AM

    @StudioBe

    The mentioned fixed by my colleague is already working on your form. You should probably clear your browser's cache and cookies and then recheck.

    Here's my test with your form just now:

    Thanks!

  • Profile Image

    Answered by StudioBe on January 28, 2014 at 12:10 PM

    @JotForm Support

    Thanks for the example. However, using the same form, go back and input "Service Goal", "Service Projection", and "Service Sales". It will calculate both "Over / Short" fields. Now click in the "Over / Short" fields (as if to edit it). Once you click out to another field below, it will revert back to zero. Even though the numbers are calculated, when you attempt to edit them (as my employees are sure to do, even though they are "read only" fields), they revert to zero.

  • Profile Image

    Answered by StudioBe on January 28, 2014 at 12:13 PM

    @JotForm Support

     

    Also, Any negative numbers are still returning as zeros on the notifications. So, I fail to see what has been fixed?

  • Profile Image
    JotForm Support

    Answered by NeilVicente on January 28, 2014 at 01:01 PM

    @StudioBe

    The hotfix was for negative results being returned as positive, and zero (0) operands failing the calculation, as demonstrated on this example.

    However, it does seem like the problem is more complicated than what was initially observed.

    The developer responsible for the calculation feature is on a vacation, so I have taken over it. I cannot guarantee an ETA, but I will have this fixed completely as soon as possible.

    By the way, to help us solve this issue faster, may we ask you what the calculations/equations should be for form https://www.jotform.com/22537198705965?

    We will look forward to your cooperation. Thank you!

  • Profile Image

    Answered by StudioBe on January 28, 2014 at 01:22 PM

    Yes, the form has always worked as the example above does. The form returns the negative number (displays it in the field). Its just when you submit the form, the notification shows all negative numbers as zeros. Make sense? As for the form linked above, there are to many calculations to list out. If we focus on the first "goal" area of the form, it’s as follows.

    Over / Short Service Goal: [{totalService} - {totalService56}]

    Over / Short Projection: [{totalService} - {startingService}]

    It is taking the “Total Service Sales” field and subtracting the “Total Service Goal” field to get the difference for the “Over / Short Service Goal” field. It is also taking the “Total Service Sales” filed and subtracting the “Starting Service Projection” field to get the difference for the “Over / Short Projection” field.

    There are times when these are going to be negative numbers because they do not always hit their goals. The goal here is to know how much they were short so they can make it up the next day. I would really like to utilize this so please know the sooner this can be fixed the better.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on January 28, 2014 at 01:32 PM

    Thank you for those information. I will update you accordingly.

    Your patience is much appreciated.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on January 28, 2014 at 09:03 PM

    I have released a fix that cleans up duplicate calculations -- something I found on your form that messes up some of the field values.

    As for your original issue:

    Number fields are not designed to display negative numbers. Hence, upon submitting the form, the negative values are turned into zeroes.

    A solution for this problem would be to replace the number fieldswhich you expect to receive negative results with regular Text Boxes.

  • Profile Image

    Answered by StudioBe on January 28, 2014 at 09:18 PM

    @JotForm Support

    That would work just fine as soon as you fix the bug that stops text boxes from displaying decimal point values. You see, I have to be able to see decimals so I cant use a regular text box. I would appreciate a real fix!

  • Profile Image
    JotForm Support

    Answered by NeilVicente on January 28, 2014 at 09:33 PM

    The fixes I have released so far are real and they do address some bugs that affect the calculation feature's functionality.

    Case in point: Calculations failing when an operand is 0

    As for the regular text box not displaying decimals, well, I have just tested, and they DO show decimals.

    Check out this screenshot:

    Demo form: http://www.jotformpro.com/form/40278002654954?