Calculations fail when fields have underlines in their name

  • sherryperry
    Asked on July 9, 2015 at 1:53 AM

    I do not know why my form calculations are not staying, they are removed immediately after I click on finished.

    I have a form that I have gone through and double checked calculations but everytime I try to get it to calculate on the given values, by using one of the add on form calculators, it erases the selected fields to calculate.

  • Boris
    Replied on July 9, 2015 at 4:24 AM

    I assume that you are talking about your last edited form: http://www.jotform.us/form/51888515294164

    After checking a couple of calculations by clicking on their wand-shaped icon, I can see that some fields are missing from the calculations:

    Calculations fail when fields have underlines in their name Image 1 Screenshot 50

    I can see that there are a lot of fields with underlines in their names, and such fields can't be used in the calculations at this time as underlines have special meaning in our internal system.

    Calculations fail when fields have underlines in their name Image 2 Screenshot 61

    What I would recommend is that you please rename your fields such that they no longer have underlines in their names, and then add them to your calculations again.

    You can rename the fields by clicking on their little gear-shaped icon > Show Properties, and clicking on the Name field. Please simply remove the underlines from the name of each of these fields.

    Calculations fail when fields have underlines in their name Image 3 Screenshot 72

    When you re-create your calculations after removing these underlines, your calculations should remain correctly set up.

    Calculations fail when fields have underlines in their name Image 4 Screenshot 83

    I have also raised this issue with underlines in calculation fields to our developers, but as they already have a lot on their plate right now, we can't give you any estimate when or if this would be fixed on our end. For this reason, please perform the workaround fix as instructed above.

    I hope this helps. Please let us know if you need further assistance.