Google form responses - send responses from specific clients to specific sheets

Hi @Stefanie 

Here is a starter if you go into the document App Script writer you need to write a script that says if a cell is x then copy to my second sheet:

// Open the two sheets to interact and set the data range

var ss = SpreadsheetApp.openByUrl(sheetURL).getSheetByName("YourSheetName");

var ssnew = SpreadsheetApp.openByUrl(sheetURL).getSheetByName("YourSecondSheetName");

var data = ss.getDataRange().getValues();

 // Now work through sheet looking for matches, the line below will look through each row of the first column 
 // until it finds a blank row, the datarange was set above to the variable data

 // the row and column is labelled as data[row,column]  - column [0] is column 1 or A on your sheet

  for (var i = 1; i < data.length;i++) {

    if(data[i][0] == ""){ break;}

    var n = data[i][3]; // Select the column that needs to be looked at in script [3] means column 4 or D

    // below you need to say what you are looking for  between the ‘’ in this case I am saying if this cell is blank

    if(n==''){

   // then decide what to do  - below I am looking up something from the same row from column 10 or J 

    var fileName = data[i][9];

  // now add that filename to a new cell on my second sheet

    ssnew.getRange(row,column).setValue(fileName) 

    }

  }

If you need some specific work done then DM me please but hopefully that helps a bit.