Created
April 24, 2025 09:17
-
-
Save oimtrust/16c2134f3ce6b9fec8e9f324e2821112 to your computer and use it in GitHub Desktop.
For Creating auto number on spreadsheet.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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