Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
1,285
questions
0
votes
0answers
6 views
How do I get the selected cell on another sheet?
ok here is the manual situation in the spreadsheet:
2 sheets named Green and Blue
Blue is the active sheet and B3 is selected.
If I tab over to the Green sheet, D7 is selected.
So I know somewhere ...
0
votes
1answer
14 views
Continuation token: Generate file listing of a google folder into a google sheet
I have a folder on Google with 18k files and need to list some variables from them into Google sheet. A solution for this was found on Insert image from Google Drive into Google Sheets
However, ...
0
votes
1answer
25 views
How to confirm if values are in a column and move to a new sheet - Google Script
In Google Sheets, I need to check column F if certain values are present. If the values I have specified are in column F, it will copy the entire row and paste it on a new sheet.
The code works when ...
-1
votes
0answers
10 views
How do I write a script so that a button will recreate a range of cells
My document has the following cells:
Item
Name
Size
Impact
Reason
I would like to add a button which will create the same cells below this one, but for item number 2. So clicking this ...
0
votes
1answer
11 views
Google Sheets calendar script is timing out
function onEdit(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
if(sheet.getName() != "Sheet2")
{
return;
}
var lastColoum = sheet....
0
votes
1answer
30 views
Function to copy fields from one sheet to another based on IF statements
I'm trying to figure out a way to copy specific fields to other sheets based on IF statements.
I have 4 sheets, the Customer Subscription Sheet (Sheet 1), Month 1 (Sheet 2), Month 2 (Sheet 3) and ...
0
votes
0answers
13 views
Sending an email to the form submitter with a response number using script
I am looking for a script that will email the form submitter a quote number after they have submitted their request.
I pass the information submitted in the form to another page where it is matched ...
0
votes
0answers
23 views
Updating a cell on another sheet by changing dashboard
I am currently working on a to-do list· dashboard for my household chores and have a question.
I am using a filter to pull daily tasks out of a raw data table, and would like to be able to mark each ...
1
vote
0answers
18 views
Can I automatically add photos and videos that conform to certain conditions to a shared album in Google Photos?
The conditions that I'm talking about would be something like:
photoOrVideo.cameraName == "Apple iPhone X" && photoOrVideo.contains("My friend")
Google Photos is already set up to be able to ...
-1
votes
0answers
14 views
I want auto change uppercase text and font size in google sheet script, anyone can help?
function onEdit(e) {
if (typeof e.value != 'object') {
e.range.setValue(e.value.toUpperCase());
}
}
function onEdit() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss....
-1
votes
0answers
24 views
Synchronize multiple cells on Google Sheets
Building off of this question: Sync multiple cells so that if any one of them is changed, the others change as well
Is there a way to synchronize multiple cells without individually entering them (e....
0
votes
1answer
61 views
How do I stop receiving “Remove risky access” emails about Google Scripts I have created?
I have created a Google Apps Script which I use frequently. I receive regular emails from Google: "Some apps or services that you allowed to access your Google Account have not been verified by Google....
0
votes
0answers
13 views
How to setup Google Sheet to import data to a new row when requirements are met?
So I have a Google Sheet I've made at work to simplify our needs for receiving product, the old sheet was a template and people handwrote everything which leads to confusion for people putting the ...
0
votes
1answer
19 views
Fix my script? How can I automatically create events in google calendar using dates from google sheets?
I read that it is possible to link a google sheet to google calendar, so dates can be used to create events in the calendar. I used script I found around about, but absolutely nothing happens. Can ...
0
votes
0answers
20 views
Print First Modified TimeStamp of edited Cell in a Column range [duplicate]
This code by @Ruben prints out the timestamp for the first modification for A1 into B1. How to do the same but for the whole column so A2:A printing results into B2:B?
// Global variables
var origin =...
0
votes
1answer
15 views
Variables in Google getRange
I have a simple need to copy a range (E4:G4) and paste it X rows below, determined by the value of a cell, C2. I think I may be misunderstanding the offset function since when I run the routine, I get ...
0
votes
0answers
30 views
Need some help inserting break to prevent “Exceeded maximum execution time” Google Sheets script
I'm using a Google Sheet to populate drop downs in a Google Form. There's not a lot of info to be transferred as such, but it's repeated 76 times...
I'll paint the picture first, so you have an idea ...
0
votes
0answers
13 views
How can I populate and submit a Google form using info from Google Sheets?
I'm new to Google script editor and not sure how to go about this. I have a group of people filling out referrals through the Google Form "A", and I would like to use the output of these forms to ...
0
votes
1answer
16 views
Is accessing multiple Google Sheets Files(not multiple google sheets within the same Google Sheet File) in one script possible?
I was wondering if I can copy a certain range of cells in Google Sheet File A and paste it to another Google Sheet File B.
More specifically, I'm referring not to sheets in the same Google Sheet(eg: ...
0
votes
1answer
17 views
Making a chart in Google Sheets
First time poster and currently getting familiar with Google Spreadsheet with using some books and information on the net. However, I couldn't put into words what I was trying to do so I found this ...
1
vote
1answer
39 views
Friendly Team vs. Enemy attack math and complicated functions in Google Sheets
How would I go about writing a function in Google Sheets?
If Friendly Team Hero Power P2,P4,P6,p8 etc. is greater then Enemy Team Power "T2:T15" Else Don't match it and instead look for titan, Same ...
0
votes
1answer
25 views
Google Script Fails to Return Boolean Value
I want to create a simple function that returns a boolean value when the word "website" appears in a specific cell. When I run the debugger, matches returns undefined.
function myFunction() {
var ...
0
votes
0answers
17 views
How do we change existing field and values properties of a file in google drive using Google Apps Script?
There is a PDF file in google drive with properties field : findev and value : ert87t
So now how can we modify the existing field and value's to field : dyndata and value : tgb65.
how can we do this ...
0
votes
0answers
26 views
Google app script on how to create a pdf from the data received from an html form of its spreadsheet and send the pdf file via email
Google app script on how to create a pdf from the data received from an html form of your spreadsheet and send the pdf file via email - I would like to create a pdf file from the data recorded on the ...
0
votes
0answers
23 views
Copy sheet to new spreadsheet folder in selected folder
I know that I'm asking a simple question, but surprisingly, I haven't been able to find where my exact question has been asked before.
Here's the situation: (This is method 1) I've got a sheet within ...
0
votes
0answers
14 views
Auto-populating time instead of the Date, with the exact script below
The script below works perfectly for auto-populating the date. I need it to do the exact same thing but for time. I can't for the life of me figure it out. It does need to populate +1 to the right of ...
0
votes
1answer
28 views
Google Sheets onEdit uppercase script
I'm collecting one-letter responses from users in a Google Sheet and would like their responses to be made uppercase as they are input, but only within the cells D5-J[infinity]. I found a few ...
0
votes
0answers
15 views
On edit script for timestamp on multiple columns with individual timestamp based on the time of the edit made vice all having the same timestamp
I have check boxes every other column starting on column C, and I want the date stamp to appear in column d row 2. The script works great for that, but I also need it be for column e (check box) ...
-1
votes
0answers
18 views
Why don't my changes require verification for a google cloud project?
I am trying to verify a google sheets app so a client from a different organisation could use our previously internal tool. The app doesn't use any sensitive scoped google APIs; it just makes some ...
0
votes
0answers
21 views
Making a script to ignore strike through cells from DA onward when using the transpose/sort function
I've created a master list of sorts. I have several columns of information from DA onward that transpose and sort in column C. I'd like to be able to strike through any of these cells and have the ...
0
votes
0answers
8 views
Google Sheets 2 way Sync [duplicate]
I need some help setting up two-way sync on my Google Sheets spreadsheet. I have created a MASTER tab and then filtered that into 4 different Manager Tabs and another filter based on the Period the ...
0
votes
0answers
12 views
Problem 'Select an active sheet first'
There is a problem and i cannot solve it.
'Please select an active sheet first. (line 5, file "Copy of Code")"
function onEdit(event){
//wa13669601
var ss = SpreadsheetApp.getActiveSpreadsheet()...
1
vote
1answer
56 views
Google Apps Script: Is it possible to log the use of the close button on a Modal Dialogue?
I'm working on a spreadsheet which opens a modal dialogue when a script begins to execute. Inside it plays a google-style "working" animation made with CSS:
If I could remove the close button so ...
0
votes
2answers
51 views
How to Clear Cell(s) based on the Value of another Cell
I am looking for a script that will clear cell(s) when the value of another cell changes or is equal to ("X").
In the attachment I would like when Column "G" gets checked marked (TRUE), then ...
0
votes
0answers
14 views
Time until Specified Date
Looking to add an auto-updated amount of time countdown timer into Google Slides with the working script from this question.
Getting Setup
Go to Google Slides
Create a text box, right click to find ...
0
votes
1answer
18 views
Yield in Google Apps Script
I am trying to create a generator as part of a script that I am writing. I am getting syntax errors. I am starting to wonder if it is because it is a new feature of JavaScript that is not in Google ...
-3
votes
1answer
26 views
How do we add custom properties to a google drive file(PDF) using Google Apps Script?
function addCustomProperty(fileId) {
var property = {
key: 'department',
value: 'Sales',
visibility: 'PUBLIC'
};
Drive.Properties.insert(property, fileId);
}
-1
votes
1answer
16 views
No logger output in sheets
I am getting no output from the logger in sheets. I am a boob, although a 30+ year programmer. Here is my function:
function onChange(e) {
var spreadsheet = e.source;
var cell = spreadsheet....
1
vote
1answer
15 views
What does .activate do in google scripts?
sheetFunction {
var sourceFile = SpreadsheetApp.openById("1asdasdasdasdasd");
// Set sheet
var masterSheet = sourceFile.getSheetByName("Master");
masterSheet.activate
}
cellFunction {
...
0
votes
1answer
21 views
Limit number of rows
I have a Google Sheets document that keeps adding hundreds of rows and slowing down the project, and sometimes causing it to crash.
Is there a way to limit the number of rows to say 100. I do not ...
0
votes
0answers
53 views
What would one create to do what Google Apps Script does?
What is a homemade Google Apps Script alternative I can host? I don't know what this kind of app(?) is called.
Specifically, I use a Google Apps Script to receive webhooks from Quickbooks, immediately ...
2
votes
0answers
27 views
Auto sorting by multiple columns in Google Sheets
I have a data-set which I would like to have sorted with first column 6 and then column 7.
From this post: How can I make some data on a Google Sheets auto-sorting? I have gotten ideas about making a ...
0
votes
0answers
39 views
Avoid Duplicate Events in Auto Sync Google Sheets to Google Calendar
I wish to use this sync process but it will duplicate the events if I do any changes or editing.
What should I do to avoid it?
function scheduleShifts() {
/**
Task 1) Open the Event Calendar.
...
-1
votes
1answer
34 views
Web App get url not working from IMPORTXML
My goal is to get data into my spreadsheet from my script that mimicks the way IMPORTXML works. I want to return html from my script and consume it with IMPORTXML.
It's disabled now, but at the time ...
0
votes
1answer
18 views
Updating slides from sheet
I am trying to update slides from sheet. As simple as that.
I have a working script in sheet which updates the slide if I run it from the gscript editor
I want this script to run onEdit of specific ...
1
vote
0answers
13 views
Date Formatting Issue in Google Sheets Query
I created a shared shipment tracker with google sheets where updates are made in a master tab, then filtered into several regional tabs via query function to better visualize shipment status by region....
0
votes
1answer
28 views
How to open multiple urls in different new browser tabs from Google Sheets with a single click?
I have a row with multiple urls on it. I'd like to open each url in a separate browser tab without having to click on each link. Is this possible in Google Sheets or Google Apps Script?
1
vote
1answer
13 views
How to apply “sendAlertEmailWhenCellValueIsNotEmpty” script to multiple tabs in Google Sheets
I would like to apply this to let's say "Weekly" and "Monthly" tab.
Here's my script:
function sendAlertEmailWhenCellValueIsNotEmpty(){
//send an email alert when cellToWatch is not empty
//set ...
0
votes
0answers
11 views
Get URL for current Apps Script execution's logs?
I have an Apps Script utility that sends me an email when it fails. Is there a way I can get the Apps Script APIs to give me a URL for the current execution and its logs at script.google.com so I can ...
0
votes
1answer
42 views
Write both values and formulas at once in Google Apps Script
The row in my spreadsheet has format
<value>, <formula>, <value>, <formula>, ...
I need to update this row. Indeed, I can't use range.setFormulas, because it has values and ...
