The spreadsheet has some cells with cell contents that are separated by commas, or a new line. 123, 876, 456 Column "C" is the column that determines whet
Good Day! I would like the Purchase Order ID repeated upon submission of a form in an earlier sheet. My current code however repeats this throughout the length
I am trying to show an alert popup when cell selection is changed, using the new trigger onSelectionChange. For some reason it is not showing any alerts. Am i d
I cant move my other contacts to my system group contacts via GAS var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var group = Co
Looking for some help please, I've been tinkering with the code now most of the day and im stuck, and this seems about the best solution I have found so far. I'
When creating a spreadsheet ex novo, Google's SpreadsheetApp allows one to specify the number of rows and columns of said spreadsheet: var spreadsheet = Spread
so basically the task is quite simple, but I didn't find any workable solution for my problem. I have a huge upload script on my website (at the moment localhos
In Google Drive I am trying to compare an id in a file name against folders named with that id, and if they match, to move that file to that folder. Some of the
I have a Google Apps Script custom function, very simple: function sharesBurned(sharesToSell) { return "tree" } Obviously, this works when I test it in
I'm using Data Connector from Salesforce addon. To refresh my data in Google sheet, I usually either setup an automated refresh via the addon, or I click manua
I am attempting to run WebAssembly on the new V8 Google Apps Script runtime, and it appears to be supported, however it seems that async functions are terminate
I'm trying to create a class with some fields on Google Scripts. I can't even save the file. From what I understand of this SO answer, I'm using the correct s
Is it possible to call a Google Sheets add-on as if it were a function in an Apps Script? I am trying to automate a few steps like this: Import/append data fr
I want to write a custom script using Google Apps Script for Spreadsheet that gets data from WebSocket. Is there a way doing so?
I have a google spreadsheet with many tabs and I'm trying to create a dynamic Index tab. So far this is what I'm doing: function jumpToSheet() { var ss = S
I created a button and I have applied to this button a handler to collect the data of some fields and record them in a spreadsheet. I wish, however, at the end
I am attempting to sort the sheets within my spreadsheet in chronological order. They are all dates in the same format (MM-dd-yyyy), but I am unsure of how to t
I have scenario where I have more than 60 sheet, and all have appscript project behind them running and managing those sheet. I want to updat/control those apps
I work on a lot of google scripts that are tied to different people's google sheets. Recently I've been trying to shift to using Clasp and VS Code to make it ea
I'm trying to connect to Microsoft SQL Server using Google Apps Script. I'm using SQL Server 2008 R2 and I am using one of the suggested scripts that's supposed