Copy Last Row Onformsubmit If The Value On Column 2 Matches The Value

I am trying to find a way of copying the last row of a form submission to another sheet within the spreadsheet I am working with. All of this would be based on the Value in column

Solution 1:

How about this?

function copyLastRow(event) 
{  
   var target = SpreadsheetApp.openById('1ulIvWOQIH9MRg9RSW6Xg5iHRikOBFJ0L9XQ46Y_r_6I').getSheetByName('Sheet8');
   if(event.values[1]=='Yes')
   { 
      target.appendRow(event.values);
   }
}