Click on section to reveal Google Apps Script Code
function clearInvoice() {
const sheet = SpreadsheetApp.getActiveSheet();
const invoiceDate = sheet.getRange("H2").clearContent(); //Update cell/range as needed
const invoiceNumber = sheet.getRange("H4").clearContent(); //Update cell/range as needed
const invoiceDueDate = sheet.getRange("H6").clearContent(); //Update cell/range as needed
const invoiceProjectDetails = sheet.getRange("B16").clearContent(); //Update cell/range as needed
const invoiceBillTo = sheet.getRange("B9:B13").clearContent(); //Update cell/range as needed
const invoiceItemRange = sheet.getRange("B19:G27").clearContent(); //Update cell/range as needed
const invoiceRemarks = sheet.getRange("B29:B30").clearContent(); //Update cell/range as needed
}
function insertDefault() {
const sheet = SpreadsheetApp.getActiveSheet();
const invoiceDate = sheet.getRange("H2").setValue('January 1, 2025'); //Update cell and value as needed
const invoiceNumber = sheet.getRange("H4").setValue('1000'); //Update cell and value as needed
const invoiceDueDate = sheet.getRange("H6").setValue('February 1, 2025'); //Update cell and value as needed
const invoiceProjectDetails = sheet.getRange("B16").setValue('Type Project Description Here'); //Update cell and value as needed
const invoiceBillTo1 = sheet.getRange("B9").setValue('CLIENT COMPANY NAME'); //Update cell and value as needed
const invoiceBillTo2 = sheet.getRange("B10").setValue('CLIENT COMPANY ADDRESS'); //Update cell and value as needed
const invoiceBillTo3 = sheet.getRange("B11").setValue('ADDRESS LINE 2'); //Update cell and value as needed
const invoiceBillTo4 = sheet.getRange("B12").setValue('CITY, STATE, ZIP CODE'); //Update cell and value as needed
const invoiceItemDate = sheet.getRange("B19").setValue('12/15/24'); //Update cell and value as needed
const invoiceItemDescription = sheet.getRange("C19").setValue('Enter description here'); //Update cell and value as needed
const invoiceItemHours = sheet.getRange("F19").setValue('2'); //Update cell and value as needed
const invoiceItemRate = sheet.getRange("G19").setValue('$100'); //Update cell and value as needed
const invoiceRemarks = sheet.getRange("B29").setValue('Enter details here'); //Update cell and value as needed
}