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
25 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
30 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
28 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
0answers
14 views

Glideapps create date time stamp in Google Sheets when checkboxs are TRUE using onChange function [duplicate]

I use Glide Apps. I need to record the date and time any one of 6 different checkboxs are checked inside of Glide Apps. I have used an onEdit function with success when edits are made in the sheet but ...
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
25 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
33 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
114 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
26 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
71 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
159 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
28 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
28 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
48 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 ...
0
votes
0answers
9 views

Move from Spreadsheet2 to Spreadsheet1 [duplicate]

Is it possible to move from Spreadsheet2 (Tab2 in Google Chrome) to Spreadsheet1 (Tab1 in Google Chrome)? I want to copy some values in Spreadsheet2 and use them in Spreadsheet1. For me it is clear ...
-1
votes
1answer
23 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
45 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
15 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
23 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 ...
0
votes
0answers
12 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
27 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
55 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
86 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
35 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
47 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
27 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
321 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
51 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
24 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
vote
1answer
575 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 ...
0
votes
0answers
21 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
432 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 ...
0
votes
1answer
233 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
26 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
17 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
336 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
61 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 ...

1
2
3 4 5
28