Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
1,216
questions
1
vote
0answers
2 views
Delete Google Group posts by age
I am looking into using a Google group collaborative inbox for unsolicited resumes (in Europe).
One important requirement for companies managing resumes, is that they should be deleted after some X ...
0
votes
0answers
5 views
How to Redirect to another Website upon Google Form Submission?
I have a Google Form which is backed by a Google Apps Script with an onFormSubmit function, which fires when the Form is submitted. The next thing I want to do is, after the Form data processing is ...
0
votes
0answers
10 views
Apply Filter script on multiple sheets
I made a script to filter column D3 on active sheet, I would like to do the same on multiple sheet at the same time from an action button on my index page.
E.g. (tab1, tab2, tab5, tab7)
What do I ...
0
votes
0answers
7 views
Appscript for UPPER function
I have this script that works perfectly:
function firstColumnUPPER() {
var activeCell = SpreadsheetApp.getActiveSheet().getActiveCell();
if (activeCell.getColumn() == 2) {
if (activeCell....
0
votes
0answers
10 views
Changing permissions on Google Drive file/folder
I was wondering if anyone could help me, I have a script that I would like to create but I am not sure where to start.
I would like a script that takes selected files/folders in Google Drive and sets ...
0
votes
0answers
15 views
Is there any way to set different formulas for multiple ranges all at once?
In my question Is there any way to set different values for multiple ranges all at once?, I found out how to set different values across dis-contiguous cells all at once, and we developed a good ...
0
votes
0answers
13 views
Added importJSON function and importHTML stopped working
I built a great Google Sheets spreadsheet which has been working for a year with no hickups. It pulls data from websites using importHTML. I then tried to add the importJSON function to the ...
0
votes
0answers
10 views
How to post an aspx web forms and get result
There is a asp.net web page, aspx, Search By Address, which works fine in the browser, and I can inspect the request in Chrome debugger,
but instead of doing this search manually, I'd like to do it ...
-2
votes
1answer
55 views
How can I speed up this script in google sheets?
I am wondering if there is a more efficient way to speeding up this script?
var ws = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Trends");
var wsOptions = SpreadsheetApp....
-1
votes
0answers
18 views
Display only last 4 character in Google Sheets for privacy
Display only last 4 character in Google Sheets
Current situation:
I have a scanner which will scan customer id. The id number will be in google sheet. However, on scanning I do not want google sheet ...
0
votes
0answers
25 views
Google Sheets automated proper case?
I'm playing the game World of Warcraft and my guild has an attendance signup sheet for raids we do every week together.
Everyone visits the sheet and types in their class|name|talents so that the rest ...
1
vote
1answer
13 views
I have the formula I want to use but now sure how to change it with time another time zone
I have a formula setup that I want to use. But I have a separate sheet that I want to use in a different time zone. The one I have written is in EST. but I want another sheet to use the same formula ...
1
vote
0answers
29 views
Custom function on Google Sheets that can extract hyperlinks from formulated cells
I recently found this post, which is so close to my solution, but not quite there!
Extract the link text and URL from a hyperlinked cell
The issue with this custom formula (=LinkURL()) is that it ...
0
votes
1answer
25 views
Find and replace rich text within a cell
I would like to know if it is possible in the current sheets api, or the google script for sheets, to find and replace rich text.
In my specific example, I have red text that I would like to remove ...
2
votes
0answers
29 views
*UPDATE* Hide/unhide certain columns on some conditions
UPDATE: I FIGURED IT OUT!!!! YEY!!!!
Im trying to have certain columns in my Google Sheet hide or unhide, depending on some conditions. I realized that this is difficult. But I've managed (I think) ...
0
votes
0answers
16 views
Google Sheets script that allows hiding and filtering of rows in a protected range?
Like many others I am trying to allow the average user to hide rows in a spreadsheet that has an entire protected column. Currently, they are denited because hiding is considered editing.
From this ...
1
vote
0answers
22 views
Importing data into Google Form response sheet with date, list, grid
I have a normal Google Form that is filling answers into a response spreadsheet but I want to import pre-existing data stored on another Google Sheet (100 entries) that match the Google Form responses ...
0
votes
1answer
17 views
Google Apps Script Javascript compatibility error
I have successfully created some code to extract data from a 2D array using A1 notation. Handy to avoid multiple calls to GAS services whit ordinary getRange calls.
While the code perfectly works in ...
2
votes
2answers
35 views
Is there any way to set different values for multiple ranges all at once?
Is there any way via script to put "Apple" in cell A1 and "Banana" in cell B4 simultaneously?
The motivation to do so would be that the sheet would only recalculate one time. Currently it re-...
1
vote
1answer
23 views
Multiple custom menu order
I have set up multiple custom menus in one of my Google Sheets. While the items in the menu stay in order, the 3 menus that I have created are always switching places. Is there a way for me to order ...
0
votes
2answers
39 views
gscript “getValue()” returns “#VALUE!” error
Problem
My spreadsheet displays a number in the ReturnOnInvestment range, not the #VALUE! error. I checked analysisSheet.getRange("ReturnOnInvestment").getA1Notation() to make sure I'm not confused ...
0
votes
1answer
13 views
Google Sheets script server error on activeSpreadsheet.getNamedRanges()
I have a script to get a list of Named Ranges on a google spreadsheet. I was working fine until yesterday, where the execution is failing with:
We're sorry, a server error occurred. Please wait a ...
1
vote
1answer
13 views
Can I use Google Sheets to Automatically Update Font Styling, Size, Color, etc.?
I have been creating a contact list in Google Sheets to continually add and update names, emails, organizations, etc. for work. I am often copying and pasting this information from other sources as to ...
0
votes
0answers
20 views
Clearing 1 cell based on a changing the contents in another cell
I'm trying to clear a cell based on changing the contents of another cell. I have tried this solution below but it has a few ramifications.
it is executing for all tabs. I want to specify one tab. ...
1
vote
1answer
41 views
How can I get the information from a column next to the active cell to be included in the email?
I have this script running which works fine. However as you see, it only copies the information of the active cell in Column 10 toString. How can I get the information next to it in Column 11 to be ...
0
votes
1answer
26 views
Google Apps Script slow applying sheet/range protection
I am building a set of spreadsheets using Google Apps Script. Each spreadsheet is being created with a set of 10 sheets. Now that the all seems working, I have added some code to protect ranges, ...
-1
votes
0answers
15 views
Google Script to delete responses based on specific URL the zapier will send
I'm new to this script thing. And honestly I don't have much of a background in coding. I'm looking for a script that will delete multiple rows based on the URL zapier will send to the googlesheet.
...
2
votes
0answers
18 views
IMPORTRANGE, where range shifts often, to different spreadsheet
What I have: a client information spreadsheet that contains company information including their last order date following the status of their account (active/follow-up).
What I need: the last order ...
0
votes
1answer
22 views
Apply protection to multiple sheets in a Google Spreadsheet
Ive got a Google Spreadsheet with 50+ data tabs, and 5 Summary tabs at the end.
The 50+ data tabs all have the same column headers.
I want to apply protection to the all these data "data tabs" to ...
0
votes
1answer
28 views
Google Sheet Humongous Bottleneck Caused by this FILTER function. How to fix?
I have identified by trial and error that this one FILTER function is causing a massive "Calculating Formulas..." delay in my Google Sheet. This is the ONLY cause of the delay I have tested it ...
1
vote
1answer
33 views
Help to modify code please
I would like to use this code :
function onEdit(e) {
if(e.range.rowStart === 1 && e.range.columnStart === 1) {
e.range.offset(0,1).clearContent();
}
}
but only on a tab called '...
1
vote
1answer
27 views
“Calculating formulas” in Google Sheet disaster
I have a worksheet with 13 sheets. the largest one has 2000 rows. I have already deleted all the possible blank rows i could.
I have also read all the guides on how to make a Google Sheet faster and ...
0
votes
0answers
23 views
Non Business Hours Auto Reply in Gmail
I am trying to add an Auto reply to emails received during non-business hours. The vacation responder does not allow for this. Business Hours are Monday-Thursday 8:30 am-4:00 pm and Friday 8:30 am-12:...
1
vote
0answers
50 views
Insert image to spreadsheet from google drive folder, png image dose not show, why?
Update
It is now working,i dont know if google fix it or what. But if i use the image function and use the script below to find the id from the folder it works. Here is my final text if someone would ...
0
votes
1answer
28 views
Reverse Shortened URL to Get the Original URL Before the Shortening in Google Sheets
I have a sheet where I collect tweets with links based on a search query. Twitter, however, is handing me for each tweet their short URL format (t.co) rather than the original URL that was shared.
Is ...
2
votes
1answer
41 views
Reference formulas from one sheet into multiple sheets
I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced.
For example, if I have =...
1
vote
1answer
33 views
Automating Find & Replace to change font colour
I write about the card game bridge, so I need to automate this formatting all the time:
Find all "♣" and color the text green (#00b700).
Find all "♦" and color the text orange (#ff8100).
Find all "♥" ...
3
votes
1answer
230 views
Parse JSON from Google Spreadsheet Cell
I am working on an API with google spreadsheet and app script to retrieve JSON response; I am using ImportJSON function (custom function by Brad Jasper and Trevor Lohrbeer) to retrieve and parse JSON ...
-1
votes
1answer
28 views
GAS MailApp.SendEmail - include multiple attachments using ss cell value
I have file names separated by commas (no spaces) in a google sheets cell 'filez1.pdf,filez2.pdf'.
If I assign a variable as a string;
flist = "filez1.pdf,filez2.pdf"
or an array
flist = ["filez1....
0
votes
1answer
13 views
postEdit functions getting range
Does anyone know how I can change the below function to postEdit rather than onEdit?
I am trying to set this in an autoSort function so that the sheet will be edited only after all values in an ...
1
vote
1answer
27 views
Increase my script perfomance and speed
I was ran this script. It worked in more than 30 minutes. I don't know how to make it faster. May be have the way to reduce run time to 5-15 minutes .
strong textfunction sumData1() {
var ss1 = ...
0
votes
1answer
27 views
Copy Rows from Master Sheet to other sheets based on user input
I am trying to set up an assignment sheet for my work team. I have a script to move a selected range from one sheet to another, but is there a way to modify it to have the person doing the assigning ...
0
votes
2answers
67 views
How can I locate a sheet by name from Google Sheets [closed]
I have a Google Sheets spreadsheet with a large number of sheets. I want to find a particular sheet by sheet name from Google Sheets.
I know how to locate a sheet by name using a Google Application ...
0
votes
1answer
28 views
Is it possible to set a timer on Google Sheets ui.alert()?
So I have a ui.alert that triggers and asks for confirmation before making an edit on a Google Sheet.
function confirmation(){
//Call Spreadsheet alert and give it a variable
var ui = ...
0
votes
1answer
48 views
search/match a date on Google Sheets using Google script and copy a source range to a destination range OFFSET from that date
UPDATE: I FIGURED IT OUT.
I'm struggling with some simple copy/paste scripting in Google Sheets. I'm a complete scripting newbie. Advanced at Excel/Sheets.
I have a "Today" data entry sheet. I ...
0
votes
1answer
39 views
Include filename of source spreadsheet
I have 2 spreadsheets for 2 employees and I combine them into 1.
From employee 1:
From employee 2:
I use importrange to combine the sheets. I also know now how to get the spreadsheet file name by ...
1
vote
1answer
44 views
Writing a macro to create a new tab and name that tab based on a cell value in Google Sheets
I would like to have a Macro that generates a new tab and names that tab based on a cell value.
There is a tab called 'Dashboard'! on which the user enters information in assigned cells. Afterwards, ...
0
votes
1answer
43 views
How to prevent “invoked too many times per second” error [duplicate]
The main requirement is to find travel time with traffic data between two locations or zip-code.
Inputs parameters would be from Location, destination, arrival time(this is between 6AM 8AM), mode of ...
1
vote
1answer
38 views
Synchronizing Cell Changes Across Sheets
I'm trying to connect a pair of cells on different sheets within the same Google Spreadsheet, so that after a new value is entered into one cell, the other cell will update to match that value, going ...
1
vote
1answer
16 views
Fill-down formula to last used row
This function is to copy-down a formula C2424 to the last used row. Instead of copying it down to the last used formula its copying it to the last existent row within the sheet. How can I do it only ...
