Category "google-apps-script"

running websocket in google sheet without using HTML code

I find this test for Binance websocket in app script the code in this URL: running websocket in google sheet I want to remove code HTML and run websocket withou

Can we edit title of windows alert box being used in Google Apps script?

Can we customize the title in alert box for a webapp created using google apps script ? function confirmReserve(text){ document.body.style.cursor = 'auto';

Two Way Sync of Specific Ranges Across Two Separate Files In Google Sheets via Apps Script [duplicate]

Apologies if this is a somewhat long post - I can further clarify anything here if needed. I basically have an Apps script question in regards

Can we update values in date picker field based on value in another date picker field in a Cardservice for Google Calendar Add-on?

I wish to populate the value of booking end date based on the value entered by user in the booking start date. Currently, I am using below codes - /*----------

Google sheets- script to copy and paste cell contents to cell using VLOOKUP type of action

I would like to create a script that I can assign to a button in Google Sheets that will copy and paste cell contents in a given column to a cell in that same c

Generate unique URL for sharing Google Forms?

I have a Google Form that contains a simple question that can be answered "Yes" or "No". The responses are being filled in a Google Sheet. How can i identify wh

Request for JavaScript works, but not for GoogleScreen. What's the difference?

Please, help. I can't find the error and I don't understand why the request is not working. It seems to me that it's just Google's IP blocked by the site I'm ma

How do I show Popup Message everytime I go to another Sheet using Google Sheet/Apps Script? [duplicate]

I have 3 sheets in a workbook - Sheet1, Sheet2, and Sheet3, every time I change to a Sheet there is a Popup message that will show up. What I

How to uppercase a cell range even if user type or paste lowercase with no warning in Google Sheet

I've made a simple table in a one of many sheets in a google sheet file and I would like a cell range of a sheet to alway appear upper case no mater what user i

Adding excel formula to appendRow

I am new to Apps Script, but I have a code that fills form data in to a spreadsheet. It's working fine, but I want to make a hyperlink using the coordinates fil

Apps Script to copy data up to last cell containing data in a single column

I am trying to copy the content of a single column and send this range of data in an email. My users submit a for. Their email address are added in column C. I

Old spreadsheets have wrong time and timezone .getValue() from cell

Problem: wrong time and timezone .getValue() from cell with format timeThe bug occurs in old spreadsheets from 2017, but not a spreadsheet from 2022 january or

Move row to a different sheet when box is checked

Hi I'm very new to coding with Google Sheets and Excel. My goal is to move a row when it is checked off. The original sheet is called "School Assignments" and t

Bulk rename file names in Drive Folder with Google Sheets

I need to rename image files in a Google Drive folder I have a Google Sheet with 2 columns, old name and new name I would like to rename the files within the sa

Google App Script. Retrieve emails list from the sheet

In the following script I have to manually insert the email addresses. I rather get the list from the sheet to be able to update it without editing the script.

I have to google apps script that I want to have the data sorted automatically

I have this script below that imports data automatically from several sheets via a master sheet that has a list of sheet IDs. I would like the data to be auto s

Google sheets script Auto-run a script and add function in the menu bar

I use a script that allows me to delete the empty rows in the middle of my table and also constantly adds rows at the bottom so that I can keep filling it. Ever

App Script Array Push() in loop Optimization

I'm looking to improve my array push inside loops but I noticed that every time my function is being called (in a loop manner) and executing this lines of code,

Most efficient way to build range from range based on content (e.g. formula)

What is the most efficient way with google script to build a range (newRange) from another range (baseRange) based on some criteria (e.g. the formula contains '

Syntax error: SyntaxError: missing ) after argument list - Google Sheets (super weird one)

I've been trying to save this macro but I get the error message at line 29. However, everything looks right to me? I cannot understand how to get rid of the err