google-apps-script Questions

Javascript – TypeError: Cannot read properties of null (reading 'getformula')

August 23, 2024
user25644059
2 Answers

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 =…

VIEW QUESTION

Html – Submit button closes the dialog but then it reopens

August 23, 2024
Tim Nayak
2 Answers

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…

VIEW QUESTION

Javascript – How to Ignore Permissions Error with Apps Script on Google Sheets

August 22, 2024
Stalwart385
2 Answers

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…

VIEW QUESTION

Javascript – Script in AppScripts in Google Sheets dont work (Discord embed + google sheet)

August 21, 2024
LeCras
2 Answers

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…

VIEW QUESTION

Javascript – For loop running only for first element – Google Sheets, Google Apps Script

August 19, 2024
Mahmoud
3 Answers

I'm using the below code to check if the input value match with any value of google sheet column. The logger returns an array of all phone numbers in the specified column, but the for loop works only for the…

VIEW QUESTION

Html – How to disable the button if textarea is empty in google appscript

August 19, 2024
Sunil Panda
2 Answers

I want to disable the submit button if the text area is empty. I have initialized the submit button to disable condition and written bellow codes. But after typing text inside text area, it not got enable condition. Below are…

VIEW QUESTION

how to fix google sheet webapp returning undefined value in html page?

August 16, 2024
fj_gie
2 Answers

I am making a web app using google sheets and google app script. My web app have an index page and an input page. There is no problem with inputting the data, however when i try to populate the data…

VIEW QUESTION

Javascript – How to limit Async uploads to x at a time?

August 16, 2024
Dan
2 Answers

I'm attempting to upload files through a web form to a Google Drive backend using the Resumable Uplaods feature. I'm starting with a script from https://github.com/tanaikech/AsynchronousResumableUploadForGoogleDrive/ I've spent much time on this without success. What I'd like to do is…

VIEW QUESTION

Javascript – Remove Duplicates from Very Large Array, Keeping Oldest Timestamp

August 14, 2024
DanCue
2 Answers

I have a large dataset (400K+ rows by 4 columns). I'm currently grabbing the data into an array using the following (thanks to tanaike): function getValues_({ spreadsheetId, sheetName, start = 1, maxRow, limit = 100000 }) { return [...Array(Math.ceil(maxRow /…

VIEW QUESTION

Javascript – Create a dynamic dictionary in apps script google sheet

August 8, 2024
bry888
3 Answers

I have a column with data in google sheets like this: col_name A A A B B C I want to store this data in a dictionary where column value is a key and number of occurrences is a value:…

VIEW QUESTION