55,622 questions
0
votes
0
answers
14
views
Click on Element not working in the Chrome browser on mobile phone after zoom in and zoom out the window
After zoom in & zoom out the window, i try to click the option and button element not work any more:
When i test on chrome browser with android mobile, before zoom in & zoom out the window ...
-1
votes
1
answer
45
views
How Do I Apply My AppsScript to Only One Tab of My Spreadsheet?
I have an Apps Script that allows me to create custom invoices for my business, but I am unable to figure out how to apply my entire script to just one tab of my spreadsheet. As it is, it applies to ...
1
vote
2
answers
121
views
Select Range of Columns by Dates, Fill with values from another column
I have all the daily dates running across the columns E:NK. I want to specify a custom variable date range using dates in Columns B&C and then populate those selected columns with values from ...
- 57
1
vote
1
answer
49
views
GmailApp.search() doesn't find recent emails
I'm the IT admin for a small music studio. We receive new inquiries about private lessons from a web form, which sends a copy of each submission to an inbox I share with other staff. An Apps Script ...
- 11
0
votes
1
answer
59
views
GoogleApp script getting failed: Service invoked too many times for one day
I added a custom script on Google script dashboard which filters my emails and archive based on sender. Here is the script (changed the original sender with xyz, abc for brevity):
function ...
- 54.1k
0
votes
1
answer
100
views
How to retrieve triggers?
Google Sheets App Script v8: oauthScopes and ScriptApp.getProjectTriggers
Update:
See reproducible example.
App script trigger.gs contains a custom function that is called from the spreadsheet.
...
- 51
3
votes
2
answers
165
views
How do I update the font color of a key value of a Scorecard chart?
I've tried several ways to change the font color of the key value of a scorecard chart in Google Sheets, but I'm unable to do so. option titleTextStyle.color changes the Title color only. I've tried ...
0
votes
1
answer
63
views
How can I prevent my script from timing out when writing formulas to a large file?
I’m trying to automate some changes in a file that has two versions: one with about 5,000 rows and another with around 80,000 rows.
When I run my script on the smaller file, it works fine. But when I ...
-1
votes
2
answers
97
views
Autosorting 2 columns function with negative number to be shown at the top
This is my demo sheet:
https://docs.google.com/spreadsheets/d/17OiBMhbeW35T50sSE9J-NQyvTAbirM4OSePEzW2iIiE/
And I have this script in Google App Script:
function autoSort() {
const ss = ...
- 11
1
vote
1
answer
63
views
Multiple Attendees for Automated Calendar Invite via Sheets
I hitting an error when I try to add multiple attendees via my spreadsheet. It works with one but when I try comma-separate to include multiple attendees it throws an error:
Error ...
- 13
1
vote
2
answers
130
views
How can I add an unchecked checkbox to sorted data in Google Sheets?
I have a Google Form that takes entered information and outputs it to a Google Sheet. The responses from this form are then sorted in a separate tab. I want this information to be sorted by most ...
- 23
0
votes
1
answer
85
views
Adding a list of variables to a spreadsheet [closed]
I have a Google Sheets Macro which under certain conditions generates an email with 3 variables in them.
I want it to also place these 3 values on a new line into the same spreadsheet, but on a ...
- 7,947
-1
votes
1
answer
61
views
How to make a Google Sheets apps script to hide rows based on colour to work on multiple sheets
I managed to locate a script to hide rows based on a background colour, which works for just 1 sheet, but I'd like it to work on all the sheets within that spreadsheet. I have sheets labelled MSQ1, ...
0
votes
1
answer
81
views
How to Programmatically Style the Google Sheets Sidebar Container with Apps Script
I'm trying to change the background color and font color of the main Google Sheets sidebar container—the frame that holds the title and close button—using server-side Google Apps Script.
I know how to ...
- 11
0
votes
0
answers
67
views
How do I handle query string with ajax to pass a Google Sheets ID parameter to my app script so it can show that Google Sheet's data on my website? [closed]
I’ve been working on a website built to show a table of sports teams and their stats. In order to do so I am utilizing datatables, ajax, google sheets, and google app script. I’m also using Hostinger ...
