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.
Deleted Data reappears and 2nd tab deletes when new form submission receivedAsked by ITU_contacts 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.
new form and
JotForm Support Manager
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
Hi,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!
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.
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
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.
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?
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.
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