I have Google form feeding into a sheet. When a row is updated there is a Name column and ID column. If the ID column does not match the Name column for the specific row based on the table on a separate sheet, I am looking for this to automatically delete the row in the feed sheet (Sheet1). Attached is the idea. I hope this makes sense! Thanks in advance.

Google Sheet


1 Answer 1


So if the name matches but the ID is different, delete ?

Then something like this will work I think.

  for(j = 1; j < sheet2.length; j++) {
    if((form(name) == sheet2(j)(name) && form(ID) == sheet2(j)(ID)) {
      post the entry

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.