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

    Editing format of Google Spreadsheet

    Asked by MTCFVA on February 21, 2017 at 04:00 PM

    Hi

    I'd like to play around with the format of my Google Spreadsheet which records submissions. Is there an area of settings where I can do this. 

     

    In particular I'd like to select which fields from the form/submission come through to the spreadsheet. 

    I'd also like to change the orientation (a la transpose) so that the fields are listed on the vertical axis and each new submission populates a new columns rather than a new row. Is this possible?

    Thanks, 

    James

  • Profile Image
    JotForm Support

    Answered by EltonCris on February 21, 2017 at 06:18 PM

    Changing the formatting of the integrated spreadsheet will most likely break the integration. 

    We suggest to create a new tab sheet and do all the formatting of the data on the new sheet by copying the data from the first sheet to the new sheet using data reference formula https://support.google.com/docs/answer/75943?hl=en

    You can create a new sheet in the bottom section of the spreadsheet file.

    Hope this helps!