When editor/collaborator deletes a Google form response--some notification?

Question

If a response is deleted manually in a Google form, is any flag/notice available to apps-script so that appropriate actions can be scripted for dealing with the corresponding row in the linked sheet? This is desired so that the sheet can be kept in synch with the form responses, or the form response can be re-submitted programmatically from the sheet row, if the response was improperly deleted.

Thanks!

Answer 1

There is no delete response event trigger available for both Google Sheets events and Google Forms events.

One workaround that you may do is to create an onOpen() installable trigger in your linked Google Sheets using Apps Script that will check if the Google Forms responses count using Form.getResponses() matches the available responses in your sheet whenever you open the linked Google Sheets.

Sample Apps Script:

function onOpen(e) {
  var form = FormApp.openById('Forms file id here');
  var formResponses = form.getResponses();
  
  var responseSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Form Responses 1');
  
  //Get number of responses saved in the sheet (Subtract 1 for the header row);
  var sheetResponses = responseSheet.getLastRow() - 1;
  
  Logger.log(formResponses.length);
  Logger.log(sheetResponses);
  
  if (formResponses.length != sheetResponses){
    
    var ui = SpreadsheetApp.getUi(); 

    var result = ui.alert(
      'Warning',
      'Responses did not match.',
      ui.ButtonSet.OK);

    // Sync responses here
  }

}

Sample Forms Responses:

Sample Output: (when you open your linked Google Sheets)