Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
-1
votes
3answers
248 views

How to run multiple OnEdit scripts in the same sheet?

I am using an auto-timestamp script in Google Sheets. Where when you input something in a particular cell, the script will automatically add a timestamp in a particular cell. But the problem is that I ...
0
votes
1answer
38 views

How to list total files for every subfolder in Google Drive?

On google drive I have a directory with over 1000 subfolders. I want to list all subfolders with the total amount of files for each subfolder. This is the script I got so far but it doesn't work cause ...
0
votes
0answers
7 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
1answer
394 views

Create triggers on recently programmatically copied Google Forms

I have this main Form that uses its responses to create several other Forms after it's been submitted, but I need that these Forms that were recently created to send emails on their submissions ...
1
vote
0answers
291 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
4 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
2answers
32 views

How to export CSV without commas in unpopulated cells?

I have a form converter which simply rearranges columns. I use a script to paste Values only into another sheet for export and uploading onto another website. However, when I go to export, it seems ...
1
vote
1answer
10k views

Cell last modified date & user stamp Google Sheets?

I want the cells of two columns in my Spreadsheet to auto-update with the date (m/d/y) and name of user when cells in a certain range are edited. For instance, Catherine goes to sheet on 3/6/2017 (...
0
votes
1answer
2k views

Horizontal sort in Google Sheets

I am a teacher and I store data from assessments in a Google Sheet. In the rows, I have student names and in the columns, the score they received from each question. I want to be able to sort by row (...
0
votes
1answer
140 views

Google Apps Script to automatically send email

I am trying to create a Google Apps Script that will send an email to our client's general inbox when we receive an email from one of their representatives containing an order. We are required by our ...
-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 ...
3
votes
1answer
715 views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
-1
votes
2answers
30 views

Empty cell reference when “Loading…”

I want to do a calculation with imported data from an HTML link. The data is imported every minute. There is loading time and this ensures that the cells are empty during loading. Because my formula ...
0
votes
1answer
57 views

Add row to Google Sheets and keep formulas from previous row

I want to add a row to my spreadsheet but keep the formulas – and only the formulas – of the previous row. The #1 solution provided here doesn't help me because it also copies non-formula information, ...
0
votes
1answer
348 views

Move rows on 2 sheets older than 24 hours to archive

I have been trying to figure this one out for a while now and would really appreciate some assistance. I have a Google Sheet that is being updated by a Google Form. Due to this I needed to mirror the ...
0
votes
2answers
29 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 ...
0
votes
0answers
15 views

G Suite work collector for shared drives

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 ...
3
votes
1answer
785 views

How to Modify Matched Cells Across Multiple Sheets with Google Script

My question is a fairly complex one, but I'll do my best to clarify exactly what I'd like to do and this requires some background: I have a Google Spreadsheet used for user administration in my ...
0
votes
1answer
2k views

How to move a row into another sheet?

In Google Sheets, I need to hide rows if column H says, "Completed" My preference would be to cut and copy the row to a new sheet if column F reads "Completed", but sounds more difficult. If you ...
1
vote
1answer
54 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
votes
0answers
25 views

Google Script to find last sent/received email timestamp from Gmail [on hold]

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
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 ...
0
votes
1answer
36 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 -->...
1
vote
2answers
36 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 ...
0
votes
1answer
20 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
1answer
27 views

Google Side bar & editing form responses

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 ...
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 ...
3
votes
1answer
1k views

Register your Apps Script application and retrieve the client ID and secret for oAuth dance

How do I register an Apps Script project and get the Client Secret for oAuth, and set the callback URL?
0
votes
2answers
68 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 ...
-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.
2
votes
1answer
866 views

Email notification if cell value goes below set amount

I'm having trouble finding a Google sheet script that does what I need so I figured I would ask if someone could help me. Basically I have a simple sheet setup to track inventory of one item. There is ...
0
votes
1answer
355 views

Why doesn't my onEdit Function behave the same as my onFormSubmit

With the excellent help of this site I was able to get my onFormSubmit working. However I need the same thing to happen on another sheet only it has to happen after a cell has been assigned one of two ...
3
votes
1answer
972 views

How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?

I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
0
votes
1answer
511 views

Google Script to set the current month once a day only in a cell

Currently, I'm using (Month(NOW()) to set the current month number in cell $D$1 of a spreadsheet. I know Month and Now are volatile functions and they're making the over sheet update way too slowly, ...
0
votes
2answers
55 views

inputBox in onEdit does not work for users

I have a strange problem... Simple function like: function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet() var sheet = ss.getActiveSheet() var ui = SpreadsheetApp.getUi() var response = ...
1
vote
1answer
107 views

Dynamic generation of sheet name from cell content (cell contents from importrange)

I have a list of names of the members of my group. Each member has a separate sheet that contains information on that member. When a new person joins the group, I input the name to the master list and ...
0
votes
1answer
63 views

App Script to move a row of data from one Google sheet to a different one (different sheet id's) based on a cell entry

I'm currently trying to adjust a script I found that copies the contents of a row from one tab of a google sheet, pastes it into the next descending empty row in a different tab and then deletes the ...
0
votes
2answers
29 views

Auto Create New Google Sheet With Column Headers Based on List of Names

I'm trying to create a VERY basic CRM tool. I want to create a running list of customer names. Once I enter a name in Column A I'd like a new Sheet automatically created with pre-set columns I can ...
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....
4
votes
1answer
1k views

Programmatically create an internal hyperlink

I need to programmatically create a large number of links in a Google Sheets that point to a specific range in another sheet of the same document. I tried to use named ranges for that but for the ...
2
votes
0answers
33 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 ...
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,...
1
vote
1answer
27 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 ...
2
votes
1answer
862 views

Put the timestamp of last edit on master sheet, next to edited sheet's name

I'm trying to come up with a script that will print a timestamp of the last edit made to a specific tab within a google sheet. Imagine you have 17 retail stores, each one having its own tab with a set ...
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. ...
-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 ...
1
vote
2answers
85 views

Querying if cells exist in an external Google Drive file

I have a huge list of names stored in Google Drive as a TXT file (constantly updated externally). Can I put a small list of names in a Google Sheet and see if any of them exist in the big external ...
0
votes
2answers
46 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
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 ...