I'm using ImportJSON script that is well know to run an API and retrieve data. This works fine, I've used it many times before. However this particular API I'm running returns data that has different size rows, so I get…
We had multiple scripts for one sheet and seemed to operate independently but once combined to one script, it seems not to work. It executes but no activity on sheet. Trying to get these on one script so we can…
I have a Google spreadsheet that is used concurrently by a team of people located in the Philippines, South America and the U.S. The load on the spreadsheet is usually no more than ten people at a time. The spreadsheet…
I was given a custom function to add to the spreadsheet I’m building but it doesn’t quite do what I now need it to do. I have a basic understanding of JavaScript but since I didn’t write this code, I’m…
Im new to Apps Script and need some assistance with the code required to get a list of all sheet names (current and those to be created) that will start with "Week of" in the title. Ideally this would update…
i'm trying to create a form for 502 users to submit tickets on google forms to show the id of the ticket to the user as a confirmation message and to the team who is going to solve it the…
I'm trying to create a simple lookup form using Google Apps Script. The form uses data sourced from a spreadsheet to populate a number of autocomplete input fields. I can't figure out why the autocomplete is not working. In supplierIDLookupFormHTML.html…
function countColoredCells(countRange, colorRef) { var activeRange = SpreadsheetApp.getActiveRange(); var activeSheet = SpreadsheetApp.getActiveSheet(); var activeformula = activeRange.getformula(); var countRangeAddress = activeformula.match(/((.*),/).pop().trim(); var backGrounds = activeSheet.getRange(countRangeAddress).getBackgrounds(); var colorRefAddress = activeformula.match(/,(.*))/).pop().trim(); var BackGround = activeSheet.getRange(colorRefAddress).getBackground(); var countColorCells = 0; for (var i =…
I have an Apps Script that updates columns in a Google Sheet. It is only updating unprotected columns. At the end I do a sort on all columns (including some protected columns). Those without permissions get an error from google…
I do script in google sheets, then set trigger. On my test table it works clearly, but on other table it get error. function onEdit(e) { var discordUrl = "MYWEBHOOK_URL"; const range = e.range; const sheet = range.getSheet(); var sheetName…