How to add auto increment to a form based on google docs spreadsheet
1. Create a google doc spreadsheet.
2. Go to Tools–>Script Editor, add these code
This script will auto increment column 2
function onFormSubmit(e) {
var sheet = SpreadsheetApp.getActiveSheet();
var row = SpreadsheetApp.getActiveSheet().getLastRow();
sheet.getRange(row,2).setValue(row);
}
If you want to increment different column, change the number e.g, column 4
sheet.getRange(row,4).setValue(row);
3. Save the script, go to Triggers menu, select Current script's triggers
Create a trigger,
Run Event
onFormSubmit From spreatsheet On form submit
then save, close the script editing window.
