Auto delete old entries from Google Spreadsheet submitted using forms

Auto delete old entries from Google Spreadsheet submitted using forms

Following is a script that can be set (triggered) to auto deletes old entries every day from Google Spreadsheet submitted using forms:

Insert the following script in your spreadsheet project using script editor:


function DeleteOldEntries() {
  
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  //give your sheet name below instead of Sheet1
  var sheet = ss.getSheetByName("Foglio1");
  
  var datarange = sheet.getDataRange();
  var lastrow = datarange.getLastRow();


  var currentDate = new Date();
  var oneweekago = new Date();
  oneweekago.setDate(currentDate.getDate() - 7);
    
  for (i=lastrow;i>=2;i--) {
    var tempdate = sheet.getRange(i, 1).getValue();
    
    if(tempdate < oneweekago)
    {
      sheet.deleteRow(i);
    }
  }
}

The above script will delete rows (entries) that are one week old, you can change the duration in it as per your requirement.

If you are not familiar with writing scripts and don't know where to start from then have a look at the following link:

Here is post for how to work with scripting in google spreadsheets:

http://igoogledrive.blogspot.in/2012/08/how-to-write-script-in-google.html 

You have to add triggers so that it executes it daily (or weekly or as per your requirement)

Following link will make you understand how to set a trigger on an event:

http://igoogledrive.blogspot.in/2012/08/how-to-set-trigger-on-script-in-google.html

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

Kishan,

iGoogleDrive