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…
I have a Google Sheet and I'm trying to output a date or string depending on three dates and three booleans which represent a task as complete. I've been writing a custom function to do this but I can't get…
I'm trying to set up this in Google Sheets, where there's info being added to a spreadsheet and a pdf is created from a template. I copied this code from a YT video: function createBulkPDFs(){ const docFile = DriveApp.getFileById("ID"); const…