One-Click Email Survey: Post.gs

Post.gs

function doPost(e) {
  var properties = PropertiesService.getScriptProperties();
  
  var handshakeKey = properties.getProperty("handshakeKey");
    
  if (e.parameter.HandshakeKey != handshakeKey) {
    ContentService.createTextOutput("Error: Incorrect handshake key")
  }
  
  var spreadsheetId = properties.getProperty("spreadsheetId");
  var userKey = e.parameter.Field1;
  
  if (e.parameter.surveyPage == "1") {
    var form2SheetName = properties.getProperty("form2SheetName");
    var responses = SpreadsheetApp.openById(spreadsheetId).getSheetByName(form2SheetName);
  
    var education = e.parameter.Field3;
    var income = e.parameter.Field4;
  
    responses.appendRow([userKey, education, income]);
  }
  else if (e.parameter.surveyPage == "2") {
    var form3SheetName = properties.getProperty("form3SheetName");
    var responses = SpreadsheetApp.openById(spreadsheetId).getSheetByName(form3SheetName);
  
    var creditDebt = e.parameter.Field5;
    var changingBank = e.parameter.Field6;
    var technologyAdopter = e.parameter.Field7;
    var source = e.parameter.Field21;
    var thoughts = e.parameter.Field12;
    
    responses.appendRow([userKey, creditDebt, changingBank, technologyAdopter, source, thoughts]);
  }
}