- ITU_contactsAsked on March 25, 2014 at 02:25 PM
Every time a new form submission is received, the 2nd tab we created in the Google Spreadsheet disappears and the test data we deleted out of the Google Spreadsheet reappears. Please advise. Thank you and have a nice day.
- JotForm Support ManagerJeanetteAnswered on March 25, 2014 at 04:55 PM
Looks like the integration will always create a new spreadsheet with current data stored in your account. As far as I know adding a tab will brake the integration
On regards to the test data, you must delete it from the submissions view to prevent this to be added
- ITU_contactsAnswered on March 25, 2014 at 05:28 PMHi,Another support rep in another thread told us to add a 2nd tab instead of adding columns to the spreadsheet. Below is the response. We want to be able to keep track of our submissions and make a note if we have contacted them. Is there another way we should be doing this if what you say about the form being regenerated each time? What do you advise?Answered by EltonCris
I would suggest not to do it on the same sheet where the submissions goes to avoid breaking the integration. The best way to make that possible is to create a separate sheet on the same spreadsheet and create the columns there. If you're going to create calculations or if you want to populate data to the new sheet you can use formula with the sheet name e.g. Submisions!A1:A5
Hope this helps!
- JotForm SupportTitusNAnswered on March 25, 2014 at 07:55 PM
That is certainly a limitation.
I'm thinking of a workaround -It will require thorough testing before I present it..
But first - how do you indicate that the form respondent has been contacted? Do you have a field with yes/no values? Or do you just indicate "contacted"?
Let us know.
- ITU_contactsAnswered on March 26, 2014 at 05:40 PMHi,
As suggested above, we created a new tab and used the formula to populate
the data into the new tab. We then titled a new column at the end that we
literally typed in "yes" when we contacted the person who made the
- JotForm SupportTitusNAnswered on March 26, 2014 at 07:17 PM
Its strange that the extra sheet you added gets deleted - all our tests proved that it does not. You probably need to re-integrate your spreadsheet and see if the workaround provided helps.
Alternatively - based on your recent update:
Try the following the following:
1. Add a text field at the top of the form
2. Name the field "Contacted?" or a labels that reflects the purpose of the column
3. Hide the field as shown:
4. Reintegrate with Google Spreadsheet to apply the new column
It will always be blank - allowing you to add in whether the student has been contacted or not.
You may have to test this first with a copy of your form before you take it live.
Let us know.
- SpacecarAnswered on July 02, 2014 at 12:00 PM
I'm also having this issue. I created a new tab (sheet) in my integrated worksheet that would pull data from the submissions received, and that separate tab keeps getting deleted. Help?
- JotForm Supportashwin_dAnswered on July 02, 2014 at 02:11 PM
I just did a quick test but I am unable to replicate the issue you are having. I created a demo form and integrated it with google spreadsheet. In the integrated google spreadsheet I added a new sheet and renamed it to "Ashwin".
I tested my form by sending multiple submission but the additional sheet does not gets deleted.
Please check the following demo form: http://form.jotformpro.com/form/41825220142947?
Here is the integrated google spreadsheet: https://docs.google.com/spreadsheets/d/1mGgbRU_LiE3ayDuGH3yqdQuekLJF2oD8VB5GfQuBQpU/edit?usp=sharing
I would suggest you to please re-integrate your form with google spreadsheet and see if that helps you.
Do get back to us if the issue persists.
- JotForm Supportashwin_dAnswered on June 21, 2016 at 10:16 AM
This is a very old thread and I have moved your question to a new thread so that we can address this separately: https://www.jotform.com/answers/865537