Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
1,333
questions
0
votes
1answer
19 views
App Script to Random Range with 10 % of total data
I have a table with 20 rows of data.
I want to randomize the data with 10% of the total data.
The script I made is like this:
function shuffleSheet() {
var ss = SpreadsheetApp.getActiveSpreadsheet()...
0
votes
0answers
12 views
How to search for dangerous messages on GMail?
I am using a filter to prevent mails from getting moved to the spam folder, because I want to see them.
As a consequence some mails are correctly prefaced with:
This message was not sent to Spam ...
0
votes
0answers
20 views
How to link a script that I made on my PC browser to work on my mobile app
I have made a script, with thanks to Tedinoz on here.
I have now also created a button using drawing and adding the script to it
That button shows on my mobile app but when I press it I only get a ...
-1
votes
0answers
29 views
Count if in Google script
How to Calculate the number of occurrences of products in order from top to bottom (C column)?
How is it possible to write a simple script to know the B column.
https://docs.google.com/spreadsheets/d/...
-1
votes
0answers
13 views
Script to get user timezone
So my query is as follows. I'm using google docs for a group of friends in a game and I'd like to add a script function to an image of a button that when clicked and permission is granted by the user ...
0
votes
0answers
22 views
Copy protections
I have a sheet with formulas in certain cell ranges. This spreadsheet is shared with multiple editors with edit permissions, but to protect formulas I have locked these ranges to prevent editing. I ...
0
votes
0answers
17 views
passing parameter from HTML javascript button to Google Apps Script
I tried this tutorial, but it was not written for v8-- and the logger and javascript parameter passing between html and the script doesn't work. https://www.youtube.com/watch?v=RRQvySxaCW0
I learned ...
-1
votes
0answers
14 views
Reference cell to copy paste in Google Sheets
I am building a Catan gameboard in Google Sheets to share and play with friends interactively. The game starts 'blank' with a frame, and players choose what kind of pieces the board should have, then ...
0
votes
1answer
28 views
Web app to google spreadsheet using google apps script in v8
I tried this tutorial, but it was not written for v8-- and the logger and javascript parameter passing between html and the script doesn't work. https://www.youtube.com/watch?v=RRQvySxaCW0
Is there ...
-1
votes
1answer
23 views
Google Sheets - Looking for script that auto capitalizes all cells in a specified column
Looking around, I found different things, but I never found the spot where you could specify the range, and I'm not familiar with this script.
Can someone please show me a script for this? For ...
-1
votes
0answers
12 views
How to run Google Code Script on all tabs
I've used the script from this tutorial (https://developers.google.com/apps-script/articles/removing_duplicates) to delete the duplicates from my Google Spreadsheet but this only works for the first (...
1
vote
1answer
25 views
TypeError: Cannot read property 'range' of undefined at onformsubmit again after creating an event object
This is what I have written in Script editor so as to auto-apply a formula to a new added row when a new response is submitted on the Google Forms linked to my spreadsheet. First I was using ...
-2
votes
0answers
12 views
Trying to pull a redirect URL destination for use with IMPORTXML
I've got a spreadsheet with about 7000 rows of data. I have a URL for each row, but the URL is entered as a search query that redirects to the appropriate result:
URL-LINK - www.shopcwi.com/...
0
votes
0answers
11 views
Problem with the .setUnprotectedRanges method
I have a problem with the .setUnprotectedRanges method
I want next ranges to be added in the loop. If the cell is not empty, another unlocked range should be added, which is in column 3. For ...
0
votes
0answers
44 views
What is the best way to restrict access to random cells in a spreadsheet?
I want to restrict approximately 80% of cells within range(s) from being edited by anyone but a specific group of people I call 'editors'. The other 20% of cells I want to be editable by a set of ...
-3
votes
0answers
14 views
Apps Script Help Please
How do I edit var ws = "Jamie" to include. "Sheet1", "Sheet2" ... etc
function addTimestamp(e){
//variables
var startRow = 2;
var targetColumn = 3;
var ws = "Jamie"
//get ...
-2
votes
0answers
20 views
Google Forms email notification based off responses
I'm trying to make a Google Sheets script in Google App Script to respond to changes to a spreadsheet from a form. it will eventually be used to send an email to the user with a list of URLs to access ...
0
votes
1answer
32 views
TypeError: Cannot read property 'range' of undefined at onformsubmit(Code:10:17)
I am getting this error when running :TypeError: Cannot read property 'range' of undefined at onformsubmit(Code:10:17)
I have installed the onformsubmit trigger but it is not working. What is not ...
0
votes
1answer
21 views
Google form adding more than one row every time
I know that when a new response is submitted on Google form, a new row is auto-added to the linked spreadsheet. I use several onformsubmit triggers for my form and linked spreadsheet. But I do not ...
1
vote
0answers
15 views
Automate Google Groups and Google Forms
I have a Google Groups that only accept invited members. I really want a Google Form where member input their email address and automatically an invitation to the group is sent to their email. As soon ...
0
votes
1answer
31 views
Exception: The parameters (null) don't match the method signature for FormApp.Form.getItemById. (line 38, file “Code”)
when I am running the script below I am getting the message - Exception: The parameters (null) don't match the method signature for FormApp.Form.getItemById. (line 38, file "Code")
it has been working ...
0
votes
0answers
29 views
how to apply changes to all dropdown questions in forms
I am using a script to update dropdowns in a Google form from a spreadsheet. There is a Questions#1 worksheet on which there are all questions that should be updated automatically in the form when any ...
0
votes
0answers
38 views
How to automatically forward future email in Gmail from a specific sender but only on the specific date
I receive delivery note's in my Gmail from different Supplier on the same date of delivery and I want them to be forwadeded to another third party email on the same day automatically.
The trouble is ...
0
votes
1answer
30 views
TypeError: Cannot read property 'getId' of undefined
I have written this script to my spreadsheet which is connected to a google form too, and connected dropdown function to a button on spreadsheet so as be easier to run the script. first it worked well ...
0
votes
0answers
13 views
How to fetch only the required data set for a query in ImportJSON?
I am trying to fetch the latest price of BTC/INR from a JSON HTTP URL of a exchange.
https://api.wazirx.com/api/v2/trades?market=btcinr
I am using the following formula in Google Sheet to Fetch the ...
-1
votes
0answers
76 views
Google account and email account
I restored my phone and my Google account was deleted
If I sign in to my Google account it says it couldn't find find it
If I create the new Google account it says I don't meet minimum age ...
0
votes
0answers
23 views
How to write multiple Google Sheets functions properly in set.formula function [duplicate]
I have a Google spreadsheet connected with a Google form. When a new response is submitted, the formula in the upper rows should be copied down to the new added (by Google form) row.
I have used once ...
0
votes
0answers
13 views
Google Sheets, Scroll to the bottom of each page
I have used this function to cause the page to scroll to the bottom on load. It works on the first sheet loaded but it does nothing when you change sheets. They remain at the top requiring us to ...
0
votes
0answers
10 views
Use something other than ctrl+alt+shift+number for macro shortcuts in google sheets
I can't use any shortcut that includes both alt and shift keys since in my keyboard alt+shift changes the keyboard language. Is there any way to use some other combination? I tried to edit the ...
-2
votes
0answers
25 views
Google apps script for gmail error
I'm trying to run a GMail Apps script that I collected from this forum as an answer to the following question about sending messages to Spam in GMail
The script I'm trying to correct is as follows:
...
0
votes
0answers
31 views
Google Sheets Data Validation with List Dependencies
Is this even possible with Google Sheets? I've looked around and found some explanations on how to accomplish this by using scripts. However, the issue remains because I'm unable to have my script ...
0
votes
1answer
16 views
Open multiple urls in different new browser tabs
My question is about the previous answer here:
How to open multiple urls in different new browser tabs from Google Sheets with a single click?
I just tried copying and pasting the code and running ...
-1
votes
0answers
31 views
Webapp-could not display the entry result in google sheet
I created an HTML userform via google app script. I have at least 10 input box. The code is working, however, the content of input boxes 1-6 are the only values stored in google sheets. I used the ...
0
votes
0answers
36 views
Google Sheet Script - if cell value is less than zero
This script doesn't work, and I just can't figure out why.
Cell D7 contains the absolute value of cell E7. If the value in cell E7 is negative, then I want to fake it so that cell D7 appears negative, ...
0
votes
1answer
25 views
Custom Function that will have data moved to multiple sheets from corresponding button click
I am attempting to be able to click start and stop buttons on the main page and have start and stop timestamps transferred to the corresponding sheet in the spreadsheet. I have programmed the "Paper ...
0
votes
0answers
10 views
Make a row read-only
I have a Google Sheet (Owned by me).
Users add rows of data (by clicking a menu option).
When they print a row (from a menu option), I want that the row must become read-only. The users must not ...
0
votes
1answer
15 views
Pulling data from most recent google sheet
I am currently working on a sales sheet for my team and have a question.
I currently have each month separated into different sheets for ease of use with our current workflow and would like to be ...
0
votes
0answers
22 views
How to get the row and column number on Google Sheets?
I have a DataEntry Form and I need to get the row and column number where is a value given by the form.
For example, from the form I get "test" and that value is on the column 5(E) and row (10), so ...
0
votes
1answer
11 views
Prevent a Google Script from Modifying Date
I have a Google Sheet that I am applying an onEdit script to. That script (borrowed from here) capitalizes all new entries in every field of all ranges of all sheets.
function onEdit(e) {
if (...
0
votes
0answers
13 views
Trying to change sharing access of team drive files(more than 2,000 files) and generate link on google sheet via google script
I have a lot of files on a team/shared drive that I want to generate links of. I managed to do it, but I also want to make the links viewable by anyone with the link. When I added the script to change ...
0
votes
0answers
41 views
Script to copy a formula to the next row
I have a script that will capture data from the email and saved it to the next available row in a google sheet.
function RevisionHistory() {
// Use sheet
var ss = SpreadsheetApp....
1
vote
1answer
52 views
How to Add RTL Tables to a Google Document
As I'm trying to format google doc tables and in reference to this thread I was able to add some formatting to the header row, to the table data and was able to create a doc in a landscape layout.
...
0
votes
1answer
55 views
Google Script Negative Offset ERROR (The starting column of the range is too small.)
Below is a script I got online, this sends an email if anything was changed in column O, part of the subject line is the value on column D, so I am using offset(0, -12).getValue() to get the value, ...
0
votes
0answers
35 views
Split multiple line cells from various column and duplicate the surrounding rows
may I know if there is a way that I could split multiline cells from various columns in google sheet then duplicate the surrounding rows. I am new in this kind of environment so I am really confused.
...
0
votes
1answer
63 views
Help with Google Script Editor and checking the value of all cells in a certain range
I am using google sheets to record our printer cartridge inventory, and using script editor to check the cells C2:C50, and send out an alert email if one cell falls below 1 after editing. I finally ...
1
vote
1answer
19 views
How do I run multiple onEdit functions in the same spreadsheet in Google Sheets?
all!
I hope I can count on your expertise to help me with a project I'm working on.
I want to call different functions based on which spreadsheet the event happened.
Ex. Typing 1 in B6 on "Room ...
0
votes
1answer
127 views
What works with the new Apps Script runtime powered by Chrome V8 for this project?
Post edited to clarify:
I found the following code that allows me to query my 3dCart store database and dump the information into a sheet. I tried upgrading to the new Apps Script runtime powered by ...
1
vote
0answers
19 views
Auto Complete Data - Google Spreadsheet Script
I have data management system in which the data is kept at multiple google sheets. Now there is primary sheet where the data gets updated. Is there a way to populate the same data on multiple sheets ...
0
votes
1answer
87 views
Embed Google Spreadsheet table Withing Google Document when data contains dates
I found a great script here that will add a Google Sheet table to my Google Doc.
function onOpen() {
DocumentApp.getUi()
.createMenu('Custom')
.addItem('Update Data', '...
-1
votes
1answer
23 views
Google Drive: Copy template document to folder via contextual menu
We use Google Drive to store our team's documents in the cloud. Some of those documents include templates that we use repeatedly in multiple client files.
Currently, we either make a copy from File >...
