Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
0
votes
0answers
5 views
Auto date cell when opposite cell is populated - problem with script
This question has been asked here and I'm posting a new post because I couldn't figure out how to reply to that one.
I installed the script and saved it but no date appears in my sheet when I insert ...
0
votes
2answers
15 views
Typing in a particular cell and convert it in upper case
After I typed in a cell a text value (this is in lower case), what do I need to do (after typed it), to become it as the upper case?
How do you change the case to upper case for a whole column in ...
0
votes
0answers
12 views
Auto date insert when opposite cell is populated in different columns - only if in a particular sheet in a document
I found this solution to autoinclude the date in a column when another one is modified and it works great. Auto date insert when opposite cell is populated
What Im looking to do is:
To modify this ...
0
votes
1answer
16 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
1answer
16 views
Using Google Script to place Duplicated Google Form Responses in one Column?
I have a Google Form, with multiple sections, and duplicated questions. Google Forms Automatically creates separate columns in the resulting Spreadsheet for each question, even if it is the exact same ...
0
votes
2answers
18 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
23 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, ...
1
vote
0answers
17 views
How do I lock a sheet in Google Sheets at a specific time every day?
I would like the sheet protected from 6pm - 10pm every day. I have the following script but it doesn't seem to protect the sheet at the designated time. I have this script with the Time-based trigger, ...
0
votes
0answers
10 views
How does one import an RSS url as a RSS formated URL?
Currenty
I am currently trying to aggregate a few of these urls in order to pull html which I want to display in my Sheet.
Problem
But currently I am just importing RSS from a news aggregator using ...
1
vote
1answer
35 views
How can I set a background color for an entire paragraph?
I want to programmatically style a paragraph with a background color to make a "code area", just like when using a triple backquote around a paragraph in Stackoverflow, or like in this question. I ...
0
votes
0answers
14 views
Auto timestamp based on specific value
Currently, I am using below code to update timestamp in the next column. But I want to modify the code to update timestamp only when the cell value is True not on a change of cell value.
function ...
0
votes
0answers
19 views
Google Sheets: auto-format an entire column to be hyperlinks upon import
Here's my process: export CSV from CRM > import to Google Sheets > do work.
In ColA are unique IDs (all integers e.g. 808938269) of accounts in my CRM. I would like to appended a generic [URL] string ...
0
votes
0answers
19 views
Google Script to Show Rows if cell value
I am working on putting together an Expense Report that allows a person the option to add another expense (up to 23 expenses allowed).
I want the rows that need data entry to be hidden unless the ...
0
votes
1answer
30 views
Is google app script able to move a specific folder to the other one on google drive on time or condition triggering?
I refer a article to do what I want to move a specific folder to the other one. (The reference article is on the bottom.)
Is it possible to move just the content only?
I made it. But, it also moves ...
0
votes
0answers
11 views
Help with a script for google sheets so that both ends of a link can be edited
so I found a great answer to a question that I had about connecting two different spreadsheets with a link that would allow you to edit either one and the other would update, I found a great page on ...
0
votes
0answers
16 views
Help with a two way link script for google sheets
so I found a great answer to a question that I had about connecting two different spreadsheets with a link that would allow you to edit either one and the other would update, and I found this great ...
0
votes
0answers
16 views
Master Checkbox that turns off other checkboxes based on keyword in a different cell
I'm trying to create a master checkbox (actually a few) that toggle on/off various other columns of checkboxes on the same sheet.
I have researched this issue and found only solutions either A) ...
0
votes
1answer
25 views
How can I compute the permutations multiplication “like” table to a linear list?
I have a table that is structured like this.
I would like to transform the table into the permutations of the table if we treated like a multiplication table. Into a list that looks like this.
...
0
votes
0answers
16 views
Google Drive - How can I unzip multiple zip files? (using Wikunia's Google colab/python method)
I actually would've just posted this as a comment under @Wikunia's brilliant colab answer, here, but I'm new (sorry!!):
Basically, that works, and it works perfectly, but I'd like to genericise it to ...
0
votes
1answer
14 views
How to move a row into another sheet?
In Google Sheets, I need to hide rows if column H says, "Completed"
My preference would be to cut and copy the row to a new sheet if column F reads "Completed", but sounds more difficult.
If you ...
0
votes
0answers
16 views
Google script full up the database
I have make more questions for this topic, the scrips are working, but i will add more cells to the script.
The script what i have.
function myFunction() { var spreadsheet = SpreadsheetApp....
0
votes
0answers
16 views
macro for google sheets that can transferm data
I have make a macro in google sheets for transfer data from a cel to an other cel
function myscript(){
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
spreadsheet.setActiveSheet(...
0
votes
0answers
26 views
Auto update date in google sheets based on edit in range of cells [duplicate]
I want to update a timestamp based on the last time any cell in a range is updated.
I added this script:
function getDate() {
return new Date();
}
In a cell I use the formula:
=getDate(D5:AF5)
...
0
votes
0answers
27 views
Google Drive - Get Image sizes
Is there a script that I can use to get the images sizes within a folder on google drive?
0
votes
0answers
17 views
unique numbers based on respondent's answers
I am managing a group of participants (example: doctors, nurses,etc) in filling the form, each participant chooses an option according to his goup (doctor, nurse, etc) i want different sets of unique ...
3
votes
1answer
50 views
My Add-On was approved by Google, but it is available only to members of my employer's domain
I developed an add-on for Google spreadsheets, have sent it over to Google for a review, and after much blood, toil, tears and sweat, had it successfully approved.
Yet, the add-on is only available ...
0
votes
0answers
20 views
Sending array in payload with UrlFetchApp.fetch
I'm trying to figure how to use the UrlFetchApp.fetch method and have this test for see what works. It's supposed to check with a events site to see if some guys have indicated that they're attending ...
0
votes
0answers
11 views
setValues not working how I want to
My script pulls data via a JSON request on a time trigger.
Another function makes a summary of that data based on the filter in place.
Both parts work, however whenever it pulls new data and the ...
0
votes
2answers
14 views
How to extract hovered links from a cell in Google Sheets?
I have set up this demo spreadsheet.
Can someone please help me extract the URL?
0
votes
0answers
14 views
Is it possible for a Google App Script to convert a file in the cloud?
Is it possible for a Google App Script to take a file from Google Drive, such as a PDF, video, image or .rar file, perform a conversion to it, to convert it to another format, then upload the ...
1
vote
1answer
15 views
How to date/timestamp for modifications in Google Sheets?
I have a sheet that has information in 8 columns starting in row 14. I would like I14:I310 to date stamp anytime there is an update in the corresponding row. I have tried a couple of different ways ...
0
votes
1answer
43 views
How to use custom function with arrayformula?
I'd like to use a Google Apps Script custom function in conjunction with arrayFormula so this may be applied to a range. How do I achieve this?
Let's say I have wrote a function that will return ...
1
vote
1answer
18 views
Can the superadmin account manage other users drive folders and files?
Assuming a Google Apps Script has been granted authorisation by the superadmin account to manage Drive files & folders, can this script perform operations on other-users Drive folders & files, ...
0
votes
2answers
19 views
Restrict or prevent drawing functionality?
I've created a Google Sheets spreadsheet that is shared with anonymous users. All users have Edit permission because I want them to contribute data to the spreadsheet.
The problem is that some users ...
0
votes
1answer
56 views
Google Apps Script: print, open or download as PDF a Google Doc?
I have created a Form that will run a script on submit to dynamically generate a google doc. So far so good.
What I miss is a way to:
Print the document (open the printing preview in browser)
...
0
votes
1answer
26 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
0answers
20 views
Get data from a column and paste it to another sheet
I saw this script in one of the questions here and modified it a little:
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet1 = ss.getSheetByName("RAW");
var ...
1
vote
1answer
27 views
Google Forms sending me duplicate email on automatical email
So, I've used this code, just reworked for my needs:
Can Google Forms send emails automatically?
The problem I have is that the account that sends those emails also receives them. Is there a way to ...
0
votes
1answer
23 views
Run a Script When Tab Programmatically added to a Google Spreadsheet
I'm trying to pull data from an Adwords report to a Google Sheet through an Adwords script. This will be done on a daily basis. Every time the Adwords script runs, a new tab is created (and an old one ...
0
votes
0answers
11 views
Copy template to a new sheet referencing a cell number that is to increase incrementally
I have a template sheet that I would like to be able be able to copy with a unique name.
Needing a single function to execute these steps:
The document containing TEMPLATE is opened
Button is ...
0
votes
2answers
53 views
Protect spreadsheet against duplicate data and sheet addition/deletion
There are some people that love to troll and spam my Google spreadsheet with useless info. Google Sheet lacks granular permission restriction.
I need to prevent duplicate data from being submitted. I ...
0
votes
0answers
6 views
How to alphabetize all worksheets in a Google Sheets project
I am trying to alphabetize all worksheets within a Google Sheets project (there are around 150 worksheets in one project.) I have tried the following script, but it places the worksheets in random ...
0
votes
1answer
44 views
Spell check with formula or apps script
I have text in the table. I want to check the text whether there is a typo or not. Usually to check my typo using the default Spelling Tool from Google Sheet.
The question is: Can the spelling check ...
0
votes
2answers
47 views
How to quickly re-arrange sheet order in Google Sheets?
If I have a Google Sheets document (Workbook in Excel terms) with 20 sheets (Worksheet in Excel terms) and I want to rearrange the order of the sheets currently the only way I know to do this is to ...
0
votes
1answer
13 views
How to re-calculate a Google Sheet every time a Google Forms questionnaire is submitted?
I used Google Forms to create a questionnaire, and I created a formula for Google Forms answers using Google Scripts.
After that, I want to re-record the calculated result on the Google Sheet every ...
0
votes
0answers
18 views
How to record Google Form responses back to Google Sheets
I am a beginner in Google scripts.
I have learned how to write to a Google scripts sheet using the examples below. However, I do not know how to set the range ("?") Because the range ("AB7") will ...
1
vote
3answers
59 views
Timeout error while running script to get ames with address, phone number, email, and job titles
I have over 500 contacts in Google. I am wanting to list all the contacts that are associated with a particular company into a sheet. When I run the following script, I receive a timeout error.
...
0
votes
0answers
77 views
Upload from URL (on Google Sheet) to directly in Google Drive
I have a google sheet on which links are generating (by calculation) for downloading / uploading in G-Drive.
I want when links are generated, I can upload file (from generated link) to directly in my ...
0
votes
0answers
15 views
Retrieve specific value from pivot table
I have several sheets with a pivot table in each sheet.
Each pivot table has the same structure of data, with 2 columns and 5 rows:
5 labels with a numeric value and the percentage of the total ...
1
vote
2answers
25 views
What function can I use to conditionally format text depending on cursor position or active cell?
In Google Sheets, I have a 'Freeze' on Column A.
I want the text in Column A, Row X to Conditionally Format as BOLD RED, while my cursor is on any cell for Row X.
Is there a way to manage that?
