JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
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?
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?
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.
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.