We’re rewarding the question askers & reputations are being recalculated! Read more.

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
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
6 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
14 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
53 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
17 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
28 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
28 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
15 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
21 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
19 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
21 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
226 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
27 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
42 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 ...
0
votes
1answer
14 views

Adding checkbox format in column

Trying to add checkbox format to a column using Google Apps Script to this working formula sales.getRange("I2").setFormula("=IF(COUNTIF(B:B,B2)=COUNTIFS(B:B,B2,E:E,TRUE),TRUE)"); var ...