Copy and Paste in GOOGLE SCRIPT

*I want to check the columns "D" and "E" on "Sheet1". *IF: => the values of column "D" and "E" are empty and not empty => I want to copy the row from A:I from Sheet1 to the next row of last row in "Sheet2"; *If there's no condition met => DO NOTHING

The code you provided is good but got an error when no condition met.

I want to achieve this using Google Apps Script.

SAMPLE1_UPDATED SAMPLE2_UPDATED

https://stackoverflow.com/questions/66460884/copy-and-paste-in-google-script March 04, 2021 at 12:15AM