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

  • Profile Image
    tkrpata
    Asked on May 09, 2018 at 02: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

  • Profile Image
    Mike_G
    Answered on May 09, 2018 at 04: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.