I have this function that automatically assigns the time when cells are being filled up in certain rows. It works fine in the datasheet, but in the web app that I created for this sheet, VERY wrong dates are being…
I am new to coding, to js and GAS particularly. I am writing a script to find the day that has the most events in a calendar and I have encountered a problem when i can't access certain properties in…
I'm hesitant to post this here as it seems like it should be an easy error to solve, but every option that I've tried doesn't result in the error resolving. I'm working on a application in Google Sheets where people…
I'm trying to get table from this site using Cheerio lib in google app script. I'm put some code below this answer, but getting only [] in console.log() There is my code function test2() { const url = 'https://github.com/labnol/apps-script-starter/blob/master/scopes.md'; const…
I've tried to create a simple counter with increase in decrease buttons, but I cannot go any further. The code I've been stuck with is: for code.gs let count = 0; const counter = document.getElementById("count"); function onDec() { count =…
Please help me with the script I want to run when I check a specific checkbox in Google Sheets. It works for me when I put it with a button but it doesn't work on tablets so I want to…
I routinely have to verify links in Google Docs. This involves making sure the links are active, fact checking, ensuring the text of the link matches the title of the linked page, etc. I'd like to write a script to…
I am trying to merge two arrays on columns with similar data I can get this to work if both arrays have the same length dimension, but how can I generalize my function to work if arrays have different lengths?…
I have put a form in a Google Sheets sidebar with HTML. The form loads quickly when I select the form from my custom menu. This form is used once at the beginning of the day by one user. However,…
Is there any way to apply this function to a sheet named "Production Log"? function CopyDatatoLog() { var spreadsheet = SpreadsheetApp.getActive().getSheetByName('Production Log'); spreadsheet.getRange('B8:B11').activate(); spreadsheet.getActiveSheet().insertRowsBefore(spreadsheet.getActiveRange().getRow(), 4); spreadsheet.getActiveRange().offset(0, 0, 4, spreadsheet.getActiveRange().getNumColumns()).activate(); spreadsheet.getRange('A8:BL11').activate(); spreadsheet.getRange('4:7').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false); }; I keep getting this error "TypeError:…