I want such a report where label of field should not appear in excel

  • Profile Image
    nilwarnds
    Asked 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

  • Profile Image
    Victoria_K
    Answered on April 02, 2018 at 03:49 PM

    Hello nilwarnds,

    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.

    1522698505screenshotyg35v.png

    We will gladly assist if you need more help.

  • Profile Image
    nilwarn dnyaneshvar s
    Answered 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.

  • Profile Image
    BJoanna
    Answered 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.

    How to Pass Field Value to Another Field?

    Here is an example for Address field and Matrix dynamique widget.

    1522741590hide.gif

    Here is my demo form: https://form.jotform.com/80921336040952 

    You can clone it and then test your cloned form. 

    Hope this will help.