How to hide label, but diplay it in the Excel report.

  • OSTA2015
    Asked on July 14, 2017 at 11:15 AM
    That helped thanks, now was wondering about this. When I collect the data for this form and look at the data for Step 2 to 6 the header for each column shows No Label 3 No Label 4 etc. this is when I view it in excel and was wondering is there a place to put a title so when it comes into excel it no longer would say No Label ?

    https://form.jotform.ca/71935436574263

    Thanks
  • David JotForm Support Manager
    Replied on July 14, 2017 at 11:31 AM

    In this case, please do the following:

    1) Go to your CSS section, and cut this code and paste it in a notepad:

    #label_81,#label_82,#label_83,#label_84,#label_85,#label_86,#label_87,#label_88,#label_89,#label_90,#label_91,#label_92,#label_93,#label_94,#label_95,#label_96,#label_97,#label_98,#label_99,#label_100,#label_101,#label_102,#label_103 {

        display : none !important;

    }

    How to hide label, but diplay it in the Excel report Screenshot 40

    2) Now, type a label on each Configurable List widget:

    How to hide label, but diplay it in the Excel report Screenshot 51

    3) Put the code back in the CSS area:

    How to hide label, but diplay it in the Excel report Screenshot 62

     

    In this way the titles will be displayed in your Excel report. Let us know if you need more help.