Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
0
votes
0answers
8 views
Im trying to make a automated script, that auto sends emails with an pdf attachment
This is my script
function sendEmails() {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2; // First row of data to process
var numRows = 8; // Number of rows to process
// ...
-1
votes
1answer
14 views
Google Script Editor apply to all sheets except 1st, 2nd and 3rd sheet
Currently this code is only applied to the sheet called "Name" I wanted applied to all except for 3 sheets (Template,Summary and Count):
function EqualValue() {
var ss = SpreadsheetApp....
0
votes
0answers
10 views
Get final redirected link from Google's “I'm feeling lucky” function
I need to write a Google App Script function that takes the redirected link from Google's "I feeling lucky" button.
The function should take:
http://www.google.com/search?q="stackoverflow"&btnI
...
0
votes
0answers
14 views
How to make Google sheets editable only for a few days a month
I have a spreadsheet in which users fill in their names for their shifts for next month, and they should do it only during 20th to 25th in a month but they keep breaking this rule. So I would like to ...
-2
votes
0answers
10 views
Google Scripts - Retreive UrlFetchApp.fetch after javascript edited the page
I am trying to fetch a page (rotoql.com) using Google App Script's UrlFetchApp.fetch, but the rotoql.com is different in the 'Inspect Element' of a browser than it is in the 'View Source'. ...
0
votes
1answer
22 views
Conditional formatting with color scale for many rows independently once
I create reports with different cohort tables. Each row of a table must have conditional formatting with color scale (depending only on current row values, i.e. regardless of other rows min/max values)...
0
votes
0answers
22 views
Dialogue Box Input w/o click (just enter) in Google Sheets
I want to be able to use a barcode scanner to enter data in a dialogue box in Google Sheets. The barcode scanner inserts "enter" after the numbers. How can I make the enter trigger the data entry (...
0
votes
0answers
8 views
Recalculation of references after Copy in Google SpreadSheet
I have the problem of the lost references after a copy in Google Spreadsheet that has been solved in that post with the "Find and Replace" of "=". But is there anyway to do that trick in recalculation ...
0
votes
1answer
14 views
How to use 3 separate sheet specific onEdit formulas?
So I have 3 separate sheets in on Google Sheet Doc, I have a script running on the first sheet that hides a row when a drop down is ammended:
var SHEET = "Tweaks Needed";
var VALUE = "All Tweaks Made"...
0
votes
1answer
26 views
How can I use a script across multiple pages of a Google Sheet
I'll start by saying I'm very new to this. Here's my problem. I have a GoogleSheet I created to use as a seating chart in my classes. It is designed so that when I click the blue check button the cell ...
0
votes
1answer
13 views
How to navigate to a specific sheet in Google Sheets based upon a cell value
What I am hoping to do is take the =Now() date that is located on my default sheet and in the Row 1 Column 1 cell and somehow when the sheet is accessed onOpen() have it automatically change the ...
0
votes
0answers
20 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
1answer
18 views
If I set the school to “School A” then only School A's classes should be visible
I have created a progress tracker for the Academy Trust I work in. The trust at the moment consist of 4 schools. Students move between the schools as the progress and between classes during the year ...
0
votes
1answer
27 views
Creating a script for Google Sheets to send an email if cells in a row contain a certain value
I have a Google spreadsheet that I created to track daily equipment inspections. The data in the sheet comes from a form that is filled out by whoever inspects the equipment for that day.
Here's a ...
0
votes
0answers
13 views
How to parse custom date format in Google Sheets?
I often have sheets with dates written in different formats than the one GS recognizes as a date. What's a painless way to convert those to dates, perhaps by specifying a format string?
So to clarify,...
0
votes
0answers
12 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. ...
1
vote
0answers
21 views
How to combine an auto response with forwarding in my Gmail account?
I am trying to find a way to figure out how to combine an auto response with forwarding in my Gmail account. Essentially, I want to receive a message, add a canned response and then resend the new ...
0
votes
0answers
14 views
Google Apps Script to Copy data from Sheet1 and Paste in Shee2 Specific Columns
I am trying to copy paste data from Google sheet1 to sheet2. I can copy data from specific cells but I am not able to paste data into specific sheet2 range. My function is automatically pasting data ...
0
votes
0answers
6 views
Have column B clear itself if column A's value increase past set intervals
I have little to no experience with scripts, just start using Google Sheets. That being said I don't know if what I want is possible. I have a data sheet that keeps a continuous counting check using a ...
0
votes
0answers
21 views
Button that Creates New Row and Copies Functions/Format
I am attempting to script a button, that when pressed, will create a new row below the currently active cell and copy all of the formats and formulas from the row of the cell that is selected.
I was ...
0
votes
1answer
17 views
Create keystroke to a script
In Google "documents" (not Spreadsheets), I've a script to insert Date. How do I create a keystroke to activate the script?
0
votes
0answers
19 views
timestamp for specific value change in different column
I want an automatic timestamp to appear in column D ('Receive Date') when the value in column B ('Status') is changed to 'Received'. I have the script below, but it inserts a timestamp regardless of ...
0
votes
1answer
25 views
Script that allows you to take a list and create a tab for each item in the list
I have a table with columns: PID, Project name, ... (14 Columns) like this
PID Project_name Department Plan Effort estimation ....
111 Project1 qw 50 60
111 Project1 sw ...
0
votes
0answers
18 views
Values of a sheet not updating
I'm trying to send data to another spreadsheet. To do it, I wrote a code which I've been using for months, but I'm trying to use the same code with another spreadsheet and suddenly the code stop to ...
0
votes
0answers
17 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
0answers
11 views
Add one column after E column in all sheets [duplicate]
any ideas how can I add a Column after a determinate column in all sheets in one time?
0
votes
1answer
18 views
Google Apps Script with local drive attachment
Can Google Apps Script send an email through Gmail with an attachment from a local drive not Google Drive? If so, how?
0
votes
1answer
13 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
2answers
56 views
The script does not have permission to get the active user's identity
Anyone know why this caused The script does not have permission to get the active user's identity.?
I don't have any functions that asks for the user identity. So I'm a little confused.
function ...
0
votes
1answer
14 views
Getting changeType Attribute in edit Trigger Google Apps Script
How can one tell the action triggered the onEdit function in Google Apps Scripting? The actions I have found to trigger it include:
edit a cell
delete a cell or range
cut or copy a cell or range
Copy ...
0
votes
0answers
21 views
How to use Sheet, Range protection and Conditional formatting simultaneously in Google Sheets?
I have created a google sheet for my sales team having two members. Gave access to them for two columns (Followup Date and Status) to fill their daily report. I have created another column '...
1
vote
1answer
45 views
Add a new row to a spreadsheet, copying down formulas when a certain cell reaches a particular value
I've got a simple Google Sheet (it's literally one line), that has in A2 =now() to calculate the current time, and then a series of formulas calculating various dates/times based on the current date ...
0
votes
0answers
19 views
Google Script Reset Filters
I have what seems like an odd question.
So I've been working on a spreadsheet that auto populates data based on which sheet you select in a Drop Down menu made through data validation. I also have ...
0
votes
1answer
23 views
Alternate to Nested IF statements
Goal here is to have the sheets search a row, then once it finds the first instance of >=0, return the cell value that contains the month+concatenate the value in the cell next to it (or any other ...
-2
votes
0answers
18 views
Proper way to handle authorization in Google Forms etc. Addon [migrated]
Since G-Suite dev docs say that
"the script project's global code and the AuthMode.NONE path of the
onOpen(e) function should not contain calls to services that require
authentication",
how ...
0
votes
0answers
16 views
How to auto add user name who have access to Google Spreadsheet?
I already have a script for timestamp but I want to add also the username who have access as well in the Spreadsheet, perhaps to be entered automatically in the third column of offset col. Hope ...
0
votes
0answers
17 views
Insert Date When Enter is Pressed in Google Docs?
I'm trying to create a document that serves as an Event Log.
For that I would like that once the enter is pressed, the date and time are automatically inserted.
I am new with App Script. I think I ...
0
votes
1answer
13 views
.getActiveSheet function work for every tab but one
I have the following function that adds the latest edit time to the L1 cell in our spreadsheet -
function onEdit(e) {
// Prevent errors if no object is passed.
if (!e) return;
// Get the ...
0
votes
0answers
21 views
Clear cells throughout a column based on value in corresponding column
I have the below script, but am needing to make a slight adjustment/have a query
Is it possible/how can I restrict this to only work with one specific sheet, not all within the workbook?
How can I ...
0
votes
0answers
16 views
Can I activate a filtered view in Google Sheets from a script?
Can I activate a filtered view in Google Sheets using a script? I've been looking for a preexisting function but can not find one. Is this possible to do?
I can't use normal filters as more then one ...
0
votes
0answers
30 views
Speed up Google Sheets scripts
I use following scripts to do the following:
Insert newline
Copy info from line below to newline
script takes extremely long, how do I
function rijToevoegen() {
var spreadsheet = SpreadsheetApp....
2
votes
1answer
64 views
Do new Gmail OAuth policies affect code I've written for myself?
I have a Spreadsheet in my Google Drive account with my own code which accesses my mails on Gmail, searches for unread, starred mails with a certain label and forwards this mail to different receivers....
0
votes
0answers
12 views
Dates entire week Google Spreadsheet with script
I'm building a tracker and I want different pages to represent different weeks, but I don't want to mannualy put in all the dates of the entire week, every week.
Is there a script that I can use that ...
0
votes
0answers
13 views
Multi url parsing in G Sheet
Sorry i am just a newbee in stackexchange, its great solution place, i have followed
Question Edited
I have got to accumulate the data from 7 to 10 urls
which are rss feeds, xml feed and from json ...
0
votes
1answer
21 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....
1
vote
0answers
14 views
How to Get Data from Multiple Cells and Combine into a Comment in another cell
I have a spreadsheet of orders (rows) that has room for 70 products (columns). I would like for a script to find every cell that has a value (0's are blank) and then write that value (this is the qty ...
1
vote
1answer
23 views
Sheet Specific Scripts
I'm currently using the below script to timestamp when an edit is made to column 7 on a sheet named "Sheet 1".
function onEdit(e) {
if ([7].indexOf(e.range.columnStart) != -1) {
e.range.offset(...
0
votes
3answers
53 views
How to analyze a time tracking sheet with Google Sheets?
I have a simple time tracking set up with Tasker on my phone that creates a new line every time I connect to my work Wifi.
I upload this csv file regularly to Google Drive and import it to a Google ...
1
vote
1answer
81 views
Redirect link to another Google drive video
Is there a way to redirect a link to another video in Google Drive when both are made shareable?
I ask this because I have shared someone a link to an older video and I want them to access the new ...
0
votes
0answers
5 views
GAS & sheet with multiple variable height charts. How to set position
In a Google Sheet I am inserting multiple chart dynamically.
function formatCharts(cTargetSs,cSheetFrom,anchorRow) {
var sheet = cTargetSs.getSheetByName('Charts');
var sheetFrom = cTargetSs....
