What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Calculated fields missing in notification emailAsked by NRCsupport on October 29, 2015 at 09:37 AM
My form contains some fields which contain calculated values. They are set using conditions. The fields display correctly, but are not given in the notification email. Presumably they are being treated as empty. This is very annoying.
The fields concerned are both labelled "Total cost £"
I have found a reasonable work around. Looking back in the forum, I find that I had a similar problem about a year and a half ago. By using simple calculated fields, rather than conditional ones, it seems to work as expected.
BUT that leaves the question why do calculated fields with conditions get cleared on submit, even when they are not hidden?
I did a test on your form and in the autoresponder i received, the Total Cost field was listed along with the value.
I also check the notification the Total Cost field was also listed.
Is there any other additional field with the total on your form, I checked on a clone and found only one.
I just saw you recent post, it appears the workaround you implemented is utilizing the calculation widget you've mentioned.
In your conditions do you have one that caters for values less than zero, suppose the user clears the quantity field before inputting a new number.
Ill do some tests using conditional calculation and I'll let you know of the probable cause.
The field for entering the number of tickets required has lower and upper limits, so anything out of range (such as negative) will not be accepted.
Is your form by any chance embedded on your website? It can happen when form is embedded and there are conflicts that the form does not work properly (depending on the exact conflict).
I do presume that this might be the cause of the field being there and not being there.
If you are only sharing and using the direct link to the form, then this would not be the reason.
It is NOT embedded.
I checked your jotform http://www.jotformpro.com/form/40503979576971 and I noted the ff:
#1 There were 2 'Total Cost E' on the form. So, there were also 2 fields on the Notification Email
#2 The settings "Hide Empty Email Field" was set as Enabled. This means that if the submission data is empty, it will not show in the Notification email.
#3 You can compare the data in submission email to the actual submissions -- you will be able to identify then which submission actually have 'Total Cost E' value. So if its empty it should not show on th email.
So far I have checked the existing submission data versus the sent email and it seems to be working as intended. Empty 'Total Cost E' value in submission also show empty in Notifier.. and filled in 'Total Cost E' value also shows in the email.
Can you point to us to the latest submission data in your form that actually have 'Total Cost E' value but never show it on the Notification Email?
We will check further if there is indeed issue on the Notifier or Condtions.
Hi, Thanks for that. As I explained a bit earlier in the thread, I have found that normal calculated fields work correctly (as you have found), but calculations in a condition seem to be treated as unentered fields when creating the emails.
By calculation in a condition I mean a condition like:-
if event is equal to bbq
insert <some calculation> into <some field>
I have found that in this case <some field> is treated as empty and is excluded from the emails.
I can't seem to replicate the problem. Here's a sample form that I made: https://form.jotform.com/53054307683960. You can clone it and see how if it is the same setup you have in your form (I'm not sure if you are still having the same problem because you mentioned that you applied a workaround).
Here's the condition I have setup
In my email notification, the text box with the calculation shows correctly.
Perhaps you could share us a clone form with the previous setup you have? It's possible that the email template may not have been properly updated, leaving the old field tags intact. We'll wait for your response.
Apologies for the inconvenience.