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

Duplicate row values to next row, based off specific column

I'm trying to set up a button that will copy information from the last row and paste it into the row right underneath (based on where column D last has a value). Almost like a "duplicate" ...
0
votes
0answers
17 views

Google Apps Script: Appending data to a Spreadsheet if it is already not present

I am new to Google apps script and I am trying to write a program where whenever I scan a data. The scannedData should only be appended to the spreadsheet if and only if the data is not already ...
1
vote
0answers
14 views

Removing Last Updated value when No data was selected from the column to check

I need help on my Google Sheet script. It is working fine on showing the timestamp of Last Updated at colB every time a new Call Status was set at ColA ; but when I deleted the status at colA, the ...
-1
votes
0answers
17 views

script for a button to add value of cell to existing value of cell on another sheet, google sheets

I'm trying to make a button on a spreadsheet for an apparel manufacturing business, I have one sheet that we use for stock on hand that then feeds requirements into two other sheets for cutting and ...
0
votes
0answers
11 views

A Script that Allows a Checkbox to Recognise a Value via Formula and Copy to Another Cell

Is it possible for: a set of checkboxes to recognise lists (grouped in one cell) on entry (via formula) to then have the same checkboxes copy the list to another cell as it returns "TRUE" ...
1
vote
0answers
15 views

How to delete old rows in Google Spreadsheets?

Hi i have a google sheet that collect tweets from twitter. i need a function that should delete rows that are more then 2 weeks old. here is the sheet https://docs.google.com/spreadsheets/d/1Zhhl6-...
1
vote
0answers
24 views

Link audio files in Google Drive folder in a Google Sheet

I have hundreds of audio files (.mp3) in a Google Drive folder that I need to list with links in a Google Sheet. Very similar to the problem described here, but I was not able to adapt the code to ....
0
votes
0answers
26 views

Google Sheets: Link/Sync Two Cells Dynamically (based on a third column's data)

I want to preface this by saying this is NOT a duplicate of Sync two cells value. It's similar, and uses the OnEdit() Function of Google Sheets, but the solution presented in that thread only works ...
0
votes
1answer
10 views

weird bug(?) with getValue returning “You are trying to edit a protected cell or object”

This is just...bizarre... I'm running a function with a user that does have full Edit access to the Sheets in question. This code: function test() { var ss = SpreadsheetApp.getActiveSpreadsheet();...
0
votes
1answer
25 views

formatting currency to be used in an email

I'm summing a range from a Google Sheet, then putting the results in the body of an email as currency. But I'm running into formatting issues that seems surprisingly hard to deal with. The range of ...
-1
votes
0answers
32 views

How can I duplicate a Google sheets tab multiple times and retain the protections for each tab?

I found a great script from this community that allowed me to duplicate the tab while retaining the permissions, but I need to do this several times. For example, I need it to duplicate tab '1' 49 ...
0
votes
1answer
55 views

Google Sheet jump to current date on Open (very large sheet)

I understand that this question has been asked before but most users seem to only have the dates in one column or a limited number. The sheet I am trying to work with has the schedule for one entire ...
0
votes
1answer
32 views

Script to SUM Values

Can you help me please? I want a script to sum rows after a name change. Something like this: COLUMN A - COLUMN B - COLUMN C - COLUMN D - COLUMN E aa - aa - 5€ ...
0
votes
1answer
21 views

Google Web App Vlookup

I'm looking to create a simple Google Web App with a single field that accepts input and uses VLookup to match data in column A and return data in the column B of a Google Sheet. Can someone point me ...
0
votes
1answer
41 views

Generate Table from Sheet to HTML Web App using Google App Script

I am working on a web app via Google Script where every time I search for a specific text it will generate a table that I linked in Google Sheet in that Web App. This is what I have so far: Google ...
-2
votes
1answer
35 views

Setting up hanging indent in paragraph

I have found in the documentation references to first line indent or end indent for a paragraph. But how do I set a hanging indent using Google Apps Script?
0
votes
1answer
19 views

Automatically update inserted sheets cells in Google Docs

I have a Google Doc which has linked cells to Google Sheets. I want to type a Script that automatically updates the document whenever the cells in Google Sheets are changed (it receives answers from a ...
0
votes
1answer
51 views

“Exception: Service Spreadsheets failed while accessing document with id” when using insertCells

I have a confusing problem. I'm using GAS to shift several cells down by one. Worked fine for a while, then I started getting this error message: Exception: Service Spreadsheets failed while ...
-1
votes
1answer
22 views

Google Scripts Sheets Conditional Sorting

I just recently discovered Google Scripts, and I was wondering if there was a way to sort by a function. For example, if the values in column B were in the range of all real numbers, would there be a ...
0
votes
1answer
27 views

Change File Name Automation in Google App Script

I am working on a script in App Script that will change the file name of all the files in a certain folder based on their creation date using this format yyyy_MM_dd_filename. I was able to create the ...
0
votes
0answers
22 views

Automatically append database query results to a Google sheet

Looking for conceptual help in automating the appending of data to a Google Sheet. I have a PostgreSQL database currently hosted on Heroku (AWS) that is backing a Ruby on Rails application. What I'd ...
0
votes
0answers
10 views

Created an OnFormSubmit trigger but still getting error

I'm trying to create a script that will populate a Google Sheet template based on a Google Form--basically, following this verbatim . My code looks like this: function onFormSubmit(e) { //open the ...
0
votes
2answers
25 views

Insert text in every Nth cell

Here is the sample Spreadsheet: https://docs.google.com/spreadsheets/d/1wlO33EWcERa0yYL2xb3BINFt5f441p9MbcB2mPe8eZQ/edit?usp=sharing I need to insert the text in cell D1 into every third cell in ...
-1
votes
1answer
40 views

How to change specific cell to Zero

I'm currently using this code I got from Google. But the problem is it changes not only the range I specify which is N9:N14 but it goes til N54 whats wrong with this code I want only these ...
0
votes
1answer
17 views

Google Script returning full timezone information from a Google Sheet cell - how to stop it?

My project is using Google Sheets to create a register system for childcare in a school. Because of the sensitive information within the document, I'm not at liberty to share access to the project. '...
0
votes
0answers
23 views

Connecting Google Sheets / Gmail script with several Google Accounts

I have written a Google Sheets script which allows creating Gmail drafts based on data in a Google Sheet. This currently only created drafts for the user who is currently logged in. Is it possible to ...
0
votes
0answers
21 views

Is there a way to pull first modification date from a cell with Google App Script?

I have a bunch of Google Spreadsheets with a lot of data (inputs from a webpage from past years), but unfortunately, there was no column with a timestamp at that time. Is there a way to pull from ...
-1
votes
1answer
15 views

How to show dialog box in the Google Apps Script itself?

How to show dialog box in the Google Apps Script itself? ScriptApp has no getUi() method.
0
votes
1answer
27 views

Need help with Google Sheets moving rows and setting formatting upon move completion for Google Sheets Script

I have a script which I use to copy rows with checked checkboxes to a "Copmpleted sheet". The script is set to run on a timer and it works without any issues. The script and description can ...
1
vote
1answer
18 views

Google Docs footer error

I got the below script for automatic "last edited" timestamp in the footer of a Google Document. function lastEdited() { var doc = DocumentApp.getActiveDocument(); var id = doc.getId(); ...
0
votes
0answers
40 views

How do I pass hidden metadata into a Google Apps Scripts HTML service?

I found this interesting question: How do I record the value of GET parameters passed to a Google form in hidden inputs? One of those answers says: Google Forms doesn't supports hidden form fields ...
0
votes
2answers
27 views

How do I change the date to the coming Monday every Friday at 9:30 pm in Google Sheets?

I would like to write a function that checks what day of the week today is, and whenever it is Friday 9:30 pm it should populate the cell with the date of the coming Monday. So since today is Friday ...
0
votes
0answers
39 views

Copy from individual cell in Google Sheets Table Chart

I'm using appscript to build and insert a table chart into a sheet when a button has been pushed. var chart = sheet.newChart() .setChartType(Charts.ChartType.TABLE) .addRange(outrange2) .setPosition(2,...
0
votes
1answer
39 views

Randomly mark the column based on the percentage of the total data from each operator

I have data as in this link. The data will be checked by several operators. Each operator must check data as much as 50% of the total data of each operator randomly. If the number of data from the ...
0
votes
0answers
12 views

How to auto-reply to reply-to field?

I would like send auto-reply mails to email addresses written in reply-to field. How this can be achieved? Sample Mail Received : from: abc@gmail.com reply-to: def@gmail.com to: ghi@gmail....
1
vote
1answer
25 views

How to create dynamic text which include values from cells for alert in Google Sheets script?

I wrote the script which transfer values from one sheet to another sheet. I added message of confirmation (alert) which is showing list of values before their transfer: var response = ui.alert('...
1
vote
1answer
46 views

Need help with Google moving rows on open for Google Sheets Script

I am fairly new to Google script. My knowledge of Java is limited as well (I believe the two are similar). I have a script that moves rows when a checkbox is checked. It also adds some rows and does ...
1
vote
0answers
19 views

Setting Unique Data Validation using For Loop

Right now, I am manually adding data validation one by one to a column of cells. This is because each validation range is unique to the row. The validation list I'm looking to create should only ...
1
vote
0answers
29 views

How to keep same protections/settings when making a copy of a Google Spreadsheet? [duplicate]

I have a spreadsheet that I want to create about 100 copies of at once, all copies with different titles. I found a script that allows me to do that, all I have to do is fill out information from cell ...
0
votes
1answer
20 views

How to open a specific tab based on today's date (Google Sheets)

I've made a 'Google Sheets' with 31 tabs for the dates of the month (1-31) How do I write a script that makes the spreadsheet open to that days tab? e.g. open tab 25 if today is Aug 25th I imagine (...
0
votes
0answers
23 views

How to Create Find and Replace Function for Google Drive File Names with Google Scripts

Basically, I have a bunch of files in a shared google drive, let's say: AA123_1.jpg AA123_2.jpg AA123_3.jpg ... I am trying to get rid of all of the "123"'s and replace them with an empty ...
0
votes
0answers
34 views

Script to add a new row and copy the formula that is in each cell

I am trying to work out a script so that when I press the + image on the attached screenshot it adds a new row and copies the formula that is in each cell. At the moment, I have the following script ...
0
votes
0answers
21 views

Pasting values only instead of copying values using a script

I have a piece of code put together through various posts, it is used to move multiple rows into the "Billed" sheet. Unfortunately it's missing a key feature, namely that I need the script ...
0
votes
1answer
119 views

FedEx Tracking in Google Sheets

I work for a company that sends packages out daily. We track the numbers in a Google sheet that populates via a Google form we use. Recently we have had some packages go missing and I have been tasked ...
0
votes
1answer
39 views

How to Copy Cell Value and Format From One Tab to Another Using a Formula?

An answer was provided in this question: webapps: Cell reference with colour formatting for doing so within a tab, but not across tabs. Does anyone have suggestions for a script that will work across ...
0
votes
1answer
22 views

Script that reads rows and columns in a sheet and returns strings with frequency of occurrence

first time caller! I have a single column that contains comma separated names (lots of names) -- I am trying to find a script that can read the comma separated string entries in cell and give me a ...
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 ...
0
votes
1answer
110 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,&...
1
vote
1answer
60 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 ...

1
2 3 4 5
28