Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
1
vote
0answers
20 views

Google Sheets script Filter copy and paste with format

I am looking for help to create a filter on a Google Sheets Script. I want the following: I have a database Schedule which has table with information that I want to filter Once the database A is ...
0
votes
0answers
19 views

How can I create a Google Sheets script to generate hyperlinks to corresponding tabs based on cell value?

I have a list and want to quickly add a hyperlink to the corresponding tab. Say my list is in column BC and looks like: A B C A C B I would like all the A's to have a hyperlink to the sheet within ...
0
votes
0answers
21 views

Color cell background automatically if value has changed from original

Is it possible to automatically color cell backgrounds if their values has been changed (in my case, the only time a cell changes value is by manual user edit/input - no cell values are computed of ...
1
vote
1answer
25 views

How to Hide/Show Different Rows based on MULTIPLE cell values

I've read through countless different posts that are similar to this topic, but have yet to find something that really solves the exact issue I'm looking to fix. My script currently reads the value ...
0
votes
0answers
19 views

How can I add Keyboard Shortcut to run a script in Google Docs?

For everyday work log, I've enhanced script from this link but it's a tedious task to do using the touchpad. If there's a way I can call the script using the keyboard shortcut. It'd be much faster and ...
1
vote
0answers
25 views

Download hundreds of links for images in my google response sheet of my google form assign new file name [closed]

I have hundreds of links for images in the google response sheet of my google form. I need to download these images and assign them a file name so it matches the response number in my google sheet. ...
1
vote
1answer
11 views

Google script “if” condition not working on active sheet; However, no error received

The purpose of the Google script below is to compare cell B2 & cell A5 (Sum of C2:M2) in active sheet/tab; if B2 is less than A5 than it will pop up an alert & simultaneously change the ...
0
votes
1answer
7 views

copying the Data to the next available Row in Another Sheet

I have run into a small issue with this script, it does copy the values in the range but pastes them under the 1500 cell in column A on the destination Sheet. I can't seem to get it to paste to the ...
1
vote
1answer
36 views

Google App Script DriveApp get top level parent of a file

I want to know how to find out the top level directory parent of a file (which resides under "My Drive"). Files are stored under multi-level sub-folders. Since I have the same file stored in multiple ...
2
votes
1answer
76 views

Google Scripts DriveApp searchFiles does not work on a specific folder

I am trying to search through some files stored in a specific folder on Google Drive using Google Scripts. This is for creating a "Deployment Folder" for my school for the upcoming academic session. ...
0
votes
1answer
8 views

Macro to copy and paste values from multiple cells as text into a Note

I'm new here and struggling a bit with the javascript in macros. I just need a steer as to how to get a macro to copy from a range relative to an active cell. I'm a showcaller, that is, during live ...
1
vote
0answers
31 views

Create a function to upload and import spreadsheet file to google sheets?

I have successfully created a button to execute a function that will actually grab the file off on my computer. But will not to completely import the data of that file into a new sheet tab. My ...
0
votes
1answer
33 views

Extract Data from Sheeet2 and into Sheet1 (Tabs instead of actual spreadsheets)

This may be a little confusing to understand but in a simple word, I want to be able to extract selective data from Sheet2 into Sheet 1. Example. in Sheet1 Cells A8:A50 are empty, I want to be able ...
1
vote
1answer
10 views

How to pass a variable number to an Apps Script Range

I cannot get this line of code to work where nowts is the number 12 for example obtained from a ui: spreadsheet.getRange("L"&(nowts+1):"L"&(nowts+2)).clearContent(); I am trying to clear ...
0
votes
1answer
37 views

Use countblank to count number of blank merged cells in Google Sheets

I am trying to get the number of empty merged cells in a range, say for example the 6-cell range of A1:F1. If the cells weren't merged, I could simply use =COUNTBLANK(A1:F1), but let's say A1:C1 are ...
0
votes
0answers
22 views

Create a Function in Google Sheets that shows the User's information [duplicate]

I would like to add a Function to my Google Sheets, so I can show in a cell the user that changed another cell (only the latest change), with the choice of showing the date and time of the change also....
0
votes
1answer
22 views

Clear Cell When Adjacent Cell Equals Value

I have a spreadsheet with a time-driven trigger that clears a range every week. This is my current script. function clearWeekly() { //replace 'Sheet1' with your actual sheet name var sheet = ...
0
votes
0answers
23 views

script correction for in the sheet

function onEdit() { var ss=SpreadsheetApp.getActiveSpreadsheet(); var s=ss.getActiveSheet(); if(s.getName()==="Sheet1") { var r=s.getActiveCell(); var v= r.getValue(); var s1 = ...
1
vote
0answers
27 views

Can I add a unique autoincrement field to multiple answers in a column in a Google Spreadsheet based on a Google Form?

I need to add a unique autoincrement field to multiple answers in a column in a Google Spreadsheet based on a Google Form. I was able to add the function trigger in scripts but I need to add the ...
1
vote
1answer
34 views

How do I stop script from reading rows more than once?

Running into an issue where the script is reading the same row more than once. For example, I run the script and it pushes row 1 to the calendar as intended. When I add more info in row 2 and run the ...
-1
votes
1answer
25 views

How to make custom buttons in HtmlService to trigger the Import or Print links in Google Sheets

I am using an HTML function (HtmlService.createHtmlOutput) to show my custom buttons in a popup or sidebar within my google sheets. But I am simply trying to make custom buttons to invoke the already ...
-1
votes
1answer
123 views

Can anyone help me with the script for locking non empty cells in a Range at specified time?

I use this in a very small business. We sale the aggregates E Column and the items(DUST,6MM,10MM,20MM,40MM) and quantity F Column are listed (1 ,2 3, 4, 5,6) in drop down. So the Range E7:F300 are ...
0
votes
1answer
28 views

Add fields and update array and scripts

I want to add some questions to my Google form but my response sheet has a script and an array, which do not like that. Here is what it should look like: The URL is the link for the form. Here is ...
2
votes
0answers
84 views

How to Group Set of Rows & Skip One Every Time

I'm currently working in a Google Sheet that has about 12,000 rows. Because of the layout, I want to group every 5 rows, then skip one, then group the next 5. Right now, I have as script that is ...
-2
votes
1answer
24 views

Google Sheets atomisation

I hope you are all well and healthy! I am looking for a solution in Google Sheets to automate something like this: and it could auto generate something like this Thank you in advance
1
vote
0answers
23 views

Copy to next free cell in specific Column

I'm trying to copy some specific cell to the next empty cell in an other sheet. I don't get how to achieve this. Is there someone that can help me? There are three more ranges that have to get into ...
1
vote
1answer
204 views

google sheets sum of colored cells TypeError: Cannot read property 'pop' of null

I am using this gentlemans script: http://igoogledrive.blogspot.com/2015/11/google-spreadsheet-sum-of-colored-cells.html To sum up the value of only colored cells but I get an error message saying "...
1
vote
1answer
31 views

Run Google Sheets script on multiple sheets

I have a Google Sheets script that's designed to input timestamps whenever there is an edit, but I need it to run on multiple sheets (West, East AND North) on the same drive... How can I make that ...
0
votes
1answer
32 views

Find and replace for the exact value script

I have a little problem with my Google Apps Script, which I found on the Internet. If I want to replace "05" with "98", all numbers that contain "5" will be replaced ... such as. "35, 55, 15" etc. ...
0
votes
0answers
14 views

Google Script: Spreadsheet: How to switch between Fit-To-Data and Specific height (Adjustment of row height)

I want to program my script to switch between two row heights (Default and Auto-Fit) using a self programmed button in the google spreadsheet. But once the row is auto-fitted, there is no way of ...
0
votes
1answer
74 views

Send email using Google Apps Script, with filename in spreadsheet

I'm trying to do the same thing as this question: Send an email with attachment using Google Apps Script But with the attachment names as cells in the spreadsheet. My code is here: function ...
0
votes
1answer
21 views

Script not always starting when using html popup to gather data

I have a script that uses a html popup window to get user input and pass the data to my main script after the user enters data and click the 'submit' button. I want the window to close after the user ...
-1
votes
1answer
32 views

Google Sheets Script Clear cell on Sheet A after value submitted via form to Sheet B

NOTICE - I am a bit of a noob when it comes to writing scripts. I do lots of google searching, cutting, pasting, modification, researching etc. I haven't been able to find what I need for this ...
0
votes
1answer
46 views

Switch between different Tab´s

I have a problem. I need some values from Spreadsheet2 (Tab2), in Spreadsheet1 (Tab1). Tab1 and Tab2: I don´t know the URL from each Spreadsheet, they are unknown. How can I switch between these ...
0
votes
0answers
16 views

YouTube Channel Subscriptions

I wanted to transfer my YouTube channel subscriptions to another account. So I exported my channel subscriptions .XML file. But now I can't find a way to import them to another channel. I have tried ...
0
votes
0answers
24 views

Copy Full Range of Cells to New Tab

Forgive me if this has been answered, I've been searching various posts but still cannot figure it out. I'm looking to copy a range of data from one tab to the next in the first blank row. I've ...
1
vote
1answer
45 views

ImportHTML Altering Data Format/URL Fetch Issue

4/17 6PM Update *** I am now trying to use the URL Fetch App. I've been playing with this for hours, but can't seem to figure out the issue. I am just trying to get the info from this site as plain ...
0
votes
0answers
16 views

Populating Google docs from multiple templates depending on Google forms responses

I have the script below to create Google docs from a template when a form response is submitted. But this scripts uses only one template. What I want is to create different docs depending on the ...
0
votes
1answer
28 views

not working form submit Event Object

I have a Google form which I use to populate a Google docs from a certain template whenever a new response is submitted. In order to achieve this, I have written this script, but it is not working and ...
0
votes
1answer
56 views

How to migrate apps and stuff to g suite from regular gmail account

Summary How can I use my new G Suite identity in my existing Google Apps Script and other google back-end services? Even a vague concept clarification or pointer in the right direction would be ...
1
vote
2answers
105 views

Adding 1 to a Cell with VLookup

So this is my first time trying to write a script, and the sheet I am working on is here. The script I'm trying to run would allow me to push a button and have it use Vlookup to add 1 to a cell in ...
0
votes
1answer
14 views

TimeStamp syntax to appear 24 Hrs Timestamp

I am using var TIMESTAMP_FORMAT = "yyyy-MM-dd hh:mm:ss a"; var TZ = "GMT-7"; in my script code of Google document I want it to be convert into 24 hrs timestamp What changes should I do ?
0
votes
1answer
46 views

App script to update the data changes to multiple sheets

I made a script to combine data from Sheet1 and Sheet2 into Sheet "Master". If there is a data change in the "Master" sheet, I write the script to update the data changes to each sheet. My ...
0
votes
1answer
27 views

Can't get If Else statement to run based on value of edited drop-down selection in Google Sheets Script

I have a dropdown field on a sheet (consisting of Wheat, Wood, Stone, etc.). When that dropdown field is edited, I want it to run one of a few similar functions, based on the dropdown selection (when ...
0
votes
2answers
53 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
35 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
28 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 ...
0
votes
0answers
60 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
478 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 ...
0
votes
1answer
59 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
2
3 4 5
28