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
28 views

Send a Google Forms notification to two differenz email addresses based on

How can I send an automatic email notification to two different email addresses depending on whether a woman or a man has filled in the form? Please can someone help me with a script to check this ...
1
vote
2answers
726 views

Google App Script - changeType “REMOVE_GRID”

I'm using a Google spreadsheet. I'm attempting to create an onChange trigger that will activate a script when any sheet is added or deleted. I was able to get the script to work when a new sheet is ...
3
votes
1answer
2k views

Reference Cells in Sorted Filter View

I have a Google Sheet that looks like this: That Google Sheet has some Google Script that looks like Google This: function myFunction() { var ss = SpreadsheetApp.getActiveSheet(); var rng = ss....
2
votes
1answer
913 views

Change function from running only on Active Sheet to run on All Sheets (tabs)

I have a script (from here) that changes tab name based on cell value. This works great on the active sheet but I would like it to check and change all tabs based on cell B2 of each tab. function ...
1
vote
1answer
642 views

Google script to delete on condition

I'm trying to fix a script for a Google Spreadsheet, https://docs.google.com/spreadsheets/d/1J3VRBXkx5B3p1fmrVpkI3Y6F5EGns9Vao7FyxOQsSVo/edit?usp=sharing I wrote to following: function ...
0
votes
1answer
50 views

Sending email form Google Sheet Issue

I took this script from the Google developer site and modified it to suit my needs. The issue i am having is where the "EMAIL-SENT" lands on my sheet. I need it to be placed on the 4th column right ...
0
votes
1answer
45 views

Increment the numeric value of Col D by 1 if Col E is “True”

I have tried to follow the example below to color E to Red if E = True Figured I would keep changing the script until What I want is to increment the value in Col D by 1 if the Value of Col E is "...
0
votes
1answer
1k views

Auto insert Formula on the next empty row upon form submit

I have a spreadsheet that contains 3 columns with leave request data coming from a google form. [From Date] [To Date] [Name of the Requestor] 5/16/2018 5/18/2018 John 5/18/2018 5/20/...
8
votes
3answers
4k views

Can I print the Print Date or Save Date in Google Documents?

I've created a word processing document that will be used by many people (a style sheet for writers), and will also be updated periodically. I suspect that well have some who print the document out ...
0
votes
1answer
1k views

Pasting timestamp for edits by multiple users in Google Sheets

I got a good Google Sheet script for pasting a time stamp at the designated column of the same row on editing any cells of another particular column. Here it is On Edit of column 11: timestamp is to ...
0
votes
1answer
95 views

Insert Blank Row after Every New Value in Google Sheets

I hope someone could help with this one. I’m not sure if this is possible but I would like to know if there is any way to insert a blank row after every change of Data in ColumnA(Country) which is the ...
-2
votes
1answer
31 views

Move cell values from one cell to another with scripts

Move cell values from one sheet to another using a button. Consider 3 sheets. One sheet is called "Tentative Attendees." It contains a column of names. Say cell A1 contains "John Doe,&...
0
votes
1answer
539 views

Create triggers on recently programmatically copied Google Forms

I have this main Form that uses its responses to create several other Forms after it's been submitted, but I need that these Forms that were recently created to send emails on their submissions ...
2
votes
2answers
1k views

Trigger onOpen() only for first instance of the sheet being opened for a user

I have a sheet that I want multiple users in my organisation to use as a dashboard, with the data displayed changing depending on the logged-in user. Everything works fine, and I have a simple script ...
0
votes
0answers
28 views

Optimizing onEdit for checkboxes

I am trying to design a survey through google sheets and have set up some checkboxes, but noticed that there is some lag when changing selections/clearing previous selection. I was wondering if there ...
3
votes
1answer
3k views

Auto Sort Google Sheet with onEdit function

The following function successfully sorts my file (containing 3 sheets) individually. When I hit the "play" button on the script, it properly sorts (as expected) the current (active) sheet. Since my ...
0
votes
2answers
139 views

How to export CSV without commas in unpopulated cells?

I have a form converter which simply rearranges columns. I use a script to paste Values only into another sheet for export and uploading onto another website. However, when I go to export, it seems ...
0
votes
1answer
35 views

Script Execution succeeds but reports failure

I'm running this script on a Google Form responses sheet: function autoSort(sheet) { var SORT_COLUMN_INDEX = 10; var ASCENDING = true; var NUMBER_OF_HEADER_ROWS = 1; var range = sheet....
0
votes
1answer
4k views

Horizontal sort in Google Sheets

I am a teacher and I store data from assessments in a Google Sheet. In the rows, I have student names and in the columns, the score they received from each question. I want to be able to sort by row (...
0
votes
1answer
332 views

Google Apps Script to automatically send email

I am trying to create a Google Apps Script that will send an email to our client's general inbox when we receive an email from one of their representatives containing an order. We are required by our ...
0
votes
1answer
32 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 ...
3
votes
1answer
960 views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
0
votes
1answer
169 views

Add row to Google Sheets and keep formulas from previous row

I want to add a row to my spreadsheet but keep the formulas – and only the formulas – of the previous row. The #1 solution provided here doesn't help me because it also copies non-formula information, ...
0
votes
1answer
461 views

Move rows on 2 sheets older than 24 hours to archive

I have been trying to figure this one out for a while now and would really appreciate some assistance. I have a Google Sheet that is being updated by a Google Form. Due to this I needed to mirror the ...
1
vote
2answers
317 views

Jump to today's date + offset 10 rows

New to scripting. Have a planner in Google sheets which is displayed on a monitor in the office. I have a script to make it jump to today's date on open (found here). The planner is organized with ...
0
votes
1answer
28 views

Need gmail script to reply to selected message, change subject, and send. Then change label

So I'm a recent convert of Outlook+Exchange to Gmail (company forced). I approve a lot of requisitions and such in email for automated processing by other applications. To do this, I simply review ...
1
vote
1answer
57 views

Apps Script - Deploy from manifest - Install add-on

The Apps Script code editor has a feature to "Deploy from manifest." After creating and saving a new deployment version, a link is shown that states: Install add-on I can not find any ...
0
votes
1answer
42 views

How to enable Trigger programmatically on Google script

The following code is creating trigger: var trigger = ScriptApp.newTrigger("function_name") .timeBased() .everyMinutes(5) .create(); but they are getting disabled automatically due to ...
2
votes
1answer
1k views

Email notification if cell value goes below set amount

I'm having trouble finding a Google sheet script that does what I need so I figured I would ask if someone could help me. Basically I have a simple sheet setup to track inventory of one item. There is ...
3
votes
1answer
1k views

How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?

I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
0
votes
1answer
943 views

Google Script to set the current month once a day only in a cell

Currently, I'm using (Month(NOW()) to set the current month number in cell $D$1 of a spreadsheet. I know Month and Now are volatile functions and they're making the over sheet update way too slowly, ...
0
votes
2answers
2k views

Google Sheets automatically converts a string to a number

I am using Sheets as a front end to view tons of different IDs and credentials associated with my authenticated access to a 3rd party API. When calling this function, I get this result: ...
0
votes
2answers
542 views

inputBox in onEdit does not work for users

I have a strange problem... Simple function like: function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet() var sheet = ss.getActiveSheet() var ui = SpreadsheetApp.getUi() var response = ...
1
vote
1answer
176 views

Dynamic generation of sheet name from cell content (cell contents from importrange)

I have a list of names of the members of my group. Each member has a separate sheet that contains information on that member. When a new person joins the group, I input the name to the master list and ...
-1
votes
1answer
57 views

How do I get Google Sheets to automatically subtract a value from one cell by entering the value in another?

I have a budgeting spreadsheet on Google Sheets which I’d like to be able to do two things (the first, I think, is easier than the second and the first is the priority for me): I write a value in, ...
4
votes
1answer
2k views

Programmatically create an internal hyperlink

I need to programmatically create a large number of links in a Google Sheets that point to a specific range in another sheet of the same document. I tried to use named ranges for that but for the ...
2
votes
1answer
972 views

Put the timestamp of last edit on master sheet, next to edited sheet's name

I'm trying to come up with a script that will print a timestamp of the last edit made to a specific tab within a google sheet. Imagine you have 17 retail stores, each one having its own tab with a set ...
0
votes
1answer
22 views

Trying to make duplicates with permissions

I am currently working on trying to make duplicates with permissions using google spreadsheet. There was a link that I saw that explained how to approach this(Google Sheet Duplicate with Permission). ...
0
votes
1answer
1k views

How to automatically set date in a cell when a different cell value is changed by a formula from data on another sheet?

I currently have a column, e.g. ColB, containing SUMIF functions with its data range from other sheets and a column, e.g. ColC, with dates that I want to automatically update to the last date ColB's ...
0
votes
2answers
982 views

How to automatically forward Gmail messages when a label is applied?

I have found this question that is answered: How can I automatically forward Gmail emails when a label is applied? However I'm using that exact script and have replaced the label and recipient with ...
1
vote
1answer
951 views

Auto hide row based on cell text (formula based)

My plan is to hide an entire row if a specific cell in the row showed specific value. I already found the script and the script work amazing. But the problem now, since the script use onEdit function, ...
0
votes
1answer
99 views

How to get a numerical value of a date with Google Apps Script?

I have a value 0.000347222222222222 in a cell, which when formatted as time, looks like 30/12/1899 00:00:30 . How to get it's numerical value with Google Apps Script? sheet.getRange('A1').getValue() ...
9
votes
1answer
27k views

Can I protect the formatting of a Google Sheets?

I’ve got a Google Sheets that has lots of formatting and formulas, in various columns, some columns are formula driven, and some columns that are user input driven. The spreadsheet is shared with ...
0
votes
1answer
1k views

Is it possible to import a formula from another spreadsheet?

I have a master spreadsheet, call it Master, and a lot of copies of this spreadsheet, one for every person in my organization, because they need their own copy. The Master sheet has a lot of formulas. ...
1
vote
3answers
4k views

How to execute a trigger only when one of the sheets is changed

When I have multiple sheets in a spreadsheet, I want to execute a trigger only when One of the Sheets is changed, not the others. OnChange() or OnEdit() is executing the trigger for any data change. ...
0
votes
2answers
39 views

Allow users to make yes/no decisions using checkboxes

I'm looking for a way my users can interact with my scripts. I'd like to use checkboxes to work like a "yes/no" command, where the script does "A" if the checkbox is ticked, and &...
0
votes
1answer
17 views

Consolidating Google Slides

I am constructing a small app to consolidate slide decks within Google Drive. For the most part the app works great. However, when I append a slide deck it only adds the first slide. ...
0
votes
1answer
19 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
1answer
18 views

Macro to move down and separate data

I wish to use a macro in Google Sheets to find the number 1 in column A then move that corresponding row and all following rows down to start at A9 row then find the number 2 in column A then move ...
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 2 3
4
5
28