Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
0
votes
1answer
15 views
How to apply scripting only to rows with data in them?
I have a Google Sheet that adds multiples rows per day as forms get entered.
What's the best, most hands-off way to apply formulae to rows as they get added?
I've built a script, but it applies the ...
2
votes
1answer
14 views
Timestamping purchase entries
I’ve created myself a budget tracker where I can track what I bought and how much I spent across a few categories. I specified column B (purchase entries are rows) to be the date and time at which I ...
0
votes
1answer
16 views
Calculations which won't recalculate
I'm trying to make a simple calculator in Google Sheets with checkboxes for certain values. For simplicity I'll refer to these Checkboxes as A and B. What I would like to have is the user selects A, B,...
0
votes
1answer
17 views
Making Google Sheets script work on multiple tabs
Below is my script or code:
function myFunction() {
}
function onEdit() {
var s = SpreadsheetApp.getActive().getSheetByName('Sheet1');
s.showRows(1, s.getMaxRows());
s.getRange('H:H')
....
0
votes
1answer
21 views
Running formatting script across multiple Google Sheets tabs
I have an onEdit script I'm using to protect/force formatting on a single tab within a google sheets document - and it works perfectly.
The issue I have is that I'd like the same script to work on ...
0
votes
1answer
20 views
Data from HTTP link does not refresh [duplicate]
I have implemented the script below in my google sheets to get the data from the http link in cells of my google sheets. this script works fine but now I want it to be refreshed every 5 minutes. I ...
0
votes
1answer
44 views
Split multi-line (comma-separated) cell into new rows + duplicate surrounding row entries
Based on: Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)
How can I rewrite this for use of a comma as separator and remove blank spaces?
Input sheet:
...
-1
votes
0answers
8 views
Help me on converting the VB scrip to Google Script [closed]
Can anyone help me to convert the following VB script to Google script.
Sub ShowPass()
UserForm1.Show
End Sub
Sub ResetSIG()
Dim pwd As String
' Turn off application events to prevent problems ...
0
votes
2answers
12 views
How to merge Google documents with PDF files automatically?
I am trying to merge different file sources into one Google doc, in a programmatic way. That means I should use Google scripting. So far I do not have problems inserting text files, images, MS Word or ...
0
votes
0answers
16 views
Classic Google Sites page throws error on the web browser console
I just noticed that it’s not even my code that causes the error — classic Google Sites page on load is throwing that error. I tried in incognito mode and I still get an error on any page load.
I am ...
1
vote
1answer
32 views
Dynamic protection based on cell value
In my Google spreadsheet, I want to protect all cells below a checkbox if it's value is true and unprotect if it's value is false. Every cell in row 3 is a checkbox that this has to work for.
Example ...
0
votes
1answer
22 views
Making select columns UPPERCASE
In relation to the post linked below, is there a similar script out there that will apply this same functionality to only certain columns in a Google Sheet?
Convert all text to UPPERCASE in a Google ...
1
vote
1answer
27 views
Is there a way to emulate Vlookup in Google Script?
I did some looking around and I'm struggling quite a bit in finding the answer.
I'm working on a Google Script for Google Sheets that works like a Vlookup, where you define a cell for it to look at, ...
1
vote
1answer
27 views
Cell format protection + forced capitalisation [duplicate]
I've created a Google Sheets document intended for daily use by more than a dozen people. Text inputted in two of the columns is set up, via conditional formatting, to change colour based on the name ...
1
vote
1answer
13 views
Can I record the users within a Google sheet?
I'd like to have an auto-generated list of users with timestamps within a spreadsheet, tabs, or if possible specific cells.
Ideally, once a cell has been altered, I'd like another cell to record the ...
0
votes
0answers
18 views
Have script code itself dynamically update based on value of cell in sheet?
I'd like to have the script coding itself change as I change the data in a sheet. For example, I have a script set to list the all the files in a particular folder as well as their ids. It spits them ...
0
votes
0answers
9 views
sheet date copy
When you run a macro from the "A" sheet, you need a script that pastes the data from "A1:C1" to the "B" sheet "A:C". We want data to be stacked in a blank space every time we run a macro, whether it's ...
-3
votes
1answer
34 views
Possible scam using Google Drive
Is there any possibility of someone harvesting email address and/or Google profile info by sharing a link to a file on Google drive and collecting info on the people who view the file?
I suspect a ...
0
votes
2answers
31 views
Having Google Sheets not recalculate a formula on page load
I have a Google Sheet with a list of addresses, and a column that geocodes the addresses with mapquest via Google App Script. This works great, except it "recalculates" the addresses on page load. ...
0
votes
1answer
23 views
What is the difference between Google Apps Script add-on and web app?
The issue is mainly that I don't understand what is meant by the web app. I understood that it must support HTTP requests, but otherwise is it the same? Or is the difference in publishing?
I looked ...
1
vote
0answers
32 views
Internal Error when trying to share Google Apps Script
I'm the owner of a Google Apps Script project that contains several scripts. When I try to give Edit permissions to people in my organization, it throws an error:
Error
Sorry, an internal ...
1
vote
0answers
21 views
How to pass a parameter allow= “geolocation” when embedding Google Apps Script in a Google site?
The target is to embed a Google Apps Script gadget into my Google site. The function of this script is to show a google map, determin the location of the client and center the map to the found ...
0
votes
1answer
22 views
Is it possible to reverse engineer a Google Doc into Google Apps Script File?
I'm trying to figure out if it is it possible to reverse engineer a Google Doc into Google Apps Script File? I'd like to be able to evaluate a Google Doc (GD#1) by its URL and convert that doc into a ...
0
votes
1answer
11 views
Google spreadsheet mail as Excel attachment
I want to mail Google Spreadsheet as excel attachment, and also I want to write
4 to 5 lines in the body of a mail, and also I want to send this mail to many peoples some in "To", and some in "Cc" can ...
-1
votes
0answers
11 views
Call Google Editor Addon's function from the Script editor [migrated]
I have a backend service and some users with data in their Google Sheets. I want my service to fetch and modify data in those sheets on behalf of their owners. So I've written a two-part solution:
...
-3
votes
0answers
25 views
Input value from list and perform multiple tests from another another list while recording the results
I'm new to Javscript and have obviusly gone in over my head.
I'm making a sheet to perform testing on simple trading algorithms. In short I'm working with three different sheets. In the first sheet(...
0
votes
1answer
28 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
19 views
Google Script Editor apply to all sheets except 1st, 2nd and 3rd sheet [duplicate]
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
29 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
17 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 ...
0
votes
1answer
37 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
27 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
9 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
19 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
34 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
15 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
23 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
20 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
32 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
17 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
13 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
23 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
38 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
23 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
36 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
32 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
26 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
35 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
20 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?
