Calculations fail when fields have underlines in their name

  • Profile Image
    sherryperry
    Asked on July 09, 2015 at 01: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.

  • Profile Image
    Boris
    Answered on July 09, 2015 at 04: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:

    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.

    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.

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

    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.