This question already has answers here: onEdit() doesn’t catch all changes (1 answer) Failure of calling Google App Script onEdit function many times in a second (1 answer) Closed 4 days ago. I have this code to protect rows of my sheet based on a tickmark in Col21. But the code takes 1 to 3 […]

I have a Google sheet where I have set a row to become protected when I check a tickbox in Col U. But when I perform this action with the account I setup the code with, it makes two entries of protect ranges.

Closed 2 days ago.

Submitting a Google module linked to a Google sheet, the module answers are inserted into the right fields of the linked table in the Google Sheet, even if you change the table columns headers and the columns position. Is there a way to obtain the same result, using a custom module in an html file and Apps Script? You could write the initial header names into a hidden row, but it does not seem the best solution.

I’m back here. I need your help.

I’m back here. I need your help.

I’m back here. I need your help.

I’m back here. I need your help.

I’m back here. I need your help.

I have sheet1 with 17 columns of data. Order number in in Column H, date & time is in Column L. Sheet2 has 12 columns of data imported with importrange. Order Number is in Col K, Date & Time in in Col I (shown in script as Col L but would like to move it to Col I)