Submission Email does not include all fields from the Form

  • kwaterskibros
    Asked on August 19, 2015 at 7:14 PM
    When the form is submitted, the emails received do not include the price per lineal foot cost. The field is stated but a price is not included. How would I go about fixing this? Also, I would like all of the empty fields that were not filled out on the form to not be included in the email. How would I fix this? Lastly, I would like the "Price per Lineal Feet" calculation field to recalculate after a drop down field is changed from its originally entry. As of now it does not change if the user re selects an option from the drop down.
  • Boris
    Replied on August 20, 2015 at 1:03 AM

    When the form is submitted, the emails received do not include the price per lineal foot cost. The field is stated but a price is not included.

    This is happening because you are updating a Calculation field with Conditional Logic. Conditions are then racing with the calculation that is set upon the field. When you are viewing the form itself, the conditions are winning, are it appears to be correctly calculated.

    However, when you submit the form, the calculation is able to be fired and it calculates to what it is set to calculate - a dollar sign.

    Submission Email does not include all fields from the Form Image 1 Screenshot 40

    What I would recommend that you do instead, is to remove this calculation field, and create a regular number field instead. Then, you can rename it to be named {pricePer}, as your calculation field was named.

    Submission Email does not include all fields from the Form Image 2 Screenshot 51

    Submission Email does not include all fields from the Form Image 3 Screenshot 62

    Check if the conditions have been automatically applied to the new field, and update their "Output" field to this new number field if they haven't been.

    Check if your notifications emails are referencing the name of the new Number field, which was set to {pricePer} in the steps above.

    That would be it.

    I would like all of the empty fields that were not filled out on the form to not be included in the email.

    Please take a look at our guide on How to Hide Empty Fields on Email Alerts. Please not that this only works if your Data Table in email notifications is locked. It doesn't work with custom text version such as the Notification that you are currently using. You will have to re-create your Email Notification to be able to use the option for hiding empty fields.

    I would like the "Price per Lineal Feet" calculation field to recalculate after a drop down field is changed from its originally entry.

    After switching away from a calculation field that was conflicting with conditions, and relying solely on the conditions to update this field, does this still occur?

    Please let us know if you need further assistance.

  • kwaterskibros
    Replied on August 20, 2015 at 11:49 AM

    Thank you. All of the problems were fixed except for the last question.

    The "Price per Lineal Feet" calculation field does not recalculate after a drop down field is changed from its original entry. If I select 6 from "Length" and 5 from "Diameter" a price is calculated. However, if I want to reselect 12 from "Length" and keep 5 as the diameter, it does not recalculate. This is a problem because the price is not accurate. 
  • Boris
    Replied on August 20, 2015 at 2:04 PM

    Thank you for letting us know that the emails are not working the way that you wanted. :) As the calculation issue is a separate issue to the submission emails discussed in this thread, I have moved that query to its own thread, here:

    http://www.jotform.com/answers/644056

    We will be assisting you with that issue there. Thank you.