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.


  • Profile Image

    How to hide empty fields on email notifications

    Asked by john896 on June 08, 2015 at 03:41 PM

    As an example, we have an online Request for Quotation for Customs Brokerage services.

    The initial form has fields to input details about one item or commodity - however, there is a button to select additional items - if this is checked, additional input fields are displayed.

    The majority of submissions contain details for only one commodity code - however, the notifications include all available fields, whether completed or not. (see example below)

    Is there a way to suppress unused fields in emailed notifications? (I understand this would not be practical for Excel  reports, for example)

    Thanks, 

    John Barker


     

    jotform.com

     

     

     

    Question

    Answer

    Name and address

    This is a test

    Email Address

    john@axxell.ca

    Telephone (optional)

    2897711406

    Approximate Shipping Date (optional)

    06-08-2015

    Import or Export

    Import

    Single or Recurring (optional)

    Single

    If Recurring, approximately how many consignments per month are anticipated?

     

    Mode of Transportation

    Air

    Terms of Delivery

    FoB

    Web Link to Product Detail (optional)

     

    Commodity Description (Item 1)

    Test

    Country of Origin/Manufacture/Growth

    Canada

    Value (Item 1)

    100

    Currency

    CAD

    Harmonized System Number (If known)

     

    Additional Items?

     

    Commodity Description (Item 2)

     

    Country of Origin/Manufacture/Growth

     

    Consignment Value (Item 2)

     

    Currency

     

    Harmonized System Number (Item 2)

     

    Additional Items?

     

    Commodity description (Item 3)

     

    Country of Origin/Manufacture/Growth

     

    Consignment Value (Item 3)

     

    Currency

     

    Harmonized System Number (3)

     

    Additional Items?

     

    Commodity Description (Item 4)

     

    Country of Origin/Manufacture/Growth

     

    Consignment Value (Item 4)

     

    Currency

     

    Harmonized System Number (4)

     

    Additional items?

     

    Commodity Description (Item 5)

     

    Country of Origin/Manufacture/Growth

     

    Consignment Value (Item 5)

     

    Currency

     

    Harmonized System Number (5)

     
     
         
     


     

     

    Page URL:
    www.canadiancustomshouse.ca/TestPage.html

    Reports displaying Submissions empty fields email notifications
  • Profile Image
    JotForm Support

    Answered by Mike_G on June 08, 2015 at 04:53 PM

    You can do this by: (Please see image below)

    As for the result: 

    However, for Excel files, all fields will still show as column headers even if there are no data below it. 

    I hope this helps. Let us know if you have any other questions and we will be glad to help you anytime. Thank you. 

  • Profile Image

    Answered by john896 on June 08, 2015 at 07:17 PM

    Brilliant - that's exactly what I was looking for!  Many thanks.