Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
0 votes
0 answers
16 views

How to make a script through matching data and paste values to specified fields?

First I would like to point out the fact that I'm nowhere near to the level of a professional programmer. I'm only in the phase of learning and doing it as a hobby. I'm trying to create a script in ...
user avatar
0 votes
0 answers
15 views

Number of lines in Google Slides

I've worked for several projects with google slides in appscripts and slides API as well. However recently I've needed to know the number of lines present in a google slide.(There are no line breaks ...
user avatar
  • 1
0 votes
2 answers
70 views

Converting Google Sheet to JSON format while rows are vertical

I am trying to convert the Google Sheets into JSON format using Google App Script. It worked but I am not getting the right format and I am little struck. My sheet looks something like this in the ...
user avatar
3 votes
1 answer
154 views

Regex for JSON parsing in Google Spreadsheet Cell

I wanted to use the formula from this topic to extract "count" value in this JSON from a Google Sheet cell. [{"year":2022,"month":2,"count":720},{"year&...
user avatar
0 votes
0 answers
18 views

Running a script on select tabs in Google Sheets [duplicate]

I am not a coder, but I can normally do enough trial and error to get my script to function in the way I want my google sheet to work. The goal of my script: I want cell A to time stamp anytime that ...
user avatar
0 votes
1 answer
46 views

Problem in adding formula in script for updating daily

Newbie to sheets and scripts! I have seen this question,and am partially successful to the extent of creating a new row with date being updated using this script var ss = SpreadsheetApp.openById("...
user avatar
  • 199
0 votes
1 answer
68 views

How to create static/immutable autoincrement column

I am aware of the manual way (add 1,2 in the first 2 rows, mark them, drag the square on the mark-outline down to where u need the numbers) and a number of ways to create the numbers with formula's, ...
user avatar
  • 1
0 votes
1 answer
31 views

How to use a range function with VLOOKUP Google Sheets

I created this function to get the range from sheets dynamically function GetSheetRange(j) { return SpreadsheetApp.getActiveSpreadsheet().getSheets()[j].getRange(3,1,1000,7).getValues() } I wanted to ...
user avatar
0 votes
1 answer
41 views

Way to keep spaces in Google App Script alert?

SpreadsheetApp.getUi().alert('foo bar') When I use this piece of code, it appears as 'foo bar', removing the additional spaces in between. is there a way coerce Google App Script to do otherwise?...
user avatar
  • 471
0 votes
1 answer
23 views

How to automatically insert datetime across multiple Google Sheet tabs

I have 6 tab Google Spreadsheet that is actively being updated with data into each individual tab. What I am looking for is to enter date-time stamp after each and every entry across all tabs. I have ...
user avatar
0 votes
0 answers
57 views

How to see comment count in Google Docs

I used to be able to see the number of comments in Google Docs as a small blue oval with the number in it, on top of the comments button, but now it's gone. How do I make it come back?
user avatar
0 votes
0 answers
44 views

Scraping Directory contents from Google

Does anyone know of a good way to scrape the information from the Directory in Google Contacts? I saw this How to download all directory contacts?. I tried to run it by following the steps layed out, ...
user avatar
0 votes
0 answers
16 views

Changing Future Monthly Sales Goals Based On Previous Monthly Sales

What I have is a spreadsheet which needs to calculate future monthly required sales goals, based on an annual sales goal, and previous monthly sales. EXAMPLE: My annual sales goal is $1,200,000. This ...
user avatar
1 vote
1 answer
164 views

Version control for Google Apps Script project?

I am using Apps Script to add custom functionality to my Google Sheets: Trouble is, I would like to keep track of changes made to this code base over time. Git is the obvious solution, but I couldn't ...
user avatar
0 votes
0 answers
19 views

The onOpen(e) function stops execution halfway through [duplicate]

I have some code to convert data from a survey to a format that is easier to analyze and put it into a separate spreadsheet. Mind you as of now I am only dealing with 12 submissions. The code for ...
user avatar
0 votes
0 answers
98 views

Unable to correct Margins when converting Sheet to PDF and sending as email via app script

Attaching the snippet of my code. I have an input spreadsheet where the end-user enters in an email address. Then, the code will open my desired spreadsheet (Template1), converts it to a PDF and ...
user avatar
0 votes
1 answer
37 views

I am trying to find a custom function to find the min value of coloured cells ONLY for a range where some cells have a specific color

I am trying to find a custom function to find the min value of coloured cells ONLY for a range where some cells have a specific color. The best I could find is to count the cells with a certain color. ...
user avatar
  • 1
0 votes
1 answer
126 views

App Script dynamic data validation based on list

I have a list of user and data validation mapping in column A and B User Data Validation Customer Jim Customer Pam Customer Tim Employee Beth Employee ...
user avatar
  • 1
-1 votes
1 answer
215 views

Replacing text of links in google sheets

I have a bunch of links in cells in my google sheets. I want to replace all the text of them all just to say "LINK" so that when I click on them it's still hyperlinked to the correct site. ...
user avatar
  • 1
0 votes
1 answer
84 views

Script for macro button to transpose and paste data from selected row to selected cells

I need to come up with the script for an import button on my google spreadsheet, but I'm a little out of my depth. I have one Spreadsheet with two Sheets: Purchase Order template (Sheet2 = 発注書) ...
user avatar
0 votes
1 answer
58 views

Grant permissions on a shared google drive with script

I have google drive folder with subfolders, each subfolder has several google sheets and each sheet has a set of functions that run when users click on buttons, the issue is that for every time user ...
user avatar
0 votes
0 answers
33 views

Lock the value of a cell, even if the cells it references changes value

how do I Lock the value of a cell, even if the cells it references changes value? for example I need to populate range J5:j100 based by subtracting cell L2 and N2 after that I want to change cell N2 ...
user avatar
0 votes
0 answers
48 views

How can I edit a cell in Google Sheets which is linked to a file name in Google Drive?

I currently have a Google Spreadsheet with two columns - the file ID of a set of files, the file name. I want to write a Google Apps Script where when I change the file name within the spreadsheet, it ...
user avatar
0 votes
1 answer
109 views

Exception: The parameters (HtmlService.HtmlOutput) don't match the method signature for Ui.showModalDialog

Here is my HTML file "Creds.html": <form id="Creds"> Client ID: <input id="id" type="text" width="45"><br> ...
user avatar
  • 103
0 votes
0 answers
44 views

Need to run a script on all google tabs, but I can only get it to work on the active tab

Alright. Ive spent four hours on this and Im about tapped out. I have this script here function onEdit() { var sheet = SpreadsheetApp.getActiveSheet(); var oldName = sheet....
user avatar
0 votes
1 answer
21 views

How do I display an alternative charchter in a Doc that is pulling data from a sheet?

I have created an HTML form (not a Google Form) that populates a Google Sheet. The form has both text inpt and checkboxes (multiples of each.) On the Google Sheet, if a checkbox is checked on the ...
user avatar
0 votes
1 answer
17 views

How to combine cells of data in Googlesheet to a single/consolidate row and remove duplicates?

I'm trying to consolidate all the invoices that we get from the same contractor to a single row that will have the business name, all the memos/invoices for the week in one cell along with the added ...
user avatar
0 votes
0 answers
24 views

How can I make current Data and time show up in cell a1 and c1 respectively when I type a text in cell b1?

I am using sheets and I want my cell to auto-populate with the date today in one cell and the time now to populate in another, so this is what I've tried doing. I added the forumla in column C to show ...
user avatar
  • 1
0 votes
1 answer
31 views

Google App Scrips onEdit function timeout

I have an onEdit function running fine into googlesheets, it is basically a countdown timer and displays the countdown into a cell. However after around 30 seconds of running, the display no longer ...
user avatar
0 votes
0 answers
24 views

How do i make a trigger only work for specific people?

I'm trying to create a sheet where it sends an email when a check box is checked based off the information in the row of the checked checkbox. I've got everything working except it sends an email from ...
user avatar
0 votes
0 answers
29 views

Display countdown timer into custom shape with google app scripts

I currently have a countdown timer in google sheets using google app scripts as such: if(e.range.getA1Notation() == "G11"){ var ss = SpreadsheetApp.getActive(); var sh = ss....
user avatar
0 votes
1 answer
57 views

How to update multiple google sheet files on google drive from a template without changing the current values of certain cells

I created a google sheet template and then we created almost 200 sheets from that template, now we updated the original template, and I am trying to figure out a way to updated the 200 files without ...
user avatar
0 votes
1 answer
50 views

A way to "lock" and "unlock" a Google Sheet's contents

How can I create a cell lock / unlock mechanic in Google Sheets similar to Excel? NOTE: I know how to protect a google sheet and limit editing permissions to certain users. There are many similar and/...
user avatar
  • 103
-1 votes
1 answer
17 views

Both importrange and script are failing to copy all records

I have a Google sheet which uses an importrange function and has worked for several years. for some reason, it has suddenly started to fail to copy a couple of rows in the middle of other data and is ...
user avatar
0 votes
1 answer
45 views

Sort sheet tabs name alphabetically

This is a script I located to sort my sheet tab names alphabetically. Is it safe for me to use in my free version of Google Sheets? function sortSheets () { var ss = SpreadsheetApp....
user avatar
0 votes
1 answer
43 views

Google Sheets App Script Sorting

I'm trying to have an auto sort function only impact one sheet in a workbook rather than all of them. I've done this in other projects and def messed this up along the way - any help is appreciated!! ...
user avatar
0 votes
0 answers
19 views

Is it possible to generate response url of google forms without editing permissions?

I know, that there is a getEditResponseUrl() function, but it generates URL with editing permission. Is there any way to have this URL without editing permission, just response?
user avatar
0 votes
1 answer
22 views

Error on multiple myfunction in onEdit

I am getting an error ReferenceError: options is not defined at myfunctionFDI(OverallScript.gs:39:48)at onEdit(OverallScript.gs:3:1), when I am trying to run multiple myfunctions within onEdit, what ...
user avatar
0 votes
1 answer
51 views

Automatically apply a formula and a when a new row gets added via a form API

Hi I have a wordpress form, linked to a google sheet that transfers over entries as they come in, now I have some formulas applied, but I don't want to have to add the formula to each new row that ...
user avatar
  • 3
0 votes
0 answers
52 views

How to make a macro in Google Sheets that runs when a cell changes value and then formats a range based on the value in the cell

I have some formulas that pulls out data for different graphs in Google Sheets. These data can either be in full numbers (e.g. Revenue) or in %. I have a dropdown for each graph where the user can ...
user avatar
0 votes
1 answer
59 views

Improve script performance

I wanted to ask, if I can do anymore improvements regarding my runtime, currently it takes roughly 100s to finish my script(since adding the formatting script below). Before adding additional ...
user avatar
  • 3
0 votes
1 answer
101 views

"#NUM!" error in Google Sheets Script

When trying to Run the following script the result is always a #NUM! error - (Result is not a number) in cell "O5" Both the cells are in currency format and I've tried changing them to ...
user avatar
1 vote
1 answer
44 views

Google Script Substract Function

I want to create a script function that I will use with daily triggers: function will subtract "Daily Fees" (a cell value that changes daily from "Open Trades" sheet) / from "...
user avatar
0 votes
1 answer
20 views

Can You Create A Google Site From An Existing Google Docs Folder?

I already have an extensive Google Drive "site" containing around 100 documents, which contain links to each other. Is there anyway to transfer these files to Google Sites, to at least seed ...
user avatar
0 votes
1 answer
15 views

I am trying to figure out how to change a column of many dates so that any date that is "less than" 1/1/2021 will automatically change to 1/1/2021

I have the conditional formatting set to change the color of the cell. But I need the actual value to change to 1/1/2021. But only if it's less than. If it's more than that, then I don't want it to ...
user avatar
  • 1
0 votes
1 answer
18 views

How to do an internal search in google apps script and not just with a specific link [closed]

I saw here How to Create Find and Replace Function for Google Drive File Names with Google Scripts how to change Name in Google Drive I want to know how to do an internal search (within folders) and ...
user avatar
0 votes
0 answers
101 views

How do I change textStyle of labels in radar chart?

I'm making a radar chart using Google Apps Script and I don't know how to change the font size of the "labels" (see the picture). So far I've tried hAxis, ticks, legend and none of them ...
user avatar
  • 3
0 votes
1 answer
694 views

Type error: cannot read property getid of null in google script

When I run this script it show me this error. I can't understand what I do. Its function is to transfer results from html form to Google Sheet. Can anyone solve this problem? var sheetName = 'Sheet1' ...
user avatar
0 votes
1 answer
154 views

Avoid keeping adding numbers in headings in Google Docs

I am using a modified version taken from this useful answer to get numbers in my Google Docs Header 2: function myFunction() { var pars = DocumentApp.getActiveDocument().getParagraphs(); var ...
user avatar
  • 103
1 vote
1 answer
26 views

Activating cell after button click (remove focus from the button)

I have a sheet with one button (a shape) which is associated with an Apps Script function. When I click the button it inserts a row and activates a cell in that row. Then if I try typing, nothing ...
user avatar
  • 1,358

1
2
3 4 5
34