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…
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 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…
I am writing an App Scripts code to write events from my spreadsheet into my Google Calendar, but I want to save the Event ID on the right of the range. I can get the event id no problem, but…
How to get the whole range of the onEdit(e) by Google Sheets script? I have tried the following script: var sheet = spreadsheet.getActiveSheet(); function onEdit(e){ var row = e.range.getRow(); var column = e.range.getColumn(); sheet.getRange('A1').setNote(range.getRow() + ',' + range.getColumn()); } Well,…
I'm trying to fetch JSON data from my API to import to Google Sheets using Google Apps Script. Everything is working as expected, except for when I'm trying to map the object, the result array returns undefined objects. Here's my…
I used this code to parse my webrequest response: for (var [key,val] of Object.entries(jsonObj)) { console.log("Key="+key); console.log("Value="+val); } Its working for one of my url but for another one I get: {members=[Ljava.lang.Object;@3e0dc74, list_id=xxxxx, total_items=2.0, _links=[Ljava.lang.Object;@610c2a56} The response is ok but…