Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
0
votes
1answer
336 views

How to navigate to a certain sheet in Google Sheets?

In my previous related question, I asked how to navigate to a certain column, however, now I also want to navigate to a certain sheet. So I need a link from a cell, and by clicking it, I want to jump ...
0
votes
0answers
18 views

PLease check my delete Function

I modified some google apps script but cant get right the delete (Hapus) function...please see the code below var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/...
0
votes
1answer
280 views

Google Spreadsheets timestamp

I'm trying to have a timestamp automatically appear in column L (12) in a Google Spreadsheet if a tick box is ticked on the same row (in column A). The app script code that I modified from this source ...
0
votes
0answers
303 views

how can i find and append a cell with script editor in google sheets

I have a script that will find the value in a lookup from column b and column a what I am trying to do is find the row and append the data in column n of that row is there a way of doing this, the ...
-1
votes
3answers
316 views

How to run multiple OnEdit scripts in the same sheet?

I am using an auto-timestamp script in Google Sheets. Where when you input something in a particular cell, the script will automatically add a timestamp in a particular cell. But the problem is that I ...
0
votes
0answers
48 views

One script for multiple tabs in one Google sheet

Can you please help me with this script? I've tried to edit it to apply to multiple tabs the same as the original question. But I think something's amiss. :( Here's the original code and I want this ...
0
votes
1answer
46 views

Reference all tabs with a specific word in COUNTIF statement

Basically, I am trying to make a master tab that adds up all of the data from all the other tabs. These tabs are weekly breakdown numbers for ad statistic numbers, so there is a new tab added every ...
1
vote
1answer
390 views

How can I prevent editors from accessing the script editor in Google Sheets?

I have an auto sort script on a Sheets document that I will be giving multiple people editing permission to, to add to the file. I have created a trigger so the script also runs when other users edit ...
0
votes
0answers
85 views

How to select activated sheets cells in Google script, rather than sheet by name

I need my script to talk to the "current sheet" rather than sheet by name. Code as is, selects cells from sheet 2019 but I want the script to copy the values from the current sheet, and paste into ...
0
votes
0answers
36 views

How to use Google Apps Script to skip slides in a Google Slides presentation?

I want to use "metadata" in the speaker notes for a slide to determine whether to skip the slide. The API provides a way to get the notes, which I can then read; does a method exist to apply the "...
0
votes
0answers
60 views

Trigger script in Google sheets with Zapier action

Is it possible to set an action in Zapier (like webhook) to trigger a Google sheets script? What's the right way to set this up? This has been driving me crazy so I hope there is someone out there ...
0
votes
1answer
82 views

Using a script someone else made in Google Docs

I was looking for a script to add to a Google Doc that would automatically insert the current date into the document. I found the script on this page. The last step is to authorize the script and ...
0
votes
1answer
1k views

How can I attach a file to an email using Google script?

I'm using Google Script to send emails, but I'm not sure how to add attachments (multiple attachments). I am also not sure where to add the code for it either. The file is on Google Drive and I need ...
0
votes
0answers
13 views

Sort sheet1 according changes in sheet2

I'd like to sort range in sheetN2 if data in sheetN1 are changed, but the script doesn't work. Could anyone tell me where the problem is? function onEdit(event){ var ss = event....
1
vote
1answer
65 views

How can I disable the authorization needed to open Google Sheets Macros?

Whenever I try to open any macro enabled sheets it requires authorization, even though it's a first party application. Is there any way to stop Sheets from asking it or give permissions to everyone I ...
2
votes
1answer
5k views

Delete multiple sheet tabs in Google Sheets

In a Google Sheets spreadsheet (Excel terminology = workbook) is it possible to delete multiple tabs (Excel terminology = worksheet) in one go without having to right click each one and delete it.
0
votes
1answer
48 views

What is the updated method of “CalendarApp.openByName”

We use a that gather the registration from Google Form and add them in our Agenda, our script uses the method "CalendarApp.openByName" to add the name automatically inside a Cell. It says the method ...
0
votes
2answers
50 views

Remember each user's last cell cursor location?

Is it possible to have Google Sheets remember each user's either last cursor location or last edited cell or preferably the value of the cell in Row2 that matches the current date? (In Row1 I have the ...
1
vote
2answers
345 views

How to create a function to “Save as” CSV file?

Here is my situation, I have Google sheet with just one sheet, so I allow the user to enter data there by just filling each row, ok, I have created a little script to add and extra custom menu, just ...
0
votes
1answer
198 views

In Google Sheets how can I view which cells are protected?

In my Google Sheets spreadsheet I set the Protection for some of the cells so that "Only You" can edit (only myself can edit, but the dialog text reads "only you"). Other cells do not have any ...
0
votes
0answers
18 views

Creating a hyperlink from same cell as text entry

The following code, from its original state, would let me enter a text value in column4, and the code would convert the entry into a hyperlink from what was entered. I tried to take it one step ...
0
votes
1answer
371 views

Add file submitted to specific folder based on answer in google forms

I'm trying to create different subfolders for uploaded files based on the multiple choice question i have in one of my google forms. The form is for certain locations, so based on the location that ...
0
votes
0answers
37 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
73 views

Typing in a particular cell and convert it in upper case [closed]

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
49 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
39 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
444 views

Google Form File Upload - Change file name to match form value

I have a Google Form for contact information. The form asks for Given Name (col A), Family Name (col B) and a File Upload restricted to images only (col D). I have a formula which displays the Full ...
1
vote
1answer
524 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
37 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
72 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, ...
2
votes
1answer
36 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
13 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
407 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
34 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
26 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
31 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 ...
1
vote
1answer
452 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
18 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
44 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
192 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
55 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
612 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
3k 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
20 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
21 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
37 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
190 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
25 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
90 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
303 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 ...