Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
1,613
questions
0
votes
0answers
12 views
How do I change textStyle of labels in radar chart?
I'm making a radar chart using Google Apps Script and I don't know how to change the font size of the "labels" (see the picture). So far I've tried hAxis, ticks, legend and none of them ...
0
votes
1answer
11 views
Type error: cannot read property getid of null in google script
When I run this script it show me this error. I can't understand what I do. Its function is to transfer results from html form to Google Sheet. Can anyone solve this problem?
var sheetName = 'Sheet1'
...
0
votes
1answer
14 views
Avoid keeping adding numbers in headings in Google Docs
I am using a modified version taken from this useful answer to get numbers in my Google Docs Header 2:
function myFunction() {
var pars = DocumentApp.getActiveDocument().getParagraphs();
var ...
1
vote
1answer
11 views
Activating cell after button click (remove focus from the button)
I have a sheet with one button (a shape) which is associated with an Apps Script function.
When I click the button it inserts a row and activates a cell in that row.
Then if I try typing, nothing ...
0
votes
1answer
17 views
Auto add a row based off a check box
I'm a new user to Sheets! I'm reaching out for help on a problem that I have with trying to create row. I've read a ton of blogs, and watched more Youtube videos than I care to admit without finding a ...
-1
votes
0answers
5 views
Old chat lost recovery options pls [closed]
Actually my old phone screen got broked so that. Am using another phone with same number but am afraid to say am unable to have my previous chat back in my other phone what to do any suggestions
-1
votes
1answer
25 views
Google Sheets clearing every other cell with a script
I have a sheet that have formulas on column B at every other Row starting from B3, so it's B3, B5 and up to B101, I have the following script to clear the rest of the sheet except for column B, How ...
0
votes
1answer
5 views
Need help editing Google Scripts for multiple sheets in workbook
I am attempting to use this script to choose multiple selections in 1 cell for data validation in google sheets. I cannot get the script to work on the 200+ sheets within the workbook. Is there a way ...
0
votes
1answer
20 views
Apply simple script to specific tabs in a Google Sheet (I know zero code)
I would like to run the following script to all but the last tab in a Google Sheet:
function ClearAll() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheetname = 'ScriptTest';
var ...
2
votes
1answer
60 views
How to pass multiple comma separated values in a cell to a custom function?
Suppose, there are values such as 1,A, 2,B, 3,D in certain cells. My intention is to add 1,2,3 (LHS) separately and A,B,D (RHS) separately. To achieve that, I have written certain custom function in &...
0
votes
1answer
10 views
Exporting Google Sheet to PDF
I'm trying to export the current active Google Sheet to a PDF. The below nearly does what I want but I would like a few changes.
Changes.
Save the PDF in the same folder as the main spreadsheet ...
-2
votes
0answers
21 views
Have to get access to my database
Here is the I got: Error linking spreadsheets. Make sure you have access to the sheet you're trying to import from.
Have can I have access to my DAtaBase spreadsheet. I am importing my contacts to my ...
0
votes
1answer
18 views
Combining Separate Scripts into One
I've been trying to figure out a solution to this for a few weeks & I think I'm at the home stretch, but having some trouble piecing it together. With great help, I have a script (below) that ...
-1
votes
1answer
32 views
vlookup and paste in App Script?
Not sure if this is even possible, but would anyone know if theres a way of using app script to move cell data to a specified area. Sort of a reverse Vlookup?
I want it to send a cell's data to an ...
0
votes
1answer
18 views
How to emulate behavior or cmd + down arrow in Google Sheets Macros?
If there is a column of 10 full cells in a row, and you go to the top of the column and hit command + down arrow, it activates the lowest non-empty cell.
I tried to record a macro while using cmd + ...
0
votes
1answer
36 views
ImportHTML Script at Bulk
With great help, this script is working to pull in the 2nd table on the below link. The table cannot be scraped with IMPORTHTML unlike the first table (Regular Season works, Playoffs doesn't).
https:/...
0
votes
1answer
35 views
Google Sheets Entries into Google Calendar in same date
I am trying to create full day event in google calendar using google sheet. I have used the following script and it is working fine with my sheet but it has added event in the previous date:
// ...
0
votes
2answers
21 views
How does Google Slides identify "title slides"
When adding slide numbers to a Google Slides deck, there is an option to "skip title slides." When I choose this option, the numbers stay only on my title slides and disappear from my ...
0
votes
1answer
31 views
Google script to getValue AND keep formatting (not just text)
I'm writing a gmailApp script that looks at a spreadsheet and will send some emails out based on a sheet of names and emails. I'm trying to make it as user-friendly as possible. I'm aware I can use ...
0
votes
0answers
18 views
Timestamp on change google sheets 3rd party data entry
i have been looking for a way to timestamp my google sheet,
its working if i edit the cell and it work great exactly how i want it, however.
im not the on editing the sheet, its through a 3rd party ...
0
votes
1answer
22 views
Clear cells script
So I have a google sheet document which houses figured for each hour of the day from 6 - 16:00 (each hour in a different tab.
I’m looking to add a script and a button that will allow me to clear all ...
0
votes
1answer
22 views
How to identify specific data in a column in AppScript
I'm doing my first App Scripts and I'm able to have them working... but I remain dependant on some Sheets formulas to identify data. This impacts the speed of my script dramatically.
As a basic ...
0
votes
1answer
18 views
Multiple functions updating datetime stamp in multiple cells [duplicate]
I am trying to update multiple cells based on input in each. The first works fine with a specific text from dropdown but I get no results on the other remaining 3. Here is the script I have:
function ...
0
votes
1answer
30 views
Where it goes the paper size information in a script
I'm using this scrip to save to pdf but I need to make it Size A5 and Landscape Orientated
I have found some parameters but I don't know how to combine
function checkSheet() {
var sheetName = "OS&...
1
vote
1answer
37 views
Check Google script quota usage in real time
I'd like to have stats on my quota usage for google scripts (those accessible from https://script.google.com/)
Since there are a lot of quota enforcements (see https://developers.google.com/apps-...
0
votes
1answer
25 views
Counting repetition with associated quantity
I would like to count the number of times my products are sold.
I tried COUNTIF, but it does not take into account the quantity associated obviously.
In the columns E G I I have the number of products ...
2
votes
1answer
73 views
Gmail bulk Emails manipulation
I am trying to deal with 600,000+ emails in inbox, my goal is to either delete or archive emails before 1/1/2021.
Doing a search and select all search results and then delete or archive as most people ...
0
votes
1answer
32 views
How to run a function everyday at 11 PM?
Currently the function runs every day at 11pm but it runs twice. I'm only needing it to run once though.
function functionsToRun ()
{
appendValues();
clearCells();
addZeros();
}
function ...
0
votes
0answers
45 views
Convert input text into duration values with script on Google Sheets
I'm setting up a sheet to help coworkers keep track of their appointments. For now the only way to get those times is to copy-paste the numbers from a different program used to track the info. The ...
0
votes
1answer
20 views
How to use / refer to a named range when defining another named range in a Google Apps Script?
I have the following script in a Google Sheet Apps Script macro. It is meant to identify & delete a range of rows on a sheet. This was created by originally recording a macro & then attempting ...
0
votes
2answers
23 views
Google Sheets - QUERY - SUM() based on empty column
I need to obtain the sum(B) if the column has empty values I want to reflect 0.
I am automating this process for multiple sheets using app-script and need to use QUERY.
Any suggestions?
0
votes
1answer
41 views
Calling MailApp.sendEmail from a time-triggered script fails due to insufficient permissions. How to fix this?
My sheet runs some calculations on a chart of numbers which updates automatically from a time-driven script. Within that script I put at its very end a function which compares two of the resulting ...
-1
votes
1answer
20 views
Script to Automatically Email Every Morning
I have a Google Form which links to a Google Sheet "Form responses 3". Crew have to check in to our job sites each day and I want to write a script to automatically email our supervisors ...
0
votes
0answers
35 views
Google Apps Script "Range not found" error
function _1() {
var spreadsheet = SpreadsheetApp.getActive();
var numSheets = SpreadsheetApp.getActiveSpreadsheet().getSheets().length
var s1 = numSheets-1
var s2 = numSheets-2
spreadsheet....
0
votes
0answers
41 views
How to fix "Limit Exceeded: Email Total Attachments Size" with Google App script?
I've been running this amazing script (provided in full, below) with great success (thanks to user tedinoz!) but have recently been getting an error that reads "Exception: Limit Exceeded: Email ...
0
votes
1answer
169 views
Loop with dates "don't match the method signature for Utilities.formatDate"
My internet research was vain.
Getting the range of dates & comparing them with today's date. After running the script #1 below I receive Exception: The parameters (String,String,String) don't ...
0
votes
1answer
40 views
How to freeze Google Sheet columns based on date
I am using Google Sheets, and my columns are set up for each month (Jan, Feb, March, etc). I have several rows that are pulling data from other tabs in the sheet to create an at a glance master list. ...
0
votes
2answers
84 views
Preventing Google Sheets from refreshing a custom formula when opening the spreadsheet?
I'll begin with the specific question:
Is it possible to stop function-containing cell from autorefreshing on open?
Or perhaps is it possible to apply a function (which itself calls other functions ...
0
votes
1answer
76 views
Google Sheets copy & paste special values script
I use Google Sheets as our main tool to dispatch construction trucks and communicate with our scale clerks the "who and what they will be picking up". I have researched for days on numerous ...
0
votes
1answer
36 views
Extract Data from 2 columns if it matches condition
This is how my main data sheet looks like
And for any item that has customization, for e.g. - ORGANIC, I want to extract/copy just those data, the meal name & total units to another sheet.
And ...
2
votes
2answers
51 views
How to insert timestamp when using either of the Fill Color tool or the Paint Format tool
I have been using the code below to insert a timestamp in column L when a cell fill color in column C is changed to white.
The code is working well, but while it works when I choose the white color ...
0
votes
2answers
80 views
Insert timestamp when cell background color is changed
I have been using this below code which was working perfectly:
function colorChangeCheck(e) {
var sh = SpreadsheetApp.getActive().getActiveSheet();
var color = sh.getActiveRange().getBackground();...
0
votes
0answers
33 views
Locking Google Sheet Cells Monthly
I am using Google Sheets, and my columns are set up for each month (Jan, Feb, March, etc). I have several rows that are pulling data from other tabs in the sheet to create an at a glance master list. ...
0
votes
1answer
19 views
Google sheet: run a script via the share link (without login)
There is a script for my Google spreadsheet so that every change in a cell is indicated by a red color marker. When users with a Google account that I have shared to the spreadsheet make changes, the ...
-1
votes
1answer
32 views
QueryByName() function from another sheet in google spreadsheet
Is it possible to use the QueryByName() function using another sheet from the same spreadsheet?
=query(nor9609s!A1:Z500,querybyname(A1:Z1,"SELECT `Items_shopid` WHERE `Items_id`>0"))
I ...
0
votes
1answer
25 views
Is it possible to write a script that automatically triggers some function within a Google Sheets add-on?
I'm using some Google Sheets add-on which pulls information from API databases, and it has both a free subscription and paid subscriptions which add many additional abilities which I don't really need,...
0
votes
1answer
63 views
Getting "Exceeded maximum execution time (line 0)" error with custom code when data input increased in "History" sheet
I have a google sheet wherein there are 2 sheets named "Position" and "History" respectively.
I have a custom function that takes data in the "History" sheet and arrange ...
0
votes
2answers
23 views
Assign a default name if the cell value is null
I have a booking form, shown.
I also have a template form, hidden.
This script is assigned to a button to create completed bookings by copying the booking form data to a copy of the template and again ...
0
votes
1answer
16 views
How to enable macros
Looking for some insight. In Google Sheets I added a series of buttons linked to macros. Works just fine for me and another user. Other users are telling me that they click the button and nothing ...
0
votes
1answer
31 views
Update a sheet row by matching a value from another sheet
I'm new to App Script and I'm trying to update an existing row by matching value coming from another sheet. Basically record all the data from the "receipt" to the "record" by ...
