- nilwarndsAsked on April 02, 2018 at 02:45 PM
i want such a report where label of field should not appear in excel file.only actual data should appear in excel file.when i use some widget the label appear with data.so i want to avoid that.how to do that while generating reports.
This is a re-post of a comment on How to View Form Submissions
- JotForm SupportVictoria_KAnswered on April 02, 2018 at 03:49 PM
Can you kindly tell us which widget do you use so we could check it closer?
Field labels are shown on 1 row at excel reports, so I can suggest removing that row.
We will gladly assist if you need more help.
- nilwarn dnyaneshvar sAnswered on April 03, 2018 at 01:44 AM
when i use address field its sublabels such as street ,city,pincode appear in excel sheet.so i dont want those to appear.i am also using matrix dynamique.in this also sublabels appear in excel sheet.so iwant only data to appear.any help in this regards.
- JotForm SupportBJoannaAnswered on April 03, 2018 at 03:51 AM
When the Excel report is created by default each of the Address field sub-labels will have its own column. The only way to remove them from Excel file is to do it manually, once you download the file. It is the same for Matrix dynamique widget.
As a possible workaround, you can add an additional field to your form, for example Long Text Entry field, and pass the data from Address field to that field. The new field can be hidden on the form but it will be shown inside of the report. Then you can omit the Address field from the report.
Here is an example for Address field and Matrix dynamique widget.
Here is my demo form: https://form.jotform.com/80921336040952
You can clone it and then test your cloned form.
Hope this will help.