Form Calculation Widget Default Value

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.

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

Let us know if you need more help.

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.

I am unable to replicate the issue you reported.

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. 

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.

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

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 

Let us know if you need more help.

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?

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. 

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?

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.

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. 

Good catch, thank you BJoanna!

Best,