- US_SailingAsked on October 23, 2017 at 03:51 PM
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.
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.
- JotForm SupportBDAVIDAnswered 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:
Let us know if you need more help.
- US_SailingAnswered 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.
- US_SailingAnswered 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.
- JotForm SupportBDAVIDAnswered 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"
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.
- US_SailingAnswered 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?
- JotForm SupportKevin_GAnswered 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.
- US_SailingAnswered 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?
- JotForm SupportBJoannaAnswered 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.
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.
- US_SailingAnswered on November 01, 2017 at 01:37 PM
Good catch, thank you BJoanna!