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

    Will coloring cells in google spreadsheets affect the data or integration?

    Asked by alphaemc on November 17, 2016 at 09:03 AM
    Also, will colorizing certain rows in my linked Google spreadsheet adversely affect form data from being collected?
    coloring spreadsheet color data cell spreadsheet color google spreadsheets integration
  • Profile Image
    JotForm Support

    Answered by KadeJM on November 17, 2016 at 11:31 AM

    Are you referring to just coloring the text or background of the spreadsheet cells?

  • Profile Image
    JotForm Support

    Answered by KadeJM on November 17, 2016 at 11:41 AM

    Here's a test example of such just to show you that is certainly possible if that is what you meant.

    I colored the background of two of the columns and also changed the text color of another then sent some submissions and it does not break the integration.

    Usually only drastic changes such as trying to move your data around or changing the field names is what would tend to break it if anything.

  • Profile Image

    Answered by alphaemc on November 17, 2016 at 11:44 AM
    Coloring just the background.
    ...
  • Profile Image
    JotForm Support

    Answered by Welvin on November 17, 2016 at 01:18 PM

    Changing the color shouldn't break the integration. You may consider doing it on a test form with google spreadsheet integration so just to make sure. My colleague already made a test and I think that's proof enough.

  • Profile Image

    Answered by alphaemc on November 17, 2016 at 01:44 PM
    Thank you.
    ...