Questions tagged [google-apps-script-triggers]
The google-apps-script-triggers tag has no usage guidance.
127
questions
0
votes
2
answers
1k
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 (...
- 11
1
vote
2
answers
1k
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 ...
- 11
4
votes
1
answer
19k
views
Script to copy values only
I have a script which copies new form data from one sheet to another. However, I only want the values and not the formatting to paste.
Here is the script:
function onFormSubmit() {
// moves a ...
- 51
1
vote
1
answer
1k
views
Script for GoogleSheets that inserts date, time, and user names of everyone entering text in a specified cell?
I wanted to ask for your help in building a script in Google spreadsheet that would allow users to respond to comments left by different users in the same cell (cell where the initial comment was ...
- 11
1
vote
1
answer
5k
views
Running multiple onEdit scripts
I am trying to run all three of these in any order but only the third runs:
1.
function onEdit(){
var sh = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var editedCell = sh....
- 11
1
vote
2
answers
9k
views
How do you create an installable trigger for a Google Apps Script?
I've searched all over Google's documentation on this topic and I haven't been able to find a tutorial or article that explains how to do this. I completely understand how to create simple triggers in ...
- 129
1
vote
1
answer
3k
views
Show/Hide Rows based on text in a cell
I'm trying to toggle which rows are shown/hidden on multiple sheets in my Google Sheets document. Simply put, a user will provide an input on Sheet1, which will populate a "show" or "hide" value in ...
- 11
-2
votes
1
answer
5k
views
OnEdit not working when edit
I'm having an issue with this code and hope you could help me. I'm trying to run a script that builds a Data Validation when a cell is edited. I can tell it reads all the information but when I try to ...
1
vote
1
answer
5k
views
Is there any way to identify a user in Google Apps Script?
I have a spreadsheet in Google Sheets that is shared with five people. Only a few columns are edited; all of the other columns are locked.
We need the ability to track changes to these editable ...
- 179
4
votes
1
answer
943
views
Google Sheets Script Editor action not applying to all sheets
I have a Sheets file with a tab/sheet for each month. I am editing the Script Editor to apply an automatic Timestamp when an item is scanned. How do I make the same script for each sheet, but make it ...
- 41
1
vote
1
answer
20k
views
Cell last modified date & user stamp Google Sheets?
I want the cells of two columns in my Spreadsheet to auto-update with the date (m/d/y) and name of user when cells in a certain range are edited. For instance, Catherine goes to sheet on 3/6/2017 (...
- 11
0
votes
1
answer
4k
views
Make cell "flash" onOpen rather than onEdit
I need a Google sheets script which will make the background color of a cell flash. Currently I have a script which works fine, but onEdit. It would be far better in this case if the script could work ...
- 25
0
votes
1
answer
404
views
Restrict the range of a script that replaces input data to a certain range
There is this question regarding adding checkbox functionality to Google Drive: Checkbox function to automatically add to total. And a great answer is:
In the Google Sheets spreadsheet go to Tools -...
3
votes
2
answers
10k
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....
4
votes
3
answers
2k
views
How to restrict a Google Script to a certain cell range?
I'm working in an automatic script that shows the last modified dates of some cells within a sheet. So far, I've succeed with the sheet restriction adding an if condition, but I want to restrict this ...
- 118
1
vote
1
answer
3k
views
Copy and paste information once a day form a Google spreadsheet
I have a Google spreadsheet that is being modified during the day, and need to copy and paste the final information (at 8 pm) in a different tab, each day, pasting the new information under the old ...
23
votes
1
answer
44k
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 ...
- 333
2
votes
1
answer
748
views
Using a script to process form input every time a form is submitted
I'm trying to have it that every time I submit a form, it adds automatically some data. This is the script I have:
function onFormSubmit(Test) {
var sheet = SpreadsheetApp.getActiveSheet();
...
- 21
3
votes
2
answers
5k
views
onOpen doesn't execute
I've got a google spreadsheet I created yesterday and used Tools -> Script Editor to create a function in a single file called Code.gs
function onOpen(e) {
var email = (Session.getEffectiveUser()....
- 159
15
votes
5
answers
39k
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.
In other words: The date column has the ...
- 267
2
votes
1
answer
823
views
Creating multiple timestamps on Google Sheets to make dependent drop-down boxes work
I need timestamps on two different sheets to make two different dependent drop boxes work. I use the scripts below but can only get one sheet to work and not both sheets:
Script time in
function ...
3
votes
2
answers
1k
views
Individual time stamps for individual sheets in a Google Spreadsheet containing multiple sheets
I am using the New Google Sheets, and I have created a "Master Document" that contains a multitude of sheets, with each expressing different kinds of data. I want a "Last modified" time stamp to ...
3
votes
2
answers
3k
views
onEdit only updates top row after pasting (editing) multiple rows
I'm using a Google Spreadsheets and have a script that updates the "last email" column with a date stamp when an employee enters an email address into the prior column. The problem occurs when my ...
- 31
1
vote
2
answers
4k
views
Script to automatically change text value
In GDocs under Tools > Preferences, I can define automatic corrections, so that if I type l*, it spells low, h* -> high, etc.
In Google Spreadsheet there is nothing like that. Can I do that with ...
- 11
8
votes
5
answers
28k
views
How can I make some data Autosort in a spreadsheet on edit?
I am working with a simple spreadsheet that has name/lastnames in it. I need for the spreadsheet to automatically sort the entry alphabetically by the last name (column B).
I have used the following ...
- 81
44
votes
3
answers
104k
views
Auto-updating column in Google Spreadsheet showing last modify date
Trying to figure out a way to have column two auto-update to show a timestamp of the last update. I realize the doc shows a timestamp of the last modification, but we have a lot of clients accessing ...
- 451
21
votes
7
answers
77k
views
Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?
Is it possible in Google Forms to give a unique value to each row it inserts into the spreadsheet as well as the timestamp?
- 679