Is there a way to hide empty fields in the jotform report? (spreadsheet in auto-response email)

  • Profile Image
    bgenrich
    Asked on February 26, 2013 at 11:53 AM

    I'm making forms that allow customers to get quotes on complicated products. Therefor there are a lot of conditional fields within my forms that do not need to be filled out. 

    >> How can I have these empty fields withheld from the report generated for the auto-response and email notifications?

    This is probably the best example of a form that has A LOT of empty fields depending on the path the customer takes.
    FORM  << Check out the "Thank You" and "Award Plaques" Auto-responses.

    Thanks,
    Andy 

  • Profile Image
    jeanettebmz
    Answered on February 26, 2013 at 12:47 PM

    Email alerts cannot be changed dynamically to hide Empty fields . However, this feature has been requested long time ago by several customers

    The only way to hide empty fields is by going to your submissios page and choose Autohide Empty fields from the menu

     

    Another workaround might be to setup several email alerts and use conditional logics as on these exampls

    https://www.jotform.com/answers/19905-hide-hidden-fields-on-submissions?&&updatemessage=10732640770

    https://www.jotform.com/answers/38682-Conditional-Fields-in-Notification-Email

  • Profile Image
    bgenrich
    Answered on February 26, 2013 at 01:40 PM

    Thank You! I'll give that a try...

    -Andy 

  • Profile Image
    abajan
    Answered on February 26, 2013 at 02:44 PM

    Hi Andy,

    There's actually another alternative which was recently posted on the forum by a couple of my colleagues. To demonstrate, complete just a couple questions (the Direct e-mail address field and any other) in this form and submit it. You'll see that although the form has several fields, only those you completed (plus the phone number and date) show up in the auto-response.

    The only drawback with this method is that since it uses a script, you would have to embed the form's full source into a web page along with the script. (See this guide for the pros and cons of the various form codes.)

    If you would like info on how to implement this method, we'd be happy to help.


    Wayne

  • Profile Image
    bgenrich
    Answered on February 27, 2013 at 10:47 AM

    Genius! Thank You very much Wayne. My web guy is out of town for a week but I look forward to showing him this post and giving it a try. I'll be sure to let you know how it goes.

    Thanks again,

    Andy