How to use Form Submit using App script

Try to use this approach with conditional statements and on form submit using Apps Script.

you will adjust your range depending on your data set.

Script used

function onFormSubmit(e) {

  var subValues = e.values;
  var colB = subValues[1];
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var row = e.range.getRow();
  var i = colB.toLowerCase();
  
  if (i === "light gray" || i === "gray hair"){
    sheet.getRange(row, 3).setValue("NO");
  }else{
    sheet.getRange(row, 3).setValue("OK");
  }
  
}

Sample Output

Form

Spreadsheet

Add triggers

Reference

• Triggers
• Conditional Statement