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

    Not able to customize formatting and colors of google spreadsheet

    Asked by fwcontent on March 21, 2017 at 04:06 PM

    Is it impossible to change the spreadsheet formatting/colors with this integration? Whenever a new report comes it it gets changed.

    This is a re-post of a comment on How to Integrate Form with Google Spreadsheet

  • Profile Image
    JotForm Support

    Answered by jonathan on March 21, 2017 at 06:58 PM

    You are correct. It is not possible to customize the Submission sheet that was being used by the Google spreadsheet integration of the form.

    What you may want to try instead is to use another Sheet on the spreadsheet.

    You can customize the other sheet (aside the Submission sheet). You can import/copy the data from the Submission sheet into the sheet you need to add formatting.

    Use the google docs import function to copy the data from Submission sheet to another sheet.

    Let us know if you need further assistance.