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:…
I have an onEdit trigger set up for this script: function ifBold() { var cell = SpreadsheetApp.getActiveSpreadsheet().getRange("'Prospect List'!A:A"); if(cell.getFontWeight() == 'bold') return true; else return false; } I have one sheet that I enter data into and it creates a…
I have multiple sheets all with names "Pipeline History mm-dd-yyyy" with different dates. I want to search the names of the sheets for the most recent date. And then hide that sheet. I have started writing some code, but I…