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

    Google Spreadsheet Integration: Customized Formatting suddenly lost

    Asked by dtplisney on March 19, 2015 at 06:19 AM

    The Google sheet has change name for no reason and the new sheet does not have all the customised formatting I had applied over the last few months, (i.e. new columns with values and hidden columns). This appears to have happened automatically since i haven't used it in several days.

    Old Sheet name: Form Responses 1

    New Sheet Name: Submissions 

    Submissions name hidden responses
  • Profile Image

    Answered by dtplisney on March 19, 2015 at 06:25 AM

    Furthermore, when I view the the 'revision history' from 9.24am today, every record is shaded pink. This is strange since only 10 submissions have been made since last week. 

  • Profile Image
    JotForm Support

    Answered by Charlie on March 19, 2015 at 10:40 AM

    Hi,

    Apologies for the inconvenience. If you have updated your form or changed anything on it, it is highly probably that this is the cause of resetting the default formatting in your Google Spreadsheet, this is to make sure that everything is linked properly. I will escalate a ticket about the issue you have described, but I do not know when or if it can be fixed.

    You could also try another integration method: JotForm -> Zapier -> Google Spreadsheet. It should not change your custom Google Spreadsheet formatting.

    You can check it here: Add JotForm Submission to Google Docs Row. We will let you know if we have any updates.

    Regarding the revision history, I'm not sure if I understand you correctly, are you referring to the changes you made in your Form or is it something still related to Google Spreadsheet?

    Kind regards.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on March 24, 2015 at 06:45 PM

    Hello,

    An improvement has been made very recently on Spreadsheet integration as required by Google and this had some residual effects. Those issues have also been fixed. Could you please let us know if the problem continues after re-integration?

    Kind regards

  • Profile Image

    Answered by dtplisney on March 25, 2015 at 05:39 AM

    As far as I can see the re-integration pulls the data that was contained in the original Jotform submission, it makes no provision to data that may have been added or edited to the Google Sheet. I had additional information added to the original spreadsheet, when the re-integration was performed I lost all of it. I wasted hours manually inputting the information all over again. How can this be prevented in the future. My confidence has been shattered with this jot form and Google Sheets integration...

    Thanks

  • Profile Image
    JotForm Support

    Answered by alp_deniz on March 25, 2015 at 05:47 AM

    Hello,

    My humble apologies for all this inconvenience.

    As you pointed out, this has been one of the most important issues and we have started implementing a better solution to Spreadsheets modifications.

    I will update this thread when it goes live.

    Thank you for feedback. It is very much appreciated.

    Kind regards

  • Profile Image

    Answered by dtplisney on March 30, 2015 at 06:28 AM

    G

    oogle Spreadsheet is not accepting su
    bmissions from my form. Any solution without damaging or loosing the information contained in my google spreadsheet?

  • Profile Image
    JotForm Support

    Answered by Welvin on March 30, 2015 at 10:40 AM

    Hi,

    I'm sorry to hear that. Will be checking your problem to this thread: http://www.jotform.com/answers/543042.

    Thank you!