Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
0
votes
0answers
22 views
Translate UrlFetchApp Response HTML To Google Sheet
I'm new to working with APIs/CURL and trying to figure out how to get a response (not response code) into a sheet. Here's my code:
function myFunction() {
var url = "https://platform.quip.com/1/...
1
vote
1answer
12 views
Jump to today's date when opened
I have found a similar question here:
How to make Google Sheet jump to today's column when opened?
I want to do a similar thing, but I have the dates in row 5 not in the column. I tried several ...
0
votes
0answers
18 views
Google Script Range Error - Owner Range?
I've been playing around with Google Scripts and I'm trying to pull some data into a sheet. It all seems to check out except one line where I get a range error, I know (or I think I do) that it has ...
0
votes
1answer
13 views
How to upload a photo from mobile phone to Google Forms as an answer?
One can choose file upload to Google Forms, but when answering in form option only opens Google Drive upload dialog. Is there any way to upload photo from mobile phone as an answer? E.g. is it ...
0
votes
1answer
27 views
How to print the first modified date of a cell
I would like to make a script that works like this script to print a timestamp when a cell was last updated but in this case I want to return when it was first updated, not last.
Here is one attempt:...
0
votes
1answer
16 views
Move ROW upon selecting a specific option from drop down menu
I am looking to use Google Sheets to keep track of my jobs. I have a spreadsheet set up so the status of a job is indicated by a dropdown menu. When a job is completed I would select "Closed" from the ...
0
votes
1answer
24 views
A Google script to disable keys in a keyboard
I have a project in which the "Delete" key needs to be disabled in keyboard when working on the sheet. Is there a script to do this?
1
vote
1answer
15 views
Move cursor to cell in all sheets
I have the following script:
function setActiveCells() {
var wb = SpreadsheetApp.getActiveSpreadsheet();
var ws_names = wb.getRangeByName('an_sheets').getValues();
var ws_cells = wb....
0
votes
0answers
12 views
Auto-Sort script which excludes formula if ascending False
I am looking to exclude formulas or blank cells when I am running my auto sort. I used the following... It sorts fine, but I wanted the numbers to be ascending: False. When I change this, it takes ...
0
votes
0answers
13 views
Google Sheets [Script]: Add new row to the top when previous one is filled up [duplicate]
I have a spreadsheet where I record info by rows and it's troublesome to scroll down to type out in a new row.
I'm looking for a script to help me add new rows.
What happens is that row 2 is blank (...
0
votes
1answer
17 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
18 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
17 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
18 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
24 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 ...
1
vote
0answers
4 views
How can I use Google Apps script when advanced protection is on? [on hold]
I recently turned on advanced protection on my Google account. But today I found out that my scripts embedded in Google Sheets don't run anymore, because they are denied access (Error 400). Does ...
0
votes
1answer
47 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:
...
0
votes
2answers
22 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
17 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
33 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
38 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
33 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
15 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
35 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
45 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
43 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
23 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
23 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 ...
0
votes
1answer
30 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
21 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
35 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
46 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
23 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
16 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
22 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
52 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 ...
