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

    Why doesn't Google sheet integration allow additional tabs to the form response doc?

    Asked by jacki72 on August 31, 2016 at 02:32 PM

    We have a form that's integrated with a google sheet. We added additional tabs to the integrated google sheet  where the form responses appear that included some formulas and other things. When a person submits a new response  through the form, those tabs disappear. Is there a work around for this?

     

    Page URL:
    https://www.jotform.com//?formID=61927143925157

    doc sheet form response additional
  • Profile Image
    JotForm Support

    Answered by Nik_C on August 31, 2016 at 04:43 PM

    If I understood your problem right, you have a form that is integrated with Google spreadsheet and one additional field that is added in Spreadsheet. So, when the form is submitted your additional field is deleted.

    I created a similar environment and tested, but I didn't experience that issue, my column stayed in Spreadsheet even after submission.

    Could you please clarify if values in that column are deleted or the whole column, since I'm unable to replicate this issue, so we can investigate this further?

    Thank you!

  • Profile Image

    Answered by jacki72 on September 09, 2016 at 10:52 AM

    No, the issue is when we add additional tabs to the google doc that this form is integrated with, when someone submits a new form response the new tabs disappear. We're trying to compile a report from the form responses that sums the numbers on a daily basis. We added additional tabs to the google sheet with formulas to accomplish this. However, the new tabs/sheets disappear when new responses are submitted.

  • Profile Image
    JotForm Support

    Answered by BJoanna on September 09, 2016 at 12:41 PM

    I was not able to replicate mentioned issue. I have created new form and I have integrated my form with google spreadsheet. I have submitted my form. My submission is shown inside of spreadsheet. After that I have created new tab inside of my spreadsheet and I made new submission. New tab and data that I have manually added inside of that tab were not deleted. 

    Can you please try to reintegrate your form with google spreadsheet, then create new tab and see if the issue still persist. 

    Possible workaround is to add additional text box inside of your form, you can name it spreadsheet. Then hide that field so it is not visible to your users. 

    This field will always be blank when new submission is received and you will be able to add your text inside of that column in your spreadsheet.

    Hope this will help. Let us know if you need further assistance.