I'm trying to have it that every time I submit a form, it adds automatically some data. This is the script I have:
function onFormSubmit(Test) {
var sheet = SpreadsheetApp.getActiveSheet();
var row = SpreadsheetApp.getActiveSheet().getLastRow();
sheet.getRange(row,3).setValue(1);
}
Basically, I want to submit the script and the third row will automatically show 1 for every line. The end goal is the add a function in place of 1. So let say the form is a number, I want the ability to add a function to add 4 to that and display the results.