Google Form using App Script

• Create a Google Sheet with the following headers: First Name, Last Name, DoB
• Create a Google Form with the exact headers as Google Sheet headers:  First Name, Last Name, DoB
• In Google Form, create an App Script Trigger as follows - this code will link the data in the Form to the created Google Sheet:

function onFormSubmit(event)

{

record_array = []

var form = FormApp.openById('Form Id in Edit Mode'); // Form ID

var formResponses = form.getResponses();

var formCount = formResponses.length;

// get the latest form response

var formResponse = formResponses[formCount - 1];

var itemResponses = formResponse.getItemResponses();

for (var j = 0; j < itemResponses.length; j++) {

var itemResponse = itemResponses[j];

var title = itemResponse.getItem().getTitle();

var answer = itemResponse.getResponse();

Logger.log(title);

Logger.log(answer);

record_array.push(answer);

}

AddRecord(record_array[0], record_array[1], record_array[2]);

}

function AddRecord(first_name, last_name, dob) {

var url = 'https://'; //URL OF GOOGLE SHEET;

var ss= SpreadsheetApp.openByUrl(url);

var dataSheet = ss.getSheetByName("Sheet1");

dataSheet.appendRow([first_name, last_name, dob, new Date()]);

}

 

Using JS in GoogleSheets

function func() 
{

    // sheet initial
    var app= SpreadsheetApp;
    var activeSheet = app.getActiveSpreadsheet().getActiveSheet();

    // get value
    var cell = activeSheet.getRange(row, col).getValue();

    // set value
    activeSheet.getRange(row, col).setValue(cell);

    // console log
    Logger.log (cell);
}