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…
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…
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…
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 /…
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:…
shThe problem is when changing the text size of the dialog box, it does not change, but if it is outside the dialog box, the text size changes without problems, which I only want when the user selects on the…
I'm progressively working through learning enough of HTML and javascript to apply to a google sheets package I'm developing for personal use. I developed a script from assistance on a previous post I made but am having some issues. Essentially…
I have a spreadsheet which values comes from an importRange built-in function, the thing is that the getRange function is not fetching the right values, regardless the ROW, COLUMN selected, it returns the word "info" all the time except for…
I am trying to create a sheet for my friend and me about some items selling, cost, and state (Sold, in the sale, etc) and I want to automate my "state" column, which contains dropdown menus with "Sold !", "waiting…