Skip to content

Instantly share code, notes, and snippets.

@oimtrust
Created April 24, 2025 09:17
Show Gist options
  • Save oimtrust/16c2134f3ce6b9fec8e9f324e2821112 to your computer and use it in GitHub Desktop.
Save oimtrust/16c2134f3ce6b9fec8e9f324e2821112 to your computer and use it in GitHub Desktop.
For Creating auto number on spreadsheet.
function onFormSubmit(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var lastRow = sheet.getLastRow();
var serial = lastRow - 1;
var serialNumber = ('000' + serial).slice(-3);
var today = new Date();
var month = ('0' + (today.getMonth() + 1)).slice(-2);
var year = today.getFullYear();
var numberFormat = `${serialNumber}/QA/RPAY/${month}/${year}`;
sheet.getRange(lastRow, 1).setValue(numberFormat);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment