Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
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 ...