Skip to content

Instantly share code, notes, and snippets.

@Justintime50
Created March 1, 2024 00:11
Show Gist options
  • Save Justintime50/24d0659a57ef26d1e54666b4b2f160c8 to your computer and use it in GitHub Desktop.
Save Justintime50/24d0659a57ef26d1e54666b4b2f160c8 to your computer and use it in GitHub Desktop.
Reset a Google Form's Sheet and Responses
function resetForm() {
deleteAllFormResponses()
resetFormResponseDestination()
}
function resetFormResponseDestination() {
var form = FormApp.getActiveForm();
var formResponsesSheetId = form.getDestinationId();
var spreadsheet = SpreadsheetApp.openById(formResponsesSheetId);
var newSheetId = spreadsheet.getId();
form.setDestination(FormApp.DestinationType.SPREADSHEET, newSheetId);
var sheet = spreadsheet.getSheets().pop();
if (sheet) {
spreadsheet.deleteSheet(sheet);
}
}
function deleteAllFormResponses() {
var form = FormApp.getActiveForm();
var formResponses = form.getResponses();
formResponses.forEach(function(response) {
form.deleteResponse(response.getId());
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment