Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

search/match a date on Google Sheets using Google script and copy a source range to a destination range OFFSET from that date

I'm struggling with some simple copy/paste scripting in Google Sheets. I'm a complete scripting newbie. Advanced at Excel/Sheets. I have a "Today" data entry sheet. I have a "Program" sheet that ...
1
vote
3answers
2k views

Google forms script to delete responses counter

I have tried and combined a few pieces of script to delete rows, but this does not reset the counter. Help resetting responses using script would be appreciated. My copy sheet function, and delete ...
0
votes
0answers
16 views

Include filename of source spreadsheet

I have 2 spreadsheets for 2 employees and I combine them into 1. From employee 1: From employee 2: I use importrange to combine the sheets. I also know now how to get the spreadsheet file name by ...
-1
votes
1answer
11 views

How to replace reference cell and have it affect the main cell if it referencing?

I asked a similar question on the Google Support Forum. I was wondering how I could reference a cell with any sort of value in it to another sheet (inside the same Google Sheets document) and then ...
2
votes
1answer
53 views

How to automatically convert all Microsoft Office file attachments in Gmail to Google Docs?

My Gmail has thousands of emails. Each email will have several attachments as Microsoft Office files (.doc, .docx, .xls, .xlsx, .ppt, .pptx). Currently, I want to automatically convert all Microsoft ...
1
vote
0answers
24 views

Writing a macro to create a new tab and name that tab based on a cell value in Google Sheets

I would like to have a Macro that generates a new tab and names that tab based on a cell value. There is a tab called 'Dashboard'! on which the user enters information in assigned cells. Afterwards, ...
1
vote
2answers
2k views

Cell values ​do not update

I want to update every minute a cell with data from a HTML link. The problem is that the value does not update unless I manually empty the cell or make changes to the script. I tried to add NOW() to ...
1
vote
1answer
53 views

VLOOKUP vs IMPORTHTML

I am having a Google Apps Script issue using VLOOKUP on some data generated by the IMPORTHTML function. For normal user interactions this does not seem to be an issue but scripts accessing the ...
1
vote
1answer
28 views

Synchronizing Cell Changes Across Sheets

I'm trying to connect a pair of cells on different sheets within the same Google Spreadsheet, so that after a new value is entered into one cell, the other cell will update to match that value, going ...
0
votes
0answers
40 views

I am trying to work with Google App Script to auto respond to after hours emails [on hold]

I would like to have emails received to a particular inbox responded with a canned messaged after hours. Below is the code I've got so far. Is there something I am missing? I've tested but do not ...
3
votes
2answers
821 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 ...
-1
votes
0answers
8 views

Google App Script Execution Triggering Scenarios [on hold]

Does the Google Apps Script trigger to run after you make any changes to it on the console ? Because after I made several changes Service invoked too many times for one day: urlfetch. (line 133) in ...
0
votes
0answers
4 views

Check if the Matrix API Data available for “Transit ”mode for a specific country

Hi I need to check if the Matrix API Data available for "Transit "mode for a specificity country,Pls help me to verify because it seems that even if I define transit mode it returns default data for "...
2
votes
0answers
865 views

Change tab color based on cell value that is a formula OR cell background color

1st time question asker, so I'm apologizing in advance if my question is worded wrong or doesn't make sense or is, frankly, to wordy (I tend to over explain). I have a sheet with, currently, 10 tabs. ...
-1
votes
0answers
9 views

google spreadsheet by using Distance Matrix API Pass the arrival time [on hold]

Hi I've used a simple script before to retrieve the following data set but now I need the urgent help from this community to pass the arrival date to this code. To summarize the requirement: I'm ...
0
votes
1answer
25 views

How to prevent “invoked too many times per second” error [duplicate]

The main requirement is to find travel time with traffic data between two locations or zip-code. Inputs parameters would be from Location, destination, arrival time(this is between 6AM 8AM), mode of ...
1
vote
1answer
15 views

Fill-down formula to last used row

This function is to copy-down a formula C2424 to the last used row. Instead of copying it down to the last used formula its copying it to the last existent row within the sheet. How can I do it only ...
0
votes
1answer
11 views

Adding checkbox format in column

Trying to add checkbox format to a column using Google Apps Script to this working formula sales.getRange("I2").setFormula("=IF(COUNTIF(B:B,B2)=COUNTIFS(B:B,B2,E:E,TRUE),TRUE)"); var ...
0
votes
1answer
43 views

Target different column

The following Apps Script function copies certain values from a row given from one sheet to another based on a value and also formats the output. It works perfectly well. It was written by @Tedinoz ...
2
votes
1answer
510 views

How can I get my set values and formulas to populate to a row of values received from a Google Form?

When I receive submissions from a form I am trying to find a way to include my formulas and set values in the same row as the information submitted by form. My form is only collecting 14 values but my ...
-1
votes
1answer
21 views

Description based on each checkbox “checked” to populate into a summary on the 2nd tab (sheet)

I am building a spreadsheet that has to tab (sheets), the 1st I have an "assessment checklist" with about 250-30 checkboxes based on what is found. Example (Checkbox is in "A" column and description ...
1
vote
2answers
148 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 ...
1
vote
1answer
249 views

How can I prevent editors from accessing the script editor in Google Sheets?

I have an auto sort script on a Sheets document that I will be giving multiple people editing permission to, to add to the file. I have created a trigger so the script also runs when other users edit ...
7
votes
4answers
19k views

Connect with database and fetch data to Google Spreadsheet

I have been wondering about this for a while. We are using Google Spreadsheets a lot with my colleagues and the thing is that we always have to write down data that we already have in our MySQL ...
0
votes
1answer
116 views

Format a Cell with Script

I need to write a script to see if a cells value is found in an array, and if it is change the background color of that cell. Can't do this with "Conditional Formatting" as it needs to compare with ...
0
votes
2answers
4k views

Adding multiple rows by script

I have this simple Google Sheets script that adds a row after every already existing one. What do I have to change to for example add 12 rows? function addRows(){ var sheet = SpreadsheetApp....
-1
votes
1answer
803 views

Writing a spreadsheet script

The above link is a picture of the Google Docs spreadsheet that I am working on. Basically it is a sale ticket for a small appliance parts store. I need to be able to select a range of rows and have ...
2
votes
1answer
929 views

Google Script Replace Function Reference

Is it possible to build a Google Script where I can select a cell, take its function, replace the cell references (instead of C2,C3,C4, etc. make it AC1,AC2,AC3, etc.), and then return the output of ...
2
votes
1answer
2k views

Script to copy values only

I have a script which copies new form data from one sheet to another. However, I only want the values and not the formatting to paste. Here is the script: function onFormSubmit() { // moves a ...
3
votes
2answers
3k views

onOpen doesn't execute

I've got a google spreadsheet I created yesterday and used Tools -> Script Editor to create a function in a single file called Code.gs function onOpen(e) { var email = (Session.getEffectiveUser()....
0
votes
0answers
13 views

How to create trigger automatically when I open my spreadsheet [duplicate]

I am trying to create Time-based trigger automatically when a file is opened, the function works fine when I execute it manually but it doesn't work when i open the file. function onOpen(e){ var ...
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 ...
0
votes
1answer
20 views

Copying a cell's background colour to other multiple cells via script

Update; code is now: function copyFormatting() { var sheet = SpreadsheetApp.getActiveSpreadsheet(); var fromRangeGI14 = sheet.getRange("GI14"); var toRangeGI14 = sheet.getRangeList(['N9','...
1
vote
1answer
2k views

Update Cell If another cell is not empty

There are two columns N and O. When any cell in column N is filled the adjoining cell in column O needs to filled with "Yes" if not it stays empty. This is the script I'm using. var s = ...
0
votes
0answers
58 views

Define Origin, Waypoint, Destination [closed]

I have a google spreadsheet with data as below. emp_id Date Point Emp-107 1-Aug-19 Origin Emp-107 1-Aug-19 Destination Emp-107 2-Aug-19 Origin Emp-107 3-Aug-19 Origin Emp-109 ...
1
vote
1answer
35 views

Need help clearing specific cells in multiple tabs in Google Sheets Scripts

I'm having trouble editing this code to get it to edit multiple sheets at the same time. It works for whatever is active, but I'd like to disable that and have it work on each tab named after each ...
0
votes
1answer
42 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
votes
0answers
61 views

Copy row to another sheet based on value and divide comma sepparated values into multiple rows [closed]

Example sheet here What I want is a Google Appscript that would automatically copy CONTACTS! row to SALES! last row when CONTACTS! row has "SOLD" value in column J ** THe thing is it also needs to ...
0
votes
1answer
18 views

How to give a column a green border if the second row's holds a date = TODAY()?

I'm trying to make a useful schedule sheet to keep track of all of my class assignments: I want to write a script in the script editor that says, for(Column A-Z){ if(A2,B2,etc = TODAY()){ ...
0
votes
0answers
11 views

Printing a document for all Google Group members, with merged data

I am looking for a way to print a Google Doc template for all members of Google OU, merging name, surname & email address. Is there some existing functionality I should I write a Google App ...
-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
1answer
37 views

Use `setValue` to update a column based on values of two others that match their respective values in reference cells

I am new to Google AppScript and would really appreciate some help here. I want to use the setValue along with the for loop and if statement in Google App Script to scan multiple columns in Google ...
0
votes
3answers
2k views

How to make that a custom function update its result immediately

I'm using a custom function to read the sheet name (shown in the tab) and then return the name to the cell in the summary page. The script works, however it doesn't update when I change the name of ...
0
votes
2answers
38 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 ...
3
votes
1answer
691 views

Is it possible to make a summary sheet in Google Docs based on tags?

I have a document in Google Docs. It is very long and I want to tag and extract only certain paragraphs into a second document that is a summary of the first document. I want to be able to dynamically ...
0
votes
1answer
154 views

How can I use a script across multiple pages of a Google Sheet

I'll start by saying I'm very new to this. Here's my problem. I have a GoogleSheet I created to use as a seating chart in my classes. It is designed so that when I click the blue check button the cell ...
2
votes
1answer
51 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
369 views

Google Form File Upload - Change file name to match form value

I have a Google Form for contact information. The form asks for Given Name (col A), Family Name (col B) and a File Upload restricted to images only (col D). I have a formula which displays the Full ...
-1
votes
1answer
21 views

How can I make an attendance table that automatically deletes obsolete day and creates a new?

I need a Button that deletes the entry of the first column(A:A) and creates a new one(H:H) and the Date at cell H2 to automatically set to the next Thursday or Sunday. Currently, I just recorded a ...
0
votes
1answer
220 views

How to extract a link URL from one word within a paragraph element in Google Docs with Google Apps Script

I'm trying to pull the URL of a hyperlinked word from within a paragraph element in a Google Document using Google Apps Script. Below are two GAS functions. The 1st doesn't work. The hyperlink is only ...