Form Calculation Widget Default Value

  • Profile Image
    US_Sailing
    Asked on October 23, 2017 at 03:51 PM

    Hello,

    I am using the Form Calculation Widget to do many unit conversions in my form. Each field has a hidden field associated with it that performs the calculation.

    Scenario:

    1) Create a numeric form field

    2) Create a Form Calculation Widget field equal to 2* the numeric field. Make this field hidden.

    3) Select "Hide Empty Fields" in the advanced settings of the Notification email

    4) Test the form by entering NOTHING AT ALL, just hit submit. You will see the original field is not contained in the notification email (appropriately) but the hidden Widget field comes through as a 0.

    I would like the widget field to not be returned if the original entry is empty.

    Please help. Thank you.

  • Profile Image
    BDAVID
    Answered on October 23, 2017 at 06:18 PM

    Whats the form you are working on? Zero is usually setup as the default value for Form Calculation widgets, make sure to remove it:

    1508796984defaultvalue.gif

    Let us know if you need more help.

  • Profile Image
    US_Sailing
    Answered on October 24, 2017 at 08:30 AM

    Thank you for your reply.


    Indeed, I should have noted in the original statement that I HAVE removed 0 as the default result as you describe and nevertheless a 0 is returned in the notification email.


    Thank you for considering this further.

  • Profile Image
    BJoanna
    Answered on October 24, 2017 at 11:32 AM

    I am unable to replicate the issue you reported.

    1508858985calc.gif

    Here is my demo form: https://form.jotform.com/72965028002957 

    Feel free to clone it

    If you are still unable to resolve this issue, provide us your form so that we can test it. 

  • Profile Image
    US_Sailing
    Answered on October 24, 2017 at 12:01 PM

    Thank you again for your reply. I concur that your form is representative of the case, but does not evidence the same issue that mine does.

    If it is helpful, my form lives here: http://www.ussailing.org/racing/offshore-big-boats/trial-application/

    My advice to readily replicate the issue is to complete the required fields on the first page selecting NO to the last 4 yes/no questions. You would then receive an email like the one below where all the "METRIC..." fields are those hidden fields in question that I do not expect a return from.

    Thank you for your diligence.


    1508860676notif email.jpg 

  • Profile Image
    BDAVID
    Answered on October 24, 2017 at 01:26 PM

    They are showing zero values, as the calculation fields will always perform the multiplication, so in this case will be "zero value * fixed value"

    1508865674value.png

    My recommendation would be to perform the calculation through conditions instead. Something like: https://www.jotform.com/help/268-Conditional-Logic-Inserts-Text-Calculation-Into-A-Field 

    1508865913matricloa.png

    Let us know if you need more help.

  • Profile Image
    US_Sailing
    Answered on October 25, 2017 at 10:50 AM

    Thank you for the reply, again.

    It is simply strange that this was not a problem in BJoanna's test form, but it is for mine. Is there any explanation for this? Is there any other method you could recommend aside from conditional statements?

  • Profile Image
    Kevin_G
    Answered on October 25, 2017 at 12:27 PM

    I have checked the widgets on your form and noticed the calculations you're performing, please note that the calculation is performing even if there is not an entered value on the involved fields and this is why you can see those 0.00000 as default values. 

    Using the conditions as suggested by my colleague above, will allow you to perform the calculation only when the involved field has a value, if the field is empty the calculation will not be performed and nothing will be inserted in the result field. 

    If you have any questions, please let us know. 

  • Profile Image
    US_Sailing
    Answered on October 25, 2017 at 01:15 PM

    Thank you, Kevin. I suppose that is the last resort.

    It is still unclear why this is not an issue for BJoanna's test above (https://form.jotform.com/72965028002957). In the demo video, she very clearly does not have this issue despite replicating my scenario exactly. I cloned the form and confirmed that functionality. Do you have any insight as to why this is?

  • Profile Image
    BJoanna
    Answered on October 25, 2017 at 01:32 PM

    I inspected the form you provided and the settings of the form calculation widgets are not the same as in my form. Inside of your form 'Show empty decimal places' option is checked and inside of my form it is not.

    1508952294settings.JPG

    If you disable this option on all of your widgets you will no longer see those 0.00000 inside of the emails.

    Hope this will help. 

  • Profile Image
    US_Sailing
    Answered on November 01, 2017 at 01:37 PM

    Good catch, thank you BJoanna!


    Best,