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

    Google sheets integration - deleting submissions

    Asked by c2forms on October 31, 2015 at 04:01 PM

    I want to verify a concern about the google sheets integration. To be sure. I can delete submissions from the google sheet as long as i do not delete columns or change the formatting and the integration will be ok? This will help tremendously as I will only have to delete in one place and jotform will have all my submissions for archive. How many submissions can jotform hold?

     

    Thanks!

    Page URL:
    http://www.jotform.com//?formID=50574624554963

    Submissions Deleting submissions spreadsheet google spreadsheet
  • Profile Image
    JotForm Support

    Answered by jonathan on October 31, 2015 at 05:57 PM

    Hi,

    We always recommend to NOT directly apply modification/change on the Submission sheet of the form Google spreadsheet integration.

    The integration is very sensitive and fragile, that even the slightest change on the sheet can have possibility of breaking the integration. Thus, it will stop the submission to the spreadsheet.

    What we suggest is to instead use a copied version of the Submission sheet.

    You can just copy the Submission sheet in Google spreadsheet and then safely delete rows/submission in the copy version. This will ensure that the sheet used in integration will not have any changes detected by the integration.

     

    How many submissions can jotform hold?

    You can check the limits for the different subscription packages in the JotForm pricing page.

    Hope this help. Let us know if you need further assistance.

  • Profile Image

    Answered by c2forms on November 01, 2015 at 05:59 PM

    The problem is it is showing active inventory. If I copy then i will always have to delete old data. I have a second sheet pulling in data using importrange function that I can format but not delete. As soon as I delete anything in the imported sheet it pops right back up because it is being pulled from the integrated sheet. I display the formatted sheet on a website to show active inventory. When i sell it I need to delete it. What would you recommend? Deleting it from the integrated sheet would be easiest. It seems like a real pain. I don't want to break the integration but I also don't want to have to delete in multiple places.

  • Profile Image
    JotForm Support

    Answered by jonathan on November 01, 2015 at 07:55 PM

    ...As soon as I delete anything in the imported sheet it pops right back up because it is being pulled from the integrated sheet.

    I understand what you meant.

    So it seems your copy process was by using the automated import range function of the Google spreadsheet. You may not do this process anymore.

    I have seek assistance from our developer who was handing the Google Spreadsheet integration. And I got confirmation from him that it is actually now safe to delete rows directly on the Spreadsheet. 

    So contrary to my previous pre-caution advise, the complication is not that lethal as you can still re-integrate anyway and data will be recovered if anything happens.

    You can further test also using my test Spreadsheet

    https://docs.google.com/spreadsheets/d/1DvQIvUv-ErU-toL1pVLUQ0RBD7S3vUSA36wW-Jy2GsY/edit?usp=sharing

    Try deleting rows on the spreadsheet and then test submit the form also

    https://form.jotform.com/53048096900960?

    Check if there is anything broken on the spreadsheet after deleting rows. Or check if submission have stop coming after deleting row/s.

    Hope this help. Let us know if there is more we can assist you with.