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 encountered this weird bug while working on an internal library for my work. We use App Script which is based on Javascript. However, there is a weird quirk with the string.replace() function that is causing problems. Managers often include…
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 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 function that asks users to select a name from a dropdown list. When I click the submit button, the form closes, writes the name to the selected cell, but then immediately reopens. What am I doing wrong? function…
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…