What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    How to make the column headers in Google Spreadsheet different from the field labels showing in the form?

    Asked by SLIGP on January 20, 2017 at 11:30 AM

    There is conflicting information in the forums about the ability to create a label specifically for reporting when you build your questions.  Right now, the full body of the text is showing up when I download the report, which makes it very messy and requires customization of the headers every time I pull a report.  It look like at one time their was a field to designate a label for each question, but for the life of me I can't find the settings option for that or to customize question layout other than position.  Help please. 

  • Profile Image
    JotForm Support

    Answered by Kevin_G on January 20, 2017 at 12:51 PM

    You're able to further customize your PDF layout as you want, besides the ability to move the fields you can also format them as you need and even add your custom text, text that is not present in the form. 

    On the top toolbar you will find the options to add fields, images, custom text and all this to your PDF report. 

    If you would like to change the field labels then you would need to change them in the form as ell, for example, if you would like to change the "Speaker Email" label you would need to change it in the form directly in the field. 

    Hope this helps. 

  • Profile Image

    Answered by SLIGP on February 01, 2017 at 03:06 PM

    This example is for just modifying a PDF report.  I am dealing with the excel database created from all of the data.

    For example a survey question is? " Would you like a sleeping room for the night of October 12."  The entire questions plugs in as the column header in excel.  I would like the header to be something short like "room".  Is there an option for report label vs. actual survey label?   If not, there really needs to be!

  • Profile Image
    JotForm Support

    Answered by Mike_G on February 01, 2017 at 03:49 PM

    Thank you for clarifying your concern.

    There may be a workaround that would require you to change the labels from the form to the one that you would like to appear in the spreadsheet report. Then, hide those labels on the form and inject the labels that you would like to show on the form using CSS codes.

    Please check this form:

    https://form.jotform.com/70316073993964

    Clone the form to your account and integrate it with Google Spreadsheet. 

    After that, make a test submission and notice that the field labels in the form are different from the spreadsheet's column headers.

     

    You can also check the CSS codes I've injected in the form above.

    https://www.jotform.com/help/117-How-to-Inject-Custom-CSS-Codes