Skip to content

Instantly share code, notes, and snippets.

@morad7

morad7/auto-increment-google-sheet.txt

Created April 7, 2016 09:38
Show Gist options
  • Save morad7/2ea664c24b54dc90e0800f633e2190c6 to your computer and use it in GitHub Desktop.
Save morad7/2ea664c24b54dc90e0800f633e2190c6 to your computer and use it in GitHub Desktop.
Download ZIP
Googe Auto-increment number script
Raw
auto-increment-google-sheet.txt
function onFormSubmit(e) {
var sheet = SpreadsheetApp.getActiveSheet();
var row = SpreadsheetApp.getActiveSheet().getLastRow();
sheet.getRange(row,18).setValue(row);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment