Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
1,143
questions
0
votes
1answer
5 views
How To Create a Globally Accessible Apps Script for Docs and Sheets?
I've been wanting to create a script that is accessible from any newly created Google Doc or Google Sheet. Is there any way to accomplish this? For example, if I wanted to create a script that ...
0
votes
0answers
9 views
Send multiple emails with the help of Google Script while using different attachments
I have a Google Spreadsheet with a list of emails. I want to build a routine that send email automatically to those email addresses. I also want to attach different PDF/xlsx to this email as per the ...
0
votes
0answers
8 views
Auto forward Gmail from original sender
I have created an GSuite App script from an old post on here. This works great and forwards the email to an email Dropbox in my CRM (Workbooks). When done manually the email sends and the CRM ...
0
votes
1answer
16 views
How can I set this up to run two onedit functions in the same sheet?
all
If you put the two together they don't work
What is the right code to work together
Note that the first to arrange automatic
The second is to set the date if you put only one works, but if you ...
0
votes
0answers
5 views
Google Calendar: Remove yourself from an event you were invited to
I've been invited to a calendar event and accepted it. The event is set to repeat indefinitely. I want to end my invitation after a certain set date.
If I change the end date from the event settings,...
0
votes
0answers
16 views
G Suite work collector for shared drives [on hold]
I'm trying to publish a web app that will allow external users without a Google Account to upload files to a shared drive within G Suite.
Can someone help modify this code to upload files to a shared ...
0
votes
0answers
12 views
Time based trigger - Google sheets
I have come across this code for a side bar, and its pretty neat. If I click a cell, the sidebar updates with the records.
Which bit of the code is doing this?
(Theres 4 files on below link and ...
-1
votes
0answers
27 views
Google Script to find last sent/received email timestamp from Gmail [closed]
ISO Google Sheets Script to
Use Sheets' Email Column to search my Gmail,
Find the last Sent message to that email and add it to "Sent Timestamp Column"
Find the last Received message from that ...
0
votes
1answer
22 views
Syncing Google Sheets to Google Calendar
Automatically add a schedule from Google Sheets into Calendar
I followed the instructions in this video:
https://www.youtube.com/watch?v=MOggwSls7xQ
and it works fine. However, the one thing that ...
0
votes
2answers
32 views
Chronological ordering of checkbox in Google Forms
I have a checkbox in my Google Form, which sends the user selections in the form in an ascending order list:
But I want to grab the list in the order of selection, for example if the user clicks in ...
1
vote
2answers
37 views
Issues with Google Script on collecting Form responses and moving to another sheet
I have been trying to piece together some code for a task at work using Google Sheets and I am having some issues with what I can find versus my current knowledge level. I am trying to create a script ...
-1
votes
1answer
21 views
Google Spreadsheet Trigger which will fire when the active selection changes for a given sheet
This would be equivalent to the Excel Worksheet_SelectionChange event.
1
vote
1answer
58 views
Send a Google Forms response to specific email address based on form response
I need to send Google Forms responses to specific clinicians at my practice depending on whether they have been selected on a drop-down menu in the form. At the moment, Google Forms sends an email to ...
0
votes
0answers
9 views
Failed to load TEX extension from http source [migrated]
I'm deploying a Google web app to write commutative diagrams with LaTeX/Xy-pic.
In the heading of html page I put the following configuration:
<script type="text/x-mathjax-config">
MathJax.Hub....
0
votes
1answer
29 views
Google Side bar & editing form responses [on hold]
I have some code which captures the URL of the edit response, so you can click it, and amend the record if needed. It pops out and opens in a new window. I wondered if it was possible to open it ...
2
votes
0answers
35 views
Opening Google Sheets to A Certain Cell or Column
I am trying to make it so when anyone who is in this weekly calendar opens the doc, it locks to the week we are currently in.
Our dates are in row 4, going across the top of the doc and run from June ...
1
vote
1answer
28 views
Offset called JSON into the next column
I am trying to check for emails based on domain names stored in a column in Google Sheets. I have the API call setup and working, but the data gets pasted into the selected cell. I would like to paste ...
1
vote
0answers
15 views
How to search within an Array to a range in Google sheets and setFontColor to blue [closed]
Don't know why this is puzzling me but I want to search for all parts listed within the primeparts array shown below and find them in a table then color the text blue.
So to clarify, using the partial ...
-1
votes
1answer
22 views
Find and Replace (CTRL+H) script on Google Sheets
I'm looking for a "find and replace" script for Google Sheets.
I have phone numbers on column C, which are in a ###-####### format.
I want to make a script that will replace the "-" to nothing.
...
0
votes
1answer
12 views
Is there a way to sort my Google Script project triggers, on the console?
My console currently looks like this, and I expect the number of triggers to increase:
screencap of my GSuite Developer Hub's project triggers console
I name most of my projects in a standard manner,...
0
votes
0answers
11 views
TypeError: Cannot read property “audits” from undefined [migrated]
I cannot seem to figure this out. I can run this script to pull in Pagespeed Insights some times, but lately I've been getting this error "TypeError: Cannot read property "audits" from undefined." I ...
0
votes
1answer
26 views
Help needed with script that auto-updates cells in column in Google Spreadsheet showing last modify date
I'm looking for some help with a script for a spreadsheet.
I found a script (see below) that does half the trick for me, but I encounter two difficulties.
What I am trying to accomplish is the ...
0
votes
0answers
14 views
Pasting values depending what column cell is in
Afternoon, I have this script where if I press delete, or edit, it takes the value and puts it in A6. Now I'm wondering how I make it so that if the cell value is from column A, it puts it in A6, but ...
1
vote
0answers
22 views
Google sheets script add data in next column
I'm trying to modify a script to create a PageSpeed report that pulls in certain KPI's from Google Pagespeed API. Once the data is received, i want it to place those KPI's next to the URL and so forth....
0
votes
1answer
43 views
Splitting the contents of a comma separated cell into new rows
Based on: https://stackoverflow.com/questions/52376162/combining-column-data-in-google-data-studio
I have a long list of data, about 200 rows, and each row contains multiple columns of data and a ...
0
votes
0answers
21 views
How to record a user's e-mail when they click a button in Google sheets?
I am new to Google sheets and scripting. I've seen samples of scripts here that allows recording of the current user's email when they make an amendment in a sheet.
Is there a way for me to click a ...
1
vote
0answers
11 views
Creating auto-updating indexed links to tab in spreadsheet
This spreadsheet is a lesson planner for teachers. It will be used by a wide variety of teachers with varying tech skills so it needs to be straightforward and not easily messed up.
The first sheet ...
1
vote
0answers
9 views
How do I change the text of a shape drawing using Google Scripts? [closed]
How can I change the text within a rectangle for example embedded in a Google Sheets, using automation, that means, Google App Script?
-3
votes
0answers
30 views
Google form to spreadsheet then to calendar
i need to create a form that insert in a google calendar yearly recurrent event. I connect the form to a spreadsheet. I have just 3 data. The day of the event, the description and the name.
I tried to ...
0
votes
1answer
28 views
Need to get a list of Drive files several subfolders deep
I need to get a list of all the files in my Drive with all of the nested folder names where the files reside.
I found this very helpful answer which is almost exactly what I need:
Get a list of ...
0
votes
2answers
50 views
How to wait for Google Spreadsheet calculations to update before retrieving cell data in Apps Script web app?
I am creating a Google Apps Script web app that uses Google Sheets as its backend. This web app basically allows users to track their work time (clock in for the day, clock out for lunch, clock in ...
0
votes
1answer
9 views
Custom side menu question & active sheet
I am trying to create a custom side menu that changes depending on what sheet I am on so the side menu is relevant to what I am on.
I've attempted doing some code to do a tactic where depending on ...
0
votes
1answer
19 views
Have script ignore first row [duplicate]
I am using this script to add in a date whenever a row is edited. I want it to ignore the first row. Thoughts on how to do this?
function onEdit() {
var s = SpreadsheetApp.getActiveSheet(); // ...
1
vote
0answers
18 views
Numbered list with Cyrillic letters
In Google Docs, I would like to have a numbered list using Cyrillic letters, such as:
а
б
в
г
д
The regular choices for numbered lists offer the options of Arabic numerals, Latin lowercase,...
0
votes
0answers
15 views
Convert Non google URL image links in a Google Document with actual images
I am trying to do something very similar to another thread (Convert all links to images in a Google Document with actual images) but with non google stored URL links.
DriveApp only works for google, ...
0
votes
1answer
37 views
Unable to change Google Sheets data point format without changing other data points
I am trying to ensure that each bar in a horizontal bar chart in Google Sheets has its own unique color. Conventional wisdom seems to entail either
select the chart --> left-click on the bar -->...
0
votes
1answer
14 views
Sending email form Google Sheet Issue
I took this script from the Google developer site and modified it to suit my needs. The issue i am having is where the "EMAIL-SENT" lands on my sheet.
I need it to be placed on the 4th column right ...
0
votes
0answers
10 views
In Google Sheets script how do you email a date in a cell and control how it looks in email?
I'm building a Sheets Script add-on for sending invoices. In my sheet, I have a chart with the dates written along a row. When I use the MailApp.sendEmail() the date is printed in the email ...
0
votes
3answers
66 views
Trying to run two scripts on same sheet and getting error
I found a code to run the two different scripts online, however i keep getting an error
Missing ; before statement.
Original
function onEdit(e) {
oneditfx1(e);
oneditfx2();
}
function ...
0
votes
0answers
15 views
Code to automatically duplicate a google spreadsheet
I want to automatically create a copy of an existing google spreadsheet that will have a name taken from a list. So when I add a name to that list the file will automatically duplicate with a specific ...
0
votes
0answers
17 views
How to move a row to another sheet based on date value
I want to move row to another tab based on date value. i.e. if the data is 90 days older from today the row should automatically transferred to another tab.
Sample Sheet: https://docs.google.com/...
0
votes
0answers
15 views
dropdown values from different sheet/spreadsheet
I have been following the tutorials of Learn Google Spreadsheets and are stuck with the following.
In my HTML file, I have got a select/dropdown menu that gets the values from a spreadsheet. That's ...
0
votes
1answer
45 views
How to reference a dynamic range in Google Sheets Script?
I have a sheet where the filter originally started on row 2, so my range was A2:J. As I've added and deleted rows/columns, my range has changed and it's still changing as I edit the sheet.
Is there ...
0
votes
1answer
32 views
Cut and paste data from a row of cells from one tab to another tab in Google Sheets and repeat with new data
The below code works for Q3 but not for Q5. I'm relatively new to sheets and writing code and I'm sure that you can't have two functions with the same name but am unsure how to resolve so that I can ...
1
vote
0answers
16 views
How can I send an email, with an attachment from the user's local storage, using Google Sheets Script?
I'm new to Google Script but quite experienced in Excel VBA. I'm trying to set up a Google Sheet to enable sending of a given document by email attachment to a number of recipients.
I've got the email ...
-1
votes
2answers
15 views
How to archive cell changes in new tab?
I have a Google sheet that I'm collecting some statistics in. There is a particular cell that I'd like to track changes in a separate tab. I'm looking for a function to copy cell if the cell data ...
0
votes
1answer
19 views
Google sheets IF OR script
So this is the code that I'm using for the script that I found;
function onOpen() {
var s = SpreadsheetApp.getActive().getSheetByName('Todo');
s.showRows(1, s.getMaxRows());
s.getRange('D:D')
...
0
votes
0answers
13 views
How to getFullName()
I would Like a code example how I can get getFullName(), in Google Sheets.
Basically, I have multiple users using Google Sheets and would want that every time they edit I cell in the Sheet, there ...
0
votes
0answers
25 views
Function GetRange not found in Google App Script
function importCSVFromGoogleDrive() {
var file = DriveApp.getFilesByName("data.csv").next();
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
var sheet = SpreadsheetApp....
0
votes
1answer
18 views
Which event can I use to detect remote form submission into sheet?
I'm using the WordPress Contact Form 7 plugin as a website contact form. The user's date is submitted to a google spreadsheet and stored as a new row.
Which event can detect that that information was ...
