function chk(){ //PDD data setting var today=new Date(); var Date = Utilities.formatDate(new Date(today.getFullYear(),today.getMonth(),today.getDate()), S
I have this 2D array and I'm trying to filter it, but it's coming out unfiltered: Data: [ ["Val #","Val #","Val #","Val #","Val #"], ["SO-000379-001A-047-1","
I have a script that imports data from a google sheet. Before importing the data into the new sheet I would like to filter it. In Column2 are our Cost centers l
I wrote a function to insert a message in a youtube live chat using Youtube service in google app script. However the function throws an error GoogleJsonRespons
The SEC Edgar website requires only 1 item in the header...but I can't get it to work in Script...What am I doing wrong? Script: const options = { 'method' : 'g
I have the following function: function processMegaventorySalesOrder(salesOrder) { let endUser = salesOrder["SalesOrderContactPerson"] let clientName = sale
If column C has the word "Matured", and D has a valid date, then formula in column E should automatically generate a serial no., one higher than the previously
Is it possible to use Supabase with Google Apps Script (GAS)? I'm new to Supabase and I've never tried to import external library to GAS before. I'm planning to
I am trying to pull data from an API from https://app.scrapingant.com/ using Google Apps Script. The documentation is here: https://docs.scrapingant.com/request
I'm new to using apps script and I'm just trying this out. I want to convert zeros to blanks. This is the code I've managed to create, but it doesn't work and I
sure I had this down but just can't get it right. Had a script set up to get data from one sheet and put it into another one, which I have done but it leaves ga
When clicking "button1" I would like the code to check the First Cell (Column A) of Rows 38-58 and hide the Row if the corresponding cell is empty and show if i
Good evening everyone, forgive the trouble, I tried to do a "search" on the site but I could not find the answer to my problem so I thought of opening a new dis
I got responses from Google form into Google Spreadsheet. I want to filter out the "Weekend" and "Workday". For the "Weekend" days, I only want to select the co
Currently with my 3rd party video conferencing plugin, When user clicks on Google calendar there is popup for scheduling event and in that they can select custo
Please Help, how to convert comment's value to cell's value using google script? This is the comment, and i want to getValue that comment, and setValue to each
function setWebhook() { var url = telegramUrl + "/setWebhook?url=" + webAppUrl; var response = UrlFetchApp.fetch(url); var obj = JSON.parse(response) Lo
I have a Spreadsheet with about 3000 rows which are grouped by order number. I'm trying to build an macro to: remove all groups multisort all rows recreate gr
I want to retrieve the name of a cell having his range. this is the range : var rangeOfCell = sheet.getRange(100,5); I want to know how to get his native(A1, A
Simple contact web form. I cannot figure out why it does not work as intended. On open sets up a menu, allows me to select a modal, non-modal or sidebar for for