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.


  • Profile Image

    Deleted Data reappears and 2nd tab deletes when new form submission received

    Asked 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.

    Page URL:
    http://itu.edu/index.php/student-enrollment-form/

    new form and
  • Profile Image
    JotForm Support Manager

    Answered by Jeanette 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

  • Profile Image

    Answered by ITU_contacts on March 25, 2014 at 05:28 PM
    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?

     

    A new response has been received:

    JotForm
    Answered by EltonCris

    Hi there!

    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!

  • Profile Image
    JotForm Support

    Answered by TitusN on March 25, 2014 at 07:55 PM

    Hello,

    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.

  • Profile Image

    Answered by ITU_contacts on March 26, 2014 at 05:40 PM
    Hi,
    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
    submission.
    Thanks
    ...
  • Profile Image
    JotForm Support

    Answered by TitusN on March 26, 2014 at 07:17 PM

    Hello,

    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.

  • Profile Image

    Answered by Spacecar 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?

  • Profile Image
    JotForm Support

    Answered by ashwin_d on July 02, 2014 at 02:11 PM

    Hello Spacecar,

    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.

    Thank you!

  • Profile Image

    Answered by madelinegood on June 21, 2016 at 09:34 AM

    I am having the same issue - I made a new tab to summarize the data from the integrated tab, and it stays there for a while, and then will randomly disappear, erasing all of my work.  Please advise!
  • Profile Image
    JotForm Support

    Answered by ashwin_d on June 21, 2016 at 10:16 AM

    Hello madelinegood,

    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 

    Thank you!