Form Conditions: Update/Calculate field causing negative result

  • itimaginglogs
    Asked on November 10, 2021 at 6:47 AM

    In my Log form, while filling it out the Total Add Ons field is calculated with a few conditions. Its calculated into the Cal Add On field and then that is copied into the visible Add On field. When I test it out it works and autofills for me but if I press TAB or just click on the next question the Total Addons changes to a negative number. The calculation is Total in Archive - Total Scanned, and when it changes it is changing to - Total Scans (as if the number in Total in Archives is turning into 0). And then if i click around to other fields a little it resets but it is annoying and my employees will not know how or want to do that every time it messes up. Please help.

  • Sam_G
    Replied on November 10, 2021 at 8:22 AM

    Hello Itimaginglogs,

    May I ask for the form URL?

    https://www.jotform.com/help/401-where-to-find-my-form-url/

    I have checked your forms and none of them have the Total Add ons field.

    We will wait for your response.

  • itimaginglogs
    Replied on November 10, 2021 at 8:44 AM
    https://www.jotform.com/assign/213007016216036/213113677909056
    ...
  • Christopher JotForm Support
    Replied on November 10, 2021 at 9:28 AM

    Hi,


    I have reviewed your form conditions and found out that this condition is the one responsible for generating the negative value. 1636554174 618bd5be0562a  Screenshot 10
    Please remove Fill in the Blank and replace it with Number of patients in the Sono Machine Archive.



  • itimaginglogs
    Replied on November 10, 2021 at 2:33 PM
    It would be really helpful if we could name our conditions or if they were
    at least numbered or lettered. Or a short description of what it does.
    And thank you!
    ...
  • Samuel_Ray Jotform Support
    Replied on November 10, 2021 at 6:58 PM

    Hi there,

    The condition's functions are already visible from the conditions page. It is showing which fields are involved and what happens to a field when the parameters were met for the first field.

    1636588436 618c5b9430a4d  Screenshot 10

    And if you can notice on the lower left part of the condition, it also has a number on it. That corresponds to how many conditions your form has and it shows its ordinal number from the first condition.

    I hope this answers your question. If you need further help, please don't hesitate to reach out to us. Thank you!