Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
-1
votes
1answer
244 views

Find and Replace (CTRL+H) script on Google Sheets

I'm looking for a "find and replace" script for Google Sheets. I have phone numbers on column C, which are in a ###-####### format. I want to make a script that will replace the "-" to nothing. ...
0
votes
1answer
17 views

Is there a way to sort my Google Script project triggers, on the console?

My console currently looks like this, and I expect the number of triggers to increase: screencap of my GSuite Developer Hub's project triggers console I name most of my projects in a standard manner,...
0
votes
1answer
66 views

Help needed with script that auto-updates cells in column in Google Spreadsheet showing last modify date

I'm looking for some help with a script for a spreadsheet. I found a script (see below) that does half the trick for me, but I encounter two difficulties. What I am trying to accomplish is the ...
0
votes
0answers
15 views

Pasting values depending what column cell is in

Afternoon, I have this script where if I press delete, or edit, it takes the value and puts it in A6. Now I'm wondering how I make it so that if the cell value is from column A, it puts it in A6, but ...
1
vote
0answers
23 views

Google sheets script add data in next column

I'm trying to modify a script to create a PageSpeed report that pulls in certain KPI's from Google Pagespeed API. Once the data is received, i want it to place those KPI's next to the URL and so forth....
0
votes
1answer
137 views

Splitting the contents of a comma separated cell into new rows [duplicate]

Based on: https://stackoverflow.com/questions/52376162/combining-column-data-in-google-data-studio I have a long list of data, about 200 rows, and each row contains multiple columns of data and a ...
1
vote
0answers
14 views

Creating auto-updating indexed links to tab in spreadsheet

This spreadsheet is a lesson planner for teachers. It will be used by a wide variety of teachers with varying tech skills so it needs to be straightforward and not easily messed up. The first sheet ...
0
votes
1answer
408 views

Need to get a list of Drive files several subfolders deep

I need to get a list of all the files in my Drive with all of the nested folder names where the files reside. I found this very helpful answer which is almost exactly what I need: Get a list of ...
0
votes
2answers
2k views

How to wait for Google Spreadsheet calculations to update before retrieving cell data in Apps Script web app?

I am creating a Google Apps Script web app that uses Google Sheets as its backend. This web app basically allows users to track their work time (clock in for the day, clock out for lunch, clock in ...
0
votes
1answer
14 views

Custom side menu question & active sheet

I am trying to create a custom side menu that changes depending on what sheet I am on so the side menu is relevant to what I am on. I've attempted doing some code to do a tactic where depending on ...
0
votes
1answer
159 views

Have script ignore first row [duplicate]

I am using this script to add in a date whenever a row is edited. I want it to ignore the first row. Thoughts on how to do this? function onEdit() { var s = SpreadsheetApp.getActiveSheet(); // ...
1
vote
0answers
72 views

Numbered list with Cyrillic letters

In Google Docs, I would like to have a numbered list using Cyrillic letters, such as: а б в г д The regular choices for numbered lists offer the options of Arabic numerals, Latin lowercase,...
0
votes
0answers
29 views

Convert Non google URL image links in a Google Document with actual images

I am trying to do something very similar to another thread (Convert all links to images in a Google Document with actual images) but with non google stored URL links. DriveApp only works for google, ...
0
votes
1answer
37 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
0answers
13 views

In Google Sheets script how do you email a date in a cell and control how it looks in email?

I'm building a Sheets Script add-on for sending invoices. In my sheet, I have a chart with the dates written along a row. When I use the MailApp.sendEmail() the date is printed in the email ...
0
votes
3answers
242 views

Trying to run two scripts on same sheet and getting error

I found a code to run the two different scripts online, however i keep getting an error Missing ; before statement. Original function onEdit(e) { oneditfx1(e); oneditfx2(); } function ...
0
votes
0answers
52 views

Code to automatically duplicate a google spreadsheet

I want to automatically create a copy of an existing google spreadsheet that will have a name taken from a list. So when I add a name to that list the file will automatically duplicate with a specific ...
0
votes
0answers
43 views

How to move a row to another sheet based on date value

I want to move row to another tab based on date value. i.e. if the data is 90 days older from today the row should automatically transferred to another tab. Sample Sheet: https://docs.google.com/...
0
votes
0answers
32 views

dropdown values from different sheet/spreadsheet

I have been following the tutorials of Learn Google Spreadsheets and are stuck with the following. In my HTML file, I have got a select/dropdown menu that gets the values from a spreadsheet. That's ...
1
vote
1answer
2k views

How to reference a dynamic range in Google Sheets Script?

I have a sheet where the filter originally started on row 2, so my range was A2:J. As I've added and deleted rows/columns, my range has changed and it's still changing as I edit the sheet. Is there ...
0
votes
1answer
98 views

Cut and paste data from a row of cells from one tab to another tab in Google Sheets and repeat with new data

The below code works for Q3 but not for Q5. I'm relatively new to sheets and writing code and I'm sure that you can't have two functions with the same name but am unsure how to resolve so that I can ...
1
vote
0answers
27 views

How can I send an email, with an attachment from the user's local storage, using Google Sheets Script?

I'm new to Google Script but quite experienced in Excel VBA. I'm trying to set up a Google Sheet to enable sending of a given document by email attachment to a number of recipients. I've got the email ...
-1
votes
2answers
17 views

How to archive cell changes in new tab?

I have a Google sheet that I'm collecting some statistics in. There is a particular cell that I'd like to track changes in a separate tab. I'm looking for a function to copy cell if the cell data ...
0
votes
1answer
390 views

Google sheets IF OR script

So this is the code that I'm using for the script that I found; function onOpen() { var s = SpreadsheetApp.getActive().getSheetByName('Todo'); s.showRows(1, s.getMaxRows()); s.getRange('D:D') ...
0
votes
0answers
24 views

How to getFullName()

I would Like a code example how I can get getFullName(), in Google Sheets. Basically, I have multiple users using Google Sheets and would want that every time they edit I cell in the Sheet, there ...
0
votes
0answers
107 views

Function GetRange not found in Google App Script

function importCSVFromGoogleDrive() { var file = DriveApp.getFilesByName("data.csv").next(); var csvData = Utilities.parseCsv(file.getBlob().getDataAsString()); var sheet = SpreadsheetApp....
-1
votes
1answer
23 views

Which event can I use to detect remote form submission into sheet?

I'm using the WordPress Contact Form 7 plugin as a website contact form. The user's date is submitted to a google spreadsheet and stored as a new row. Which event can detect that that information was ...
0
votes
0answers
51 views

No HTML file named CreatorNotification was found. (line 241, file “Code”)

I keep getting emails with the following: Error Message /Trigger respondToFormSubmit No HTML file named CreatorNotification was found. (line 241, file "Code") /formSubmit I don't know what ...
0
votes
2answers
799 views

ImportXML not loading due to number of requests

I am working on this sheet and it has a lot of ImportXML requests between columns N-Q. And because of the high number of requests, it seems like the ImportXML function is not working properly (it ...
0
votes
0answers
12 views

How do apps script to update data changes to many spreadsheet files?

I created a apps script to combine data from many spreadsheet files. The file names are: Task_Day1 Task_Day2 Task_Day3 All Task data is combined into one in the Combine_All_Task sheet. Each Task ...
1
vote
2answers
57 views

sheet name from cell (formatting issue)

I have been tasked with creating reservation sheets for a restaurant. The sheets are for internal use only so the only people with access to these sheets are the staff in the reception, reservations ...
1
vote
1answer
427 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
3answers
46 views

Else statement is executing when TRUE

I am completely new to coding. I am a teacher and trying to design a lesson planner tool using Google Sheets Scripts. The idea is to have a template sheet for the lesson that will copy into a new tab. ...
0
votes
0answers
253 views

How do I send an email on a Google Sheet when certain cells change using the Apps Script?

I created a script to send email on Google Sheet with the following conditions: When the Assign Email column is filled in and the Status column changes to In Progress, then the notification will ...
0
votes
1answer
36 views

Auto-jump on today's date upon upening the spreadsheet [duplicate]

I use a spreadsheet with a date in a row per column. I would like to have the sheet open on the current date when opening. How can I make this?
0
votes
2answers
57 views

How to read * .tsv files from a local drive into a spreadsheet file using Apps Script?

I have a *.tsv file in local storage on my computer. I want the file to be read from the apps script then the contents of the file are copied into a spreadsheet file. I do not want the file to be ...
0
votes
1answer
37 views

Script sometimes it works sometimes it dosent

I have 2 columns to enter Lat and Long coordinates in ( E and F ), those also contain the Formulas (for all rows, I just happened to choose row 768below) =IFERROR("N"&left(index(Split(D768,"N"),1)...
1
vote
2answers
261 views

Sorting columns with script instead of macro

I currently use a macro script to filter my sheet upon opening the sheet by column A, and I wondered if there was a more efficient/simple way to do it with scripts? function Sort() { var ...
0
votes
1answer
233 views

How to get correct TimeZone in googlesheet using script?

I have wrote following script in my google sheet hoping to convert a timestamp in GMT to a customized timezone. function myFunctions(datetimeString,timeZone,format) { var moment = new Date(...
0
votes
2answers
90 views

Auto Create New Google Sheet With Column Headers Based on List of Names

I'm trying to create a VERY basic CRM tool. I want to create a running list of customer names. Once I enter a name in Column A I'd like a new Sheet automatically created with pre-set columns I can ...
0
votes
1answer
888 views

App Script to move a row of data from one Google sheet to a different one (different sheet id's) based on a cell entry

I'm currently trying to adjust a script I found that copies the contents of a row from one tab of a google sheet, pastes it into the next descending empty row in a different tab and then deletes the ...
1
vote
1answer
949 views

How do I get Google forms edit url to work

I want to generate an edit url link in the google sheet for a google form which is linked to it. There are already instructions on how to do it. However they do not work for me. I have followed the ...
1
vote
3answers
434 views

Using a script to only take only take cells with values in google sheets

tl;dr how can I make the script take an entire column (eg A:A) and then ignore the first (header) row, and any blank rows? Background I have an array in Google Sheets with date-ordered data (note ...
0
votes
0answers
311 views

How to copy cell to clipboard

I have a hyperlink on every row (in multiple worksheets) that I would like to, when clicked, copy the info from column 9 of the same row to the clipboard before opening the link so that it can then be ...
0
votes
1answer
60 views

Put Date in Specific Column

I found the following code in another post here to add a date after an edit but it places it in an offset column, I would like the date in Column 8 if column 3 or 4 has been edited. What do I change? ...
0
votes
1answer
259 views

How to timestamp on new added cells in LIVE google spreadsheet?

The code below insert timestamp in google sheet by editing another column. However, there an issue which I have no idea how to solve. When I add new row manually, it successfully adds timestamp, BUT ...
0
votes
0answers
46 views

Hide columns with certain dates

I would like to have a google sheet as a presence list. In the first 3 colums there will be person names, in the first rows the dates of the events. I would like to hide on open all columns (exept ...
0
votes
0answers
10 views

onEdit function does not perform below functions

I've got problems with my GAS below: The problem is, that sendSms() function does not work after editing sheet. //Datownik function onEdit(e){ var ss = SpreadsheetApp.getActiveSpreadsheet(); ...
1
vote
0answers
34 views

Change button image on click

Is there a way I can change a button image on click? At the moment I am using circles over an image which I am switching between red and green. is there a way I can automate these into buttons that ...
0
votes
2answers
257 views

Using NumberRangeFilterBuilder for a slider controlled variable input?

I've been looking for a slider control in sheets where I can play with a variable input by moving the slider left or right. Within the following example: A1 = Value | B1 = VAR | C1 = A1*B1 I want ...

1 3 4 5 6 7 27