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

  • jacki72
    Asked on August 31, 2016 at 2: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?

     

  • Nik_C
    Replied on August 31, 2016 at 4: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!

  • jacki72
    Replied on September 9, 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.

  • BJoanna
    Replied on September 9, 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. 

    Why doesnt Google sheet integration allow additional tabs to the form response doc? Image 1 Screenshot 20

    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.