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
18 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 ...
-2
votes
0answers
11 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
20 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
19 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
11 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
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. ...
1
vote
0answers
22 views

Google Sheet Script with Multiple tabs [closed]

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
36 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 ...
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
21 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
48 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
39 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
32 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 ...
0
votes
1answer
16 views

Get exactly data to put on email message?

I got a function to email notice like this code below: function approvedby() { var approvedrange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Responses 1").getRange("E2:E500"); var ...
0
votes
1answer
19 views

How to use google apps script to validate a cell?

I have been trying to write this code to validate a range of cells. If the cells contain the text "true" then set value as "Incorrect Data" else "DD Data" /** @OnlyCurrentDoc */ function myFunction() ...
0
votes
1answer
41 views

Create a custom DateTimePicker in Google Sheets

In a sheet I have a column to enter a datetime value that would later be checked by a script to create a trigger. I would like to set a picker in that column to ease selection and avoid errors. I ...
0
votes
1answer
42 views

Can automatic send emails when checkbox = True?

I'm looking for an script can automatic send emails when checkbox is True. This is my format example: What i want is when im clicking on checkbox = True at F2, i can recieve an email with excactly ...
0
votes
1answer
22 views

Google sheets, how do I combine data from two cells, where there is a URL (web-link) in the cells, without loosing the link(url)

I have tried to write a custom function in google sheets. I tried to create a function to joint the content of two cells. It works for text, however it does not work if the text contains a web-link (...

1
2 3 4 5
28