Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
0
votes
1answer
318 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
59 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
44 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
129 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
34 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 ...
0
votes
0answers
26 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
15 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
14 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 ...
0
votes
0answers
39 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 ...
1
vote
1answer
28 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 ...
0
votes
0answers
113 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
26 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
12 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
16 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
31 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
17 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 WebApps:Convert all text to UPPERCASE in a Google Spreadsheet) capitalizes all new entries in every field of ...
0
votes
1answer
25 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
45 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
85 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
633 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, ...
1
vote
1answer
63 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
67 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
26 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
298 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
24 views

Auto Complete Data [duplicate]

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
273 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
24 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 >...
0
votes
0answers
19 views

Google Sheets Button 'Read Only accounts'

So basically, I created a button that is assigned to a function within google scripts, however when I tested the button on a 'view only' permission account, it has not response. Just wondering whether ...
0
votes
0answers
67 views

Get Search Result URL's From URLFetchApp on Google Apps Scripts returning Null

I've been trying to create a function that gets the URL's from the URLFetchApp function, and I read somewhere that using these regex matching expressions could scrape the URL's out of the return value ...
0
votes
0answers
18 views

How do I automate the creation of new tabs based on the addition of a new value to a column?

The new tab would be formatted based on a different template tab, if you could write the code with the following variables: "Data Entry" is the name of the tab from which I want to use the value of a ...
0
votes
0answers
24 views

How do I edit this to limit to only the last 6 months?

Good day, Newbie to coding and wanted to ask for your help so I can limit the output of the data below to only last 6 months. function sender_list() { var inbox_threads = GmailApp.getInboxThreads()...
0
votes
0answers
42 views

timestamp when copying data

I am trying to enter a timestamp in google script for a google sheet with date/time & user in columns 14 (data entry) and 15 (last modification) with some conditions (the most important is data in ...
0
votes
0answers
15 views

Google Sheets: replace text in column when row is added

I have a problem with a Google Sheet. I use docpaser to read incoming pdf files - doc parser reads 8 pieces of information in each pdf file and adds a new row to a Google Sheet with the information ...
0
votes
0answers
21 views

Use google apps script to update cell where column name and row name matches

Use Google Apps Script (GAS) to update the cell where Column name and Row name matches the provided values. The function produces the desired result on the sheet =query(dataset, "select sum(C) ...
0
votes
0answers
26 views

Find cell using horizontal and vertical lookup using appscript

How to find the cell by matching SKU and Date in the following sheet using google apps script? I suppose, using normal formulas will make it very slow if the volume of data is very large. For ...
0
votes
1answer
15 views

Partial Font color in a cell

Wanted to see if there's a way to automate changing the color of the font in cell for selective parts. For instance, I have in one cell: If you have any questions, please <a href="{linker('...
-1
votes
1answer
169 views

Get email address in from Google Forms in script

I'm creating a Google Form where guests can log in and an email will be automatically be sent to the person that submits their form. They are not required to log into Google as this will be running on ...
0
votes
1answer
230 views

Add dynamic questions in Google forms

I am using google forms to punch orders in my Google Sheets. Although I am facing a challenge as the number of products is variable. For example Question 1: Item Name Question 2: Quantity I ...
0
votes
0answers
23 views

In Google Apps Script, how do you get the Range of the calling cell in a custom function?

I'm trying to get a reference to the calling cell's range in a Google Sheets custom function. For example: function MyAddress() { callingRange = // get calling cell reference here return ...
0
votes
0answers
18 views

Border Formating

I am looking to format cells with a border if the title cells both contain text. To trial I have used number 1 for the search key. I think it may be in the range I am supplying for the .setBorder. ...
0
votes
0answers
198 views

How send QR code image create with chart.googleapis from Google Apps Script Telegram bot?

I want send the QR code image to Telegram bot programmed by Google Apps Script . I send images with SendPhoto function function sendPhoto(id,foto,caption) { var url = telegramUrl + "/sendPhoto?...
0
votes
2answers
23 views

Move data script

I am setting up a script to copy data from one location and paste values into another location (same tab). However it is only picking up the first line. How can i get it to pick up the whole range ? ...
0
votes
0answers
13 views

On Edit Duplicate Sheet but with data prior to edit

I'm using Google Sheets for my gym routine. I'm trying to set it up so that when I update the sheet (i.e. increase/decrease a weight, etc.) the old data is left on a separate sheet so that I can ...
0
votes
0answers
14 views

auto copy to new range in google sheets

I have a sheet that pulls report data from SFDC each night. I have some territory data that I populate for 3 fields via vlookup formulas. Each morning, I have to manually copy those fields to the new ...
0
votes
0answers
29 views

Name of PDF & Subject line referencing a cell when emailing PDF

Trying to have the Subject line of email & the name of the PDF attachment to reference a cell. The script has text for the Subject - but would like the Subject line to have text (SHORTS FORM FOR ...
0
votes
1answer
11 views

Need to validate data in a cell before running a script

I am running a script attached to a bouton in a sheet. The current script is as follow. function Ok() { var ui = SpreadsheetApp.getUi(); var click = ui.alert("are you sure you want to send?",...
0
votes
0answers
14 views

How do I get the selected cell on another sheet?

ok here is the manual situation in the spreadsheet: 2 sheets named Green and Blue Blue is the active sheet and B3 is selected. If I tab over to the Green sheet, D7 is selected. So I know somewhere ...
0
votes
1answer
71 views

Continuation token: Generate file listing of a google folder into a google sheet

I have a folder on Google with 18k files and need to list some variables from them into Google sheet. A solution for this was found on Insert image from Google Drive into Google Sheets However, ...
0
votes
1answer
55 views

How to confirm if values are in a column and move to a new sheet - Google Script

In Google Sheets, I need to check column F if certain values are present. If the values I have specified are in column F, it will copy the entire row and paste it on a new sheet. The code works when ...
-1
votes
1answer
20 views

Google Sheets calendar script is timing out

function onEdit(e) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); if(sheet.getName() != "Sheet2") { return; } var lastColoum = sheet....

1 2
3
4 5
28