Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
1,362
questions
0
votes
0answers
12 views
Insert Blank Row after Every New Value in Google Sheets
I really need some 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 blank row after every changed of Data in ColumnA(Country) which is the ...
0
votes
0answers
8 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
19 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
0answers
18 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
0answers
17 views
Filter the data of two different column
I'm trying to filter down the data of two different columns. I have exported the Time Tracking Report from JIRA which consists of the following columns:
Issue Type Key Status Priority Summary ...
0
votes
1answer
10 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). ...
-1
votes
1answer
30 views
Google Sheets Script: update a specific row every day from the next row in range [closed]
I'm very new to google scripts, so really appreciate your help.
Conditions:
My users posting to their diaries through chat-bot.
I'm saving users activity statistics to the spreadsheet.
User gets a '...
-1
votes
0answers
16 views
Google sheets script opening a url in overlay window [closed]
Hi im new to this site so apologies, if ishouldnt be asking questions like this
i am trying to get my spreadsheet to display a url in a overlay window when i click my button the script is running but ...
0
votes
0answers
23 views
Simplify app script for google sheets [closed]
Question: How I can simplify this code for faster processing?
This is working, however it takes time to update the date answered column. If the internet isn't fast, it won't update especially because ...
0
votes
1answer
14 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.
...
-2
votes
1answer
20 views
Converting this VBA code to Google Script [closed]
EDIT: I'm going to drop a link to where I asked this question in a different place, The code below doesn't seem to be visually pleasing. You'll probably want to skip to the 2nd post.
https://support....
1
vote
0answers
22 views
Google Sheet Script with Multiple tabs
I am using the google sheet script below to do Start and End Time on my sheet and it is working fine. I need to do it on another sheet (tab) with the same function not affecting the 1st tab. Can ...
-1
votes
1answer
35 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, ...
0
votes
0answers
12 views
2 Google Forms linked into 1 Googlesheets
I have 1 googlesheets file with 2 sheets in it and both sheet has different forms.
I have a code that calls 2 functions format and prio:
function onFormSubmit(e) {
Format(e);
Prio();
QUESTION: how ...
-1
votes
0answers
20 views
Exceeded maximum excecution time. Google Apps Script. (simple script runs a thousand times)
Sorry for the bad language right away (I use a translator). I read many topics with this problem, unfortunately I could not find an answer. The problem is obvious, it takes longer than 6 minutes.
But! ...
0
votes
2answers
25 views
Is there any way to limit editing in Google Docs?
I'm looking for any way to set the character limit in Google Docs (specifically MS Word-like text processor).
So, for example, I have a cell in the table and I want to only allow putting 2000 ...
0
votes
1answer
42 views
Get List of *new* Google Drive Files within Specific Folder (including subfolders) into Google Sheet
I've seen some helpful answers to this question, but none that have the script specify to list only new files/folders added to the parent folder listed. I think what I'm trying to do is combine this ...
-2
votes
0answers
33 views
Auto forward in Gmail when an email arrive from specific email address [closed]
I need auto-forward in Gmail when an email arrive from specific email address using Google App Script.
1
vote
1answer
37 views
Automatically Merge Group of Cells Below a Text Value
I'm building out a scheduling assistant; the look is great, but it is very tedious to Merge & highlight each schedule block individually, so naturally I turned to Apps Script.
I'm entering ...
2
votes
1answer
40 views
Is there a way to copy a selection spanning multiple rows, and paste them as merged cells spanning two rows each, in Google Sheets?
I'm going to be honest; my biggest issue is describing what I wish to accomplish. I can't find the right word for it, so the title might not make a lot of sense. But the pictures should be clear,
I ...
0
votes
1answer
19 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 ...
0
votes
1answer
18 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 ...
1
vote
0answers
37 views
How to make this Google Sheets script dynamic?
I'm working in a script to paste a table on the same sheet, in my code I'm only pasting the table on the row A18
function NewQuote() {
var ss = SpreadsheetApp.getActive();
ss.getRange("A18&...
0
votes
1answer
39 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() ...
0
votes
2answers
37 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
0answers
20 views
Automatically Increase Document Number/Cell Number on open
I would like to be able to click on something which will open a new google sheet based on a template. I would need cell A1 to contain a number which increases by 1 every time the template is opened. ...
0
votes
1answer
17 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
20 views
How to Jump to Column Based off of Cell Value
My expected result is very simple - I have used data validation to place a list of column titles in a cell. When a user selects a column title and clicks the button, I want them to be taken to the ...
0
votes
0answers
29 views
How do I make filters auto-refresh when cells are updated via the API?
I have the following function running in Apps Script, however the onEdit function is only called via manual edits. It does not work when I edit the sheet using the API. Here is the function:
/**
* ...
0
votes
2answers
39 views
How do I keep all the values when I split a cell by delimiter (comma) in Google Sheets?
I have a spreadsheet in Google Sheets, where I am currently running a script.
There are two tabs, the first tab is the following:
The second tab is the following:
This is the script I am running:
...
1
vote
1answer
17 views
How to open sheets to a specific tab based on days of the week?
I have a file with 7 tabs or sheets each of them represent a day of the week (Monday to Sunday). In each day (Tab) a have this formula in B2 to show the day of the week if it is today...
=IF(WEEKDAY(...
0
votes
1answer
18 views
Google Sheet Script for automatically entering date/time stamp when the adjacent column
I've found a script on here for entering a timestamp in a column based on edits to the adjacent column:
Date and time stamp automatically added in column
if(e.source.getActiveSheet().getName() == &...
1
vote
1answer
47 views
How can I automatically timestamp rows in a Google Sheet? [duplicate]
I am entering data into a Google Sheet. I would like to have a column where each row will be automatically timestamped with the DateTime in which I entered (or last updated) the contents of the row.
I ...
2
votes
1answer
18 views
How to fix the date and time formatting in Google Sheets when running script?
I have a spreadsheet that currently has two tabs.
Data: This tab has sample data
Results: This tab has the same information from the sample tab, but "attendees" are split where there is a ...
2
votes
0answers
44 views
How to split cells in multiple columns in Google Sheets, but keep surrounding data?
I am including a sample spreadsheet of what I am trying to achieve.
In the tab “Data” is the data being pulled from a Google form, column G & H both have attendees listed, separated by commas. In ...
1
vote
1answer
41 views
How to set all checkboxes to FALSE in a specific column without losing formulas
I'm looking to reset all TRUE checkboxes to FALSE using a script. However, this column also has formulas I want to keep in certain cells (they are NOT checkboxes).
Is it possible to alter so that ...
0
votes
1answer
32 views
Get table name with apps script
I have two tables, namely Table A and Table B. Each table I want to identify the name of the table in column C matches the table names that have been defined in column A.
The script I've made is like ...
1
vote
0answers
25 views
How do I calculate subtotals by using ArrayFormula and without formula in the cell itself in a Google Sheet
I'm working on an estimate sheet, got it all worked out pretty neatly
and trying to tackle the formulae, make them work from the header rows using ArrayFormula instead of having each cell holding ...
0
votes
0answers
20 views
Code Run by Google Script Editor has Unwanted Effects on Google Sheet Conditional Formatting
I manage a "tasks" spreadsheet our office uses to coordinate. There are two main features that make it useful:
A script run with OnEdit trigger sorts the rows alphabetically by column E, which lists ...
1
vote
1answer
16 views
The script(onSubmmit Trigger) only works in the script editor and doesn't work when the form is actually submitted
This is a follow up of How to send email to a person selected from a dropdown menuwith all answers of a response of the form submission?
I want to notify mentors if they're selected by a user on a ...
0
votes
1answer
38 views
How to send email to a person selected from a dropdown menuwith all answers of a response of the form submission?
I want to notify mentors if they're selected by a user on a Google Form.
The names of the mentors are in a drop-down menu in the Google Form. This is the form: https://forms.gle/iNuA5nB2J9koKhXt6. I'...
0
votes
1answer
25 views
Clear range of cells based on another
I'm having trouble trying to write a script that will clear a range of cells based on another. For example I want to clear out only the cells C:H on each row if cell K on that row contains the word "...
0
votes
0answers
36 views
Extract data from web with Google script
I'm trying to use the function below (source) to avoid using importxml in Google Sheets:
function importRegex(url, regex_string) {
var html, content = '';
var response = UrlFetchApp.fetch(url);
...
1
vote
0answers
21 views
Combine imported JSON with Google Forms data
I've been watching the protests unfold and I see a lot of police brutality from videos and descriptions people have shared online. I found a GitHub where all of this is collected and I want to use ...
0
votes
0answers
15 views
With Google App Script activate a cell so it is ready for user to edit
I have a Google macro in which I do a few things, then want to end the script in an activated cell so the user can immediately begin typing in the activated cell (without clicking it).
I do some ...
1
vote
2answers
31 views
Google Sheets - Hide Specific Cells (NOT Rows or Columns) based on Checkbox within a Sheet (Is this even possible?)
First off, let me say that I am as newbie as possible when it comes to Scripts and coding in general (up until last Friday, my experience was one class in C++ and some HTML back in high school...) so ...
0
votes
1answer
19 views
How to apply formatting on specific Google Sheets and columns?
I have a Google Spreadsheet with many sheets. I want to apply (through code) formatting to specific columns to the sheets I specify.
I have tried this but my code applies the formatting to every sheet ...
-1
votes
1answer
16 views
I Need a script or a formula to get Logged User Name in Column C When he enter the cell from drop down list Selection in Column D In Google Sheet [duplicate]
I Need the Logged User Name in Column C When he enter the cell from drop down list Selection in Column D In Google Sheet
I have number of users to use one sheet they Have a list of drop down ...
1
vote
1answer
20 views
How to create a functional time menu in Google Sheets?
I want to create easy-to-use input fields for picking date and time in Google Sheets, preferably using only mouse. Date picker is straightforward enough, but choosing time is problematic. Obviously ...
0
votes
1answer
16 views
ARRAYFORMULA and FILTER
The following sheet is an example of what I'm trying to do : https://docs.google.com/spreadsheets/d/1B9a8OUvwciCAYURLZq-Jd2KeSUZsYlalAFNsANzRzNw/edit?usp=sharing
In the first sheet ("Matrix"), I have ...
