Form Conditions: Update/Calculate field causing negative result

  • Profile Image
    itimaginglogs
    Asked on November 10, 2021 at 06: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.

  • Profile Image
    Sam_G
    Answered on November 10, 2021 at 08: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.

  • Profile Image
    itimaginglogs
    Answered on November 10, 2021 at 08:44 AM
    https://www.jotform.com/assign/213007016216036/213113677909056
    ...
  • Profile Image
    Christopher_T
    Answered on November 10, 2021 at 09: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_
    Please remove Fill in the Blank and replace it with Number of patients in the Sono Machine Archive.



  • Profile Image
    itimaginglogs
    Answered on November 10, 2021 at 02: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!
    ...
  • Profile Image
    Samuel_Ray
    Answered on November 10, 2021 at 06: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_

    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!