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

  • Profile Image
    Asked 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?


  • Profile Image
    Answered 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 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
    Answered 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.