google-apps-script Questions
2
Solved
it is getting me crazy, the code was working yesterday, but not anymore. I tried to check all syntax again, but the issue still persists. this server-side request from Google Sheets, shows value on...
Twittery asked 6/6, 2019 at 14:58
10
Solved
I am attempting to publish a simple Google Docs add-on, following these instructions: Publishing an Add-on
However when completing the configuration for Google Apps Marketplace SDK, I enter my scr...
Seif asked 7/12, 2016 at 22:22
24
Solved
I need to convert a Google Spreadsheet column index into its corresponding letter value, for example, given a spreadsheet:
I need to do this (this function obviously does not exist, it's an exam...
Triadelphous asked 20/1, 2014 at 8:24
1
Solved
A previously working solution that was resolved here by @tanaike suddenly returns an empty cell upon execution. I don't get an error message and in the google apps scripts edit page I get "Not...
Licha asked 13/1, 2023 at 22:3
5
Solved
I have always used the insertText() function, but now I want to write a link in my google docs. The ideal would be to be able to write in HTML, but I don't know how.. it seems that it is not possib...
Extensible asked 16/9, 2015 at 7:39
3
Is there any way to increase the 6 minute execution time limit for Google Apps Scripts? I thought that the answer might be the Early Access program for G Business Suite. I might be willing to pay $...
Etan asked 1/2, 2017 at 4:17
13
Solved
In Google Sheets, you can add some scripting functionality. I'm adding something for the onEdit event, but I can't tell if it's working. As far as I can tell, you can't debug a live event from Goog...
Journeyman asked 18/7, 2012 at 10:35
1
In the google spreadsheet, I have a list called "ID_list_Google_doc", the list created from D3 to D (D3:D), which consists of a multitude of google doc ids. Each google doc id is unique a...
Foresight asked 9/1, 2023 at 7:14
2
Solved
In MIT Inventor II, I use web component to get SpreadsheetID and SheetID through doGet() of google apps script. After I get the information I use another web component to set url as below to get cs...
Hondo asked 5/8, 2020 at 13:13
17
Solved
I've made a script that every few hours adds a new row to a Google Apps spreadsheet.
This is the function I've made to find the first empty row:
function getFirstEmptyRow() {
var spr = Spreadshe...
Amal asked 30/7, 2011 at 8:53
2
Solved
This Google Apps Script code to scrape press release news from Yahoo Finance randomly stopped working today.
It suddenly gives the following error -
TypeError: Cannot read properties of undefined (...
Guib asked 17/12, 2022 at 19:23
1
Solved
@Tanaike made this beautiful codes for Google Apps Script a year ago as posted here. It worked very well up until recently. Because of some changes in the Yahoo Finance webpage, it doesn't pull the...
Immunogenetics asked 21/12, 2022 at 5:42
6
Solved
How to create a new sheet in a Google Sheets with Google Apps Script?
I know it seems obvious but I just want to create a new sheet with a specific name.
Lashley asked 6/4, 2014 at 18:59
3
I noticed that the GCP projects created by default when creating a new script are not deleted from the GCP Console when the app script files are placed in the Drive recycle bin.
Have you ever encou...
Incursion asked 17/11, 2020 at 12:47
3
Solved
I am working with Google documents that contain hundreds of empty paragraphs. I want to remove these blank lines automatically.
In LibreOffice Writer you can use the Find & Replace tool to re...
Radiophone asked 10/10, 2016 at 16:7
4
Is it possible to add a second level sub-menu (sub-sub-menu) to a Google spreadsheet? I know how to add a menu with a sub-menu but what I need is to add one level more. Thanks.
Summons asked 26/2, 2013 at 0:43
2
Solved
This is a snippet in the Google Apps Script for adding a menu in Google Docs/Forms/Sheets. As stated in the Menu#addItem method it calls the menuItem2 function, but the snippet didn't include a sam...
Stela asked 10/9, 2014 at 5:50
7
How do I locate the path of the current folder? I just want to be able to get the path of the folder so that I can manipulate the files in the folder without typing the path into the scripts.
Suggest asked 8/2, 2013 at 10:40
3
Solved
I guess this question is the most similar to my current question. But basically, I have a google sheets file that has several sheets along the bottom. I would like for the user to execute this scri...
Langobardic asked 25/9, 2020 at 12:9
7
Solved
I am new to GAS (actually new to coding too)
I got a date string in the format of yyyymmdd (eg. 20140807), how could I turn it to date so that Google apps script can recognize it and later I can do...
Yellowtail asked 7/8, 2014 at 4:36
2
Solved
I am trying to use the Google Sheets API. The problem is, once I call my script function on the google spreadsheet, I get the following error:
API call to sheets.spreadsheets.values.get failed wit...
Scuta asked 11/3, 2019 at 11:32
2
I am trying to import data from the following website to Google Sheets. I want to import all the matches for the day.
https://www.tournamentsoftware.com/tournament/b731fdcd-a0c8-4558-9344-2a14c267e...
Rue asked 28/10, 2022 at 15:35
2
We are developing a program that uses Google spreadsheets as the input. The values of the spreadsheet is read, processed and a result is showed in a webpage.
When an user sign up we clone a spreads...
Mercado asked 5/10, 2016 at 18:45
5
I have a simple contact form built with ASP .Net using the updatepanel. Everything works as expected but i see the error
recaptcha__en.js: Uncaught Error: reCAPTCHA has already been rendered in th...
Crumby asked 9/1, 2019 at 12:45
3
In Google Sheets, after selecting a series of rows and right clicking on one of them, there is an option under Row Height that is Fit to Data. I would like to do this in a script.
All of my search...
Neaten asked 9/8, 2017 at 21:9
© 2022 - 2024 — McMap. All rights reserved.