Questions tagged [google-apps-script-triggers]
The google-apps-script-triggers tag has no usage guidance.
0
votes
0answers
22 views
Auto date insert when opposite cell is populated in different columns - only if in a particular sheet in a document
I found this solution to autoinclude the date in a column when another one is modified and it works great. Auto date insert when opposite cell is populated
What Im looking to do is:
To modify this ...
1
vote
1answer
27 views
How do I lock a sheet in Google Sheets at a specific time every day?
I would like the sheet protected from 6pm - 10pm every day. I have the following script but it doesn't seem to protect the sheet at the designated time. I have this script with the Time-based trigger, ...
1
vote
2answers
96 views
Jump to today's date when opened
I have found a similar question here:
How to make Google Sheet jump to today's column when opened?
I want to do a similar thing, but I have the dates in row 5 not in the column. I tried several ...
1
vote
2answers
158 views
Move cursor to cell in all sheets
I have the following script:
function setActiveCells() {
var wb = SpreadsheetApp.getActiveSpreadsheet();
var ws_names = wb.getRangeByName('an_sheets').getValues();
var ws_cells = wb....
0
votes
0answers
33 views
How to update this formula so it automatically updates?
It's come to my attention that GoogleClock no longer works on new sheets, anyway I can update the below code so it can update every minute:
Tried put =SheetNames(NOW())
It says not allowed. I'm very ...
0
votes
0answers
16 views
Blocking cell after changing it's color
I have created simple formula in google sheets which is going to be shared with many people. Sheet will be secured except few columns. I want to let those people edit cell's color in those columns. ...
0
votes
0answers
23 views
Google Sheets Script Apply update function to only the sheet names “Analyses”
I want to apply the script below to only the sheet called "Analyses"
function onEdit() {
var sheetName = "Analyses";
var s = SpreadsheetApp.getActiveSheet(); // Get spreadsheet name
var ...
0
votes
1answer
247 views
Avoiding an authorization request for Google Scripts
I'm in the midst of trying to custom code some script that will automatically hide some sheets from some users in a shared company spreadsheet. Yesterday it seemed to be working fine, but now it seems ...
0
votes
1answer
30 views
Copy data to new column in Google Sheets
I have a sheet with IMPORTHTML that I want to copy data from one column to a new column daily.
function saveData() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet....
0
votes
1answer
267 views
How to trigger a script when a new text value is added to specific column?
I've built a sheet that generates messages for clients based on certain input data. The message appears in a cell in column B when all the required data has been entered. When a new text value is ...
-1
votes
1answer
6k views
Diference between onEdit or onChange trigger? [closed]
From what I've gathered online, onEdit only works when you edit a cell (not when a row is added or when a note/comment is added) and onChange will capture that a change has occurred and trigger when ...
-1
votes
1answer
45 views
One time check to see if document is shared with a specific user
I'm trying to figure out how to write an Apps Script that checks "IF" a Google Drive URL is shared with a specific user. I do not want this to be a continuous check, just a "one time check".
Example ...
0
votes
1answer
379 views
Google Script to set the current month once a day only in a cell
Currently, I'm using (Month(NOW()) to set the current month number in cell $D$1 of a spreadsheet. I know Month and Now are volatile functions and they're making the over sheet update way too slowly, ...
1
vote
2answers
2k views
How to execute a trigger only when one of the sheets is changed
When I have multiple sheets in a spreadsheet, I want to execute a trigger only when One of the Sheets is changed, not the others. OnChange() or OnEdit() is executing the trigger for any data change.
...
0
votes
2answers
426 views
onEdit stops working when other function is run
I'm working on a script to help with a spreadsheet we use at work, but I'm having an annoying bug with the onEdit() function. After running the script from the script editor, it operates as intended (...
0
votes
2answers
268 views
Google App Script - changeType “REMOVE_GRID”
I'm using a Google spreadsheet. I'm attempting to create an onChange trigger that will activate a script when any sheet is added or deleted. I was able to get the script to work when a new sheet is ...
1
vote
2answers
3k views
How to make Google Sheet jump to today's column when opened?
I'm trying to adjust this code so that I can jump to today's date which are all across row 2 in my spreadsheet.
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss....
10
votes
1answer
16k views
Add a script trigger to Google Sheet that will work in Android mobile app
I have a Google sheet that includes a script that should be run when clicking a button. The recommended way to do this (as far as I can tell) is to insert an image and then attach a script to the ...
6
votes
3answers
17k views
How to make Google Sheets jump to today's row when opened?
I have a sheet that has many rows to put data. Since there are too many rows, I want to have the cursor jump to a particular row when the sheet is opened.
Edit not from OP: "The date column has the ...
