Clear data on integrated Google Spreadsheet when data is copied to another database

  • tkrpata
    Asked on May 9, 2018 at 2:56 PM

    Okay, I want to be able to take the data that has accumulated in my spreadsheet and then transfer it to my database and have a new spreadsheet begin, is there any way of doing that, otherwise everytime I append to the database I add duplicates. Thanks for your help

  • Mike_G JotForm Support
    Replied on May 9, 2018 at 4:30 PM

    To my understanding, you would like the data in the integrated (Google) spreadsheet moved to a new spreadsheet in your database? And by that, the original (Google) spreadsheet would be empty every time you append to avoid duplicates, is that correct?

    I'm afraid we do not have a way of doing that within the builder page of the form. You might be able to probably do that outside JotForm, but I'm not that sure. I just found this thread in Google Docs Help Forum — https://productforums.google.com/forum/#!topic/docs/UUs9AY3bvXE

    You can hire a developer that would create a script to delete the data in the original Google Spreadsheet when you append the data to your database.