Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
0
votes
2answers
12 views

Auto Sort different ranges

I have a google sheet that I would like to sort different ranges by the 2nd column in each range. Example: A B C D E F G p 7 1 h 9 1 q 6 2 j 3 2 g 9 3 p 7 3 I need the range A:C sorted by B ...
0
votes
1answer
36 views

Changing a cell value based on another cell's color?

In my Google Sheets in column F, I want to include the word "LATER" based on magenta color (#ff00ff) that is in column B starting from row 227, how should I write this script? I'll really appreciate ...
0
votes
1answer
20 views

Pull unique values from other sheets as new sheets keep getting added

I'm trying to get a unique list of values in a master sheet based on a list of values that appear in column A of other sheets. The tricky part is that every time a new column is added in the master ...
0
votes
1answer
35 views

How to remove leading spaces from all lines in a Google Doc?

What is an easy way to remove all leading spaces from lines in a Google Doc? E.g. if copy-pasting a large amount of text that has been indented with spaces, such as Lorem ipsum dolor sit amet, ...
0
votes
1answer
26 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
41 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
21 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
2answers
33 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
29 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
1answer
73 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
41 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
56 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
30 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
463 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 ...
1
vote
2answers
193 views

Is there a way to allow users to access Google Sheets with installable triggers without manually signing in?

I have set up a Google Apps Script that validates data that is entered into various Google Sheets files. I am looking for a way to allow users to access those Google Sheets files without making them ...
0
votes
1answer
34 views

Google Side bar & editing form responses [closed]

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
1answer
60 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
32 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
35 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
14 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
1answer
38 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
23 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
66 views

Splitting the contents of a comma separated cell into new rows [duplicate]

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
28 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
12 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 ...
0
votes
1answer
71 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
369 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
12 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
49 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
23 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
22 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
57 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
21 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
11 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
85 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
20 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
24 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
20 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
311 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
44 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
20 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
69 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
19 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
43 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....
-1
votes
1answer
20 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 ...
0
votes
0answers
25 views

No HTML file named CreatorNotification was found. (line 241, file “Code”)

I keep getting emails with the following: Error Message /Trigger respondToFormSubmit No HTML file named CreatorNotification was found. (line 241, file "Code") /formSubmit I don't know what ...
0
votes
2answers
256 views

ImportXML not loading due to number of requests

I am working on this sheet and it has a lot of ImportXML requests between columns N-Q. And because of the high number of requests, it seems like the ImportXML function is not working properly (it ...