JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Hide empty fields in confirmation email and reportsAsked by Joanna on November 10, 2014 at 11:33 AM
Our form is a long list of drop down box items that people can use to order different items. There is about 50 drop down boxes and somebody might select 4 or 5. In the confirmation email and reports it lists all the items regardless if they have been selected or not. It makes it very hard to read. Is it possible to print only the ones that have been selected?
As I check your JotForm, it is disabled and not having any drop down menus. Did you delete the JotForm in question?
It is possible to hide the unselected fields on email alerts by enabling the option Hide empty fields on emails from Preferences.
Please refer to the following guide with step-by-step instructions and graphical illustrations.
Please be noted that this feature works only with default email notifier.
You can hide the empty fields on the reports by selecting the option Auto hide empty fields from Submissions view and then download to Excel/CSV/PDF.
Hope this information helps. Let us know if you need further assistance.
The email alert instructions work. But not the report.
The “Auto Hide Empty Fields” only works from the page preview on the top. It does not work in the xls format on the bottom of the page submission page.
Any other suggestions?
I would just like to confirm. Do you mean that it does not work for you under the setup where you can view all submissions and download them in excel/CSV/PDF files?
Or do you mean once you download the file?
I think it’s both. In the browser where I see the table with all submission the empty fields are there and when I ask to download the xls file all the fields are there (including the ones nobody selected).
I took a look at your jotform "Lunch Order test 1" and I see that:
1. all fields are selected on the right, to be shown
2. Autohide empty fields is not selected
You will need to follow the directions given by my colleague above and unselect the fields that you do not want to see in the submissions.
Do let us know if you have any further questions.
The form I’m working on is under somebody else’s account. Here is the link to it.
You're right, in the xls file all fields are included regardless if the auto hide empty fields option is selected. I think in this case the PDF report could work better for you. Or you can use a macro in excel to auto hide empty columns. Please check this link: http://www.mrexcel.com/forum/excel-questions/678647-excel-visual-basic-applications-autohide-rows-no-value-certain-column.html
In this post there is a macro to hide empty rows, but you can use it to hide columns like this:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
For Each c In Range("D97:D350")
If c.Value = "" Then
c.EntireColumn.Hidden = True
c.EntireColumn.Hidden = False
Please note that you need to change the range value to include all the values in the Excel report.
Please give it a try and let us know if it works.
I have a new question regarding the same form. We use the calculation values with our drop-down boxes to calculate the total order. The problem is that after a while all the calculation values disappear. We tried to revert back to when they to when we are sure the form worked but we cannot get the calculation values back. It takes about 30min of copy-paste to get them all back and it would be the 3rd time we have to do it. HELP!
I've moved your other question to a new thread and shall be addressed there.