Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
0
votes
0answers
9 views
Use script to populate one sheet from data of another sheet
I have a problem with writing a script to input data from one sheet to another.
Here is what I have:
In sheet1 I have a list of products with a unique number in column A.
In sheet2 I want to be able ...
0
votes
0answers
7 views
Horizontal Scrolling Loop Macro for Google Sheets
I am looking to see if it’s possible to have a macro that would scroll a Google sheet to the end at a certain speed, and then once at the end, jump to the beginning and begin again. We are trying to ...
-1
votes
1answer
19 views
Unprotect ranges
I am trying to create a script to protect my formulas in sheets that co-workers will use. I have 10 workbooks with 26 sheets each, all are virtually identical as far as the the locations of the ...
0
votes
1answer
19 views
Google script app delay without freezing spreadsheet calculation
How can I have delay on Google Script App function without freezing the spreadsheet calculation.
sleep function freezing all spreadsheet calculation, and I have many calculation on the spreadsheet ...
0
votes
2answers
12 views
Duplicating sheets with simple date from a named range
when i run the script to duplicate sheets with a date is give the tab a long date name Thu Oct 18 2018 00:00:00 GMT-0400 (EDT) . I would like it to read in a 10/18/18 format
0
votes
1answer
22 views
Is it possible to calculate in the background of a data validation cell?
Is it possible to calculate in the background of a data validation cell?
I am creating a quite comprehensive spreadsheet that shall help me calculate dice pools in an RPG, but to not trouble you with ...
1
vote
0answers
12 views
getUi.prompt - How to enable confirmation with “Enter” key
When using SpreadsheetApp.getUi().prompt();, how do I allow the user to simply press Enter to confirm their entry instead of having to click on OK?
0
votes
1answer
33 views
How to make Google Sheets jump to closest date to today when opened?
I have a Google sheet containing a list of events, with event dates listed in one column. I'd like to have my Google Sheets spreadsheet jump to the closest date to today's date on opening (i.e., ...
0
votes
0answers
12 views
Google App Script start new Hangout Chat
I am looking for help leveraging a Google Script that starts a Hangout Chat session when a script is started in a Google Sheet. Ideally, I get the URL and enter it into the Sheet itself.
Flow of ...
-2
votes
0answers
21 views
Google Apps Script for moving data from another sheet to current on the basis of input matching value
I have two sheets :
Sheet1 & Sheet2
In Sheet 1 I have columns
Pull Email | | Name | Email | Status
In Sheet2 I have :
Name | Email | Status
a | ...
0
votes
1answer
29 views
Get a list of Drive files into a spreadsheet
I am playing around with AwesomeTable and like the Post-It template. My use case is to curate a nice interface to a list of frequently used files. The list won't change dramatically over time, but ...
0
votes
1answer
31 views
How do you delete certain cells before copying?
I want to copy IDs and dates and have written this script so far.
function copy(){
var s1=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
var s2=SpreadsheetApp....
0
votes
1answer
24 views
Exporting Google SpreadSheet to PDF (filename referring to a cell D7)
I have developed a script which allows me to export a spreadsheet to a pdf file with a click of a button. I have assigned the script to a macro so that it is triggered by clicking on an image.
Script ...
0
votes
0answers
22 views
Hide operation from user Google Sheet
I have a report file get the content from other files in a Google Drive to generate a report. The script to collect and generate data sheets and report sheets run when the sheet open. I do not want ...
0
votes
0answers
14 views
Google sheets script copying formatting *but not* merged cell status
I would like to write a script that copies the formatting, and the conditional formatting, that is applied to cell A1, and applies it to all of the other cells in the sheet.
However, I do not want ...
0
votes
0answers
7 views
Google Dataflow jobs monitor, embed in Google site/website
Is it feasible to embed Google dataflow in Google site or any other website? I noticed that Google dataflow supports Python and Java and there is a lot of documentation.
I am using javascript/google ...
0
votes
0answers
15 views
Mail Google Sheet as Excel table with script
I want to mail Google Spreadsheet as excel attachment, and I also want to multiple people to look in (To. & CC), And also I want to write some message in the body. I have the script and when I use ...
0
votes
0answers
44 views
How to create a timestamp based on multiple cells' values?
I've referred to this example from 2017 but need a modification: it works but I'd like to modify it so 1) a date is NOT automatically populated without the cell 2) being populated with specfic text "...
0
votes
1answer
37 views
How to extract a link URL from one word within a paragraph element in Google Docs with Google Apps Script
I'm trying to pull the URL of a hyperlinked word from within a paragraph element in a Google Document using Google Apps Script. Below are two GAS functions. The 1st doesn't work. The hyperlink is only ...
0
votes
0answers
11 views
Random PIN for each entry on a Sheet
There's a list of people that could change in size from time to time. I have a column that I want to contain a unique 5-digit PIN for each person on the list. I want to write a script that will create ...
0
votes
0answers
43 views
Is there a way to just pull out all of a certain index without going through the results and rebuilding a 2nd temp array?
I've got multiple sheets with anywhere from 500 - 10,000 rows each that I need to find specific values in a given column. Ex. Sheet A, B, C have information about a bunch of products. I search for ...
1
vote
1answer
48 views
How do I insert an image from Google Drive into email body with script
Could anyone help me?
I've created a Google Form that uploads a file (image) to a private drive folder, the form also sends responses to a Google Sheet including the image's URL. The code below gets ...
0
votes
0answers
68 views
extract a text between an HTML tag specified by a class in google script
I'm using below function to avoid using importxml in Google Sheets:
function importRegex(url, regex_string) {
var html, content = '';
var response = UrlFetchApp.fetch(url);
if (response) {
...
0
votes
0answers
68 views
Duplicate sheet but keep protected range with exact same user as only editor?
The following code duplicates a sheet based on a template, and copies over the protected range permissions from the template sheet to the new sheet.
However, the permission range is now there in the ...
0
votes
1answer
42 views
copyTo is failing to copy data
I have a pretty simple problem that is for some reason killing me. I have the following script which should just autofill a formula down column O, then copy the values to column P (excuse my amateur ...
0
votes
0answers
14 views
How to show a popup instead of an html file that returns from doPost() function in Google Apps Script
I work on a Google Apps Script project deployed as a web app that sends an HTML form and some data - submitted from a Google Form - to an email so I want when someone submits this form a popup shows ...
0
votes
0answers
19 views
Script for creating weekly tabs from a due time interval
I'm a newbie for both scripting and Google scripts. I basically need to create a sort of timetable on a Google Spreadsheet in which every tab is a week, always starting by Monday, in a due interval ...
0
votes
0answers
25 views
How a Google Apps Script project can handle many triggers like OnFormSubmit for many forms?
I work on a project that uses Google Apps Script to handle some workflow so instead of typing a script for every form created in the future, I want to write one script that can handle many triggers ...
0
votes
0answers
26 views
Help implementing custom canned response code in Google Script
This is a follow-up question to this one:
Is there a way to avoid "+canned.response" in the email address using Gmail's canned response feature
I was very encouraged by Jacob's code and ...
0
votes
1answer
72 views
Send email when theres a change in a particular column on a particular sheet
I want an email to be sent when a cell is changed from "No" to "Yes" in column C from a particular sheet - sheet1.
The email body would need to include information from cells in columns D,E,F,G,H,I,...
0
votes
0answers
52 views
One Google Form Response into multiple rows
I'm having a problem, which I've seen resolved via a script. I have a Google Form that accepts multiple checkbox responses in one submission. On my end, the responses come up on one row separated by ...
0
votes
0answers
21 views
Script to duplicate rows but continue formulas
I feel like my script is close to the goal, yet so far.
I'd like to take the current row that the user is clicked on, and then insert multiple new rows below the current row, but also continue the ...
0
votes
0answers
22 views
Change color of query-filled cell via script based on cell content
I used the following script proposed in a different question (How can I change the background color of a cell based on the cell contents using a color lookup sheet?) to change the background and font ...
1
vote
0answers
47 views
Google Apps Script - how to hide run message
I have a question about running apps script on a Google Sheet.
I have a few scripts written that can apply a filter and remove a filter.
When I run the script from the button on the spreadsheet the ...
0
votes
0answers
43 views
Update Cell If another cell is not empty - Google Script
There are two columns N and O.
When any cell in column N is filled the adjoining cell in column O needs to filled with "Yes" if not it stays empty.
This is the script I'm using.
var s = ...
0
votes
0answers
20 views
Automated forwarding of an email in Google Apps Script
Good day.
I have an email account which is not a Gmail one but is added as an alias to a Gmail account. Based on that, I have the following 2 questions:
How can one listen for incoming emails (to ...
1
vote
1answer
109 views
Question about the importrange function in Google Sheets
Not sure if this has been answered else ware but, I'm trying to use the importrange function in Sheets to import a list of dates from spreadsheet A to spreadsheet B. That part works fine, however, if ...
-2
votes
1answer
556 views
Which is better: onEdit or onChange trigger? [closed]
From what I've gathered online, onEdit only works when you edit a cell (not when a row is added or when a note/comment is added). onChange will capture that a change has occurred and trigger when ...
1
vote
1answer
114 views
Colors in conditional formatting based on cell hex values
I am looking for a solution to change background and font color of a cell based on hex-values in another cell.
I am managing a google spreadsheet for an online basketball league. I have several ...
1
vote
0answers
62 views
Sync Google Spreadsheet to Google Calendar (remove any duplicates)
I'm trying to sync my Google sheet to my Google Calendar. However, I keep running into errors. I've tried a myriad of scripts, but none seem to work. I got one to work, but every time I ran the script,...
0
votes
0answers
27 views
How to automate Gmail response, different first and second response?
I am seeking help to automate the Gmail response to new community members in an apartment complex.
First, new members send/email us a new membership, including name, i.e. request as a new ...
0
votes
0answers
17 views
Copy a sheet, automatically move it to the front and rename based on the previous sheet
I have a daily cashing-up spreadsheet where each day has a sheet using the date format YYYYMMDD (e.g. today is 20180808. I want to automatically copy a sheet, move it to the front (leftmost sheet) ...
0
votes
1answer
28 views
Calculating Ranks in Google Sheets
I have a spreadsheet that has three tabs:
The first tab is raw data imported from a website. it's about 10 columns and up to 300 rows. it has a mix of numbers in decimal form and percent. it all ...
1
vote
2answers
96 views
Add border to whole row if cell in column D is not empty
I was researching how to "Add a border to the whole row if a cell in column D is not empty" - I've found similar script but I failed to edit it to my need!
Below is the script I found - I already ...
1
vote
2answers
59 views
Auto-create/name new Google spreadsheets for names in column list [closed]
How do I auto-create multiple spreadsheets from a list of names contained in separate rows in a 'master/template' spreadsheet (up to 50 names, if possible)?
I think I am looking for a script/code/...
0
votes
0answers
104 views
How to use Google Apps Script to create Google Calendar event from Google Sheets row
Is there a simple way to create a new Google calendar event from data in a Google Sheets row using Google Apps Script?
For example first column of row would be the title, second column the ...
0
votes
2answers
58 views
Display the name of a cell in a worksheet
Excel has a little box on the upper left corner that displays the name of the cell. Does Google Sheets have a similar capability? I've named cell B5 "hours" and cell B6 "hrlyrate" so I want to be able ...
-1
votes
1answer
44 views
One time check to see if document is shared with a specific user
I'm trying to figure out how to write an Apps Script that checks "IF" a Google Drive URL is shared with a specific user. I do not want this to be a continuous check, just a "one time check".
Example ...
2
votes
1answer
55 views
How can I automate Find & Replace (to change the colours of certain symbols) in Google Docs?
How can I automate find & replace, specifically to colour all suit symbols document wide?
I write bridge articles (card game), and I need to automate this formatting all the time:
Find all "♣" ...
-1
votes
1answer
41 views
2 time stamps in different cells I would like both of the scripts below to work at the same time [duplicate]
function onEdit(event)
{
var timezone = "GMT-7";
var timestamp_format = "MM-dd-yyyy-hh:mm"; // Timestamp Format.
var updateColName = "Ext Warehouse";
var timeStampColName = "Date/Time Change";...
