current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

Google Apps Script is a JavaScript cloud scripting language for automating tasks across Google products and third party services.

learn more… | top users | synonyms

0
votes
0answers
4 views

Google Add-on Script with Document Tables

I've been coding with PHP, HTML and CSS for a while now. Just started looking into Google Apps Scripts for creating a custom Add-On. I've been searching for a while but have been unable to find an ...
0
votes
0answers
3 views

how to obtain the original array out of cacheService using GAS

I'm experimenting with the cache. I noticed if you store an array of strings the strings will be separated by a komma . I couldn't find a method that allows to retrieve the array as an array, only as ...
0
votes
0answers
6 views

How to get past “Access Not Configured” error

I am trying to create a Google Spreadsheet function to shorten URLs. I have this code : function shortenUrl(_longurl) { var url = UrlShortener.Url.insert({longUrl: _longurl}); ...
0
votes
0answers
7 views

How to get the values by category filter?

I'm trying to get the table values based on the selection of the list item "valid date" in the category filter I get no data, when I apply the same data to the string filter I get the data. Please ...
0
votes
0answers
12 views

Not able to retrieve date column values using new category filter [on hold]

Im creating an app in which i have spreadsheet with the data, from which i need to retrieve data by selecting the values from the category filter.Please help me out ,here goes my code var ...
0
votes
1answer
7 views

Google App Scripts URL Fetch HTTPResponse Class Objects

I'm using the following code in Google App Script: function SkiCheck() { var response = UrlFetchApp.fetch("http://www.skibur.com"); var ToSource = response.getAllHeaders().toSource(); ...
0
votes
1answer
14 views

Google Spreadsheet - Scripts, copy cell from one sheet to another sheet EVERYDAY at a specific time

I know i might be asking the same thing. But i tried the scripts in different answers (obviously changing the cell value) but my question is bit different. I need to make a script in Google ...
-1
votes
1answer
14 views

Form Submission with Google Apps Script HTML Service Not Working [on hold]

I noticed that a simple web form I built a year ago is no longer working. When I remove the "this.parentNode" parameter, the submit button appears to be "doing something." What is wrong with the ...
0
votes
0answers
20 views

Dynamic SQL returns 'syntax error' on Google Apps Script using JDBC and MySQL

I'm using Google Apps Scripts inside a Spreadsheet project, connecting to a MySQL DB using JDBC. I'm trying to run the following function, which is supposed to return some data from my DB: function ...
0
votes
1answer
50 views

Not certain why a comparison between a date and an array isn't finding a match

I have the following html code: <html lang="en"> <head> <meta charset="utf-8"> <title>jQuery UI Datepicker - Default functionality</title> <link ...
0
votes
1answer
12 views

Google sheet doesn't trigger any events on .appendRow() from other script

I have a script where a user enters some information and submit. At submit I run an .appendRow() which runs successfully. With the data I have, I am trying to set background colors for a number of ...
0
votes
2answers
12 views

Publishing / sharing a Google Sheet via Github

I have a Google Sheet. It has a custom script (read: set of functions) associated with. I'd like to share this sheet template (i.e., tool), not with colleagues (i.e., adding them via email address as ...
0
votes
1answer
31 views

Google Apps Script: Save Spreadsheet as ODS for Local Backup

I could use a hand. My company uses Google Sheets extensively, and we need a way to access files when we lose our Internet connection. I could not get any of the examples found on this site to work ...
-2
votes
0answers
19 views

Displaying Google Docs spreadsheet data on website - searchable

We're doing a website for a reservists (community security) group. They require a database on the website that logs information regarding security notices or concerns in the area. People in the ...
0
votes
1answer
15 views

What is the size of the cache provided by CacheService using GAS

What is the maximum size of the CacheService ? I know the maximum time something can be stored in cache is 21600 seconds, but I can't find how large the sizes of the publicCache and the privateCache ...
1
vote
1answer
9 views

Creating a group with Admin SDK Directory API in Google Apps Script doesn't work “On form submit”

I've read through all of the relevant pages in the Admin ADK Directory API documentation and several questions on stackoverflow, and I'm still stuck. I am the super admin of my Google Apps domain, ...
0
votes
0answers
16 views

Google Apps Script OAuth Distimo Connection

I try to connect with the Apps Script to Distimo.com API. There is a fully documentation for oauth with distimo: https://analytics.distimo.com/support/api/v3/oauth However it seems to be not that ...
0
votes
0answers
10 views

How to extract attachment Blob data from Google Cloud SQL using Google Apps Script?

I am using Google Apps Script to extract attachment blobs from Google Cloud SQL using .getBlob() property of JdbcResultSet. I need to attach this data to a Google Site page. My problem is, I am not ...
0
votes
0answers
9 views

Google apps script: OAuth2

I am writing a Google Docs add-on in Google apps script. The add-on takes some data from the page and makes an entry in my web app. The problem is that I need to authenticate the user in my web app, ...
0
votes
1answer
19 views

Google script: Retrieve data from textbox

I am trying to use Google App Script for the first time and want to get data out of a textbox in on a button click (Into variable TC in the second function). I have tried to follow both from Google ...
0
votes
0answers
7 views

Error Msg “Domado: canvas drawImage not yet implemented” in Google Apps Script - drawImage Not Allowed?

I'm getting the error message: "Domado: canvas drawImage not yet implemented" in the browser console when using code in Apps Script that will work otherwise in the browser. Here is HTML and ...
0
votes
0answers
22 views

Time difference between spreadsheet and script

EDIT : Thanks to Lenny's comment I noticed that the error occurs only when timeZone are not exactly set to the same values : my SS was on Paris / France and the script to Brussels / Belgium - which ...
1
vote
1answer
10 views

Can custom classes be moved to their own library?

I want to be able to re-use some functionality across applications. In this case, I'm trying to create a wrapper for MongoDb. So I created the following class: /** MongoDb * Parms * apiKey - ...
0
votes
1answer
13 views

Is there a way to programmatically show last occupied row in a Google sheet with onOpen()?

Supose you have a sheet with several hundred rows long. You could to this to go to the last row and start your work: 1) after opening the spreadsheet, do Ctrl End; Ctrl leftArrow; Ctrl upArrow ...
0
votes
1answer
21 views

Google Sheets: noticing and acting upon new table added and table renamed

The title is the question. I'm working on a spreadsheet in Google Drive where we got a central sheet named Name registry with names of the people who ever visited some place where notebooks are left ...
0
votes
0answers
7 views

Putting friends of a Gamertag in a column of google docs [on hold]

I'm trying to make a spreadsheet that automatically adds Friends of a GamerTag to a specific Column in Google docs using a script. is it possible?
0
votes
1answer
12 views

Google App Scripts for Documents: insert text and add it to a named range for later retrieval

I am trying to write a Google Apps Script for Documents that will insert some text, and then add inserted text to a named ranged. To make sure that the inserted text is saved to a named range, I just ...
0
votes
1answer
14 views

Error when passing a blob file to send it as e-mail attachment

I'm trying to sending a file as e-mail attachment with Google Apps Script, following this rich answer. But instead of a stand alone app, I'm trying to do so within my spreadsheet, using a function ...
1
vote
1answer
26 views

I need with parsing an array from google script to HTML

I have a date picker that I'd like to use to choose an event and then show details from a spread sheet. HTML: <html lang="en"> <head> <meta charset="utf-8"> ...
0
votes
2answers
37 views

Is there a difference between [object Object] and [domado object HTMLFormElement FORM]?

My original problem is specific to Apps Script, but I posted an answer that may be helpful in a more generic way. I've tested HTML and code that works in regular HTML, but doesn't work with the ...
0
votes
0answers
14 views

Magento soap api call arguments in Google Apps Script

I'm trying to extract some data from a website using Magento soap API v1 wsdl and this is the php code for it working fine. <?php $client = new ...
0
votes
1answer
16 views

Google apps script rename file not working

When running this script I get the error TypeError: Cannot find function setName in object File. (line 8, file "Code") function rename() { var folder = DocsList.getFolder('Folder'); var files = ...
1
vote
2answers
34 views

Google Apps Script: How to pull values from column A based on values in column E and send all values in one email?

I'm trying to create a script for a student attendance spreadsheet that will look in Column E for the string "X". For each instance of "X", the string from column A (the student name) will be added to ...
0
votes
1answer
23 views

Google Apps Sctript multiple run onEdit event issue

I need to move one row to another sheet if specific value was entered. I wrote the below function. function moveArchived(event) { var sheetNameToWatch = "Queue"; var columnNumberToWatch = 15; // ...
1
vote
2answers
74 views

How can I let others install my Google Apps Script?

I've made a simple script in Google Apps Script. The script builds forms based on a spreadsheet, the script itself is part of the spreadsheet. It adds a menu item. People would like to use it. They ...
0
votes
2answers
18 views

Find all Values on the event handler as the parameter e

I have a form and I want all values of my eventInfo on a Array , Is it possible ? I have this : function doPost(eventInfo) { var submited = eventInfo.values; Logger.log(submited); ...
0
votes
0answers
17 views

continuationToken is the same as the previous one

I use the Google Apps Script function DriveApp to iterate through 425 folders. The function handles one folder each run and saves the continuationToken as a UserProperty. It runs every minute. My ...
0
votes
1answer
16 views

How to store global values correctly usign Properties service in GAS?

I have this problem using Google apps script. I have a menu in a spreadsheet with two options (Set Password and Add Time Record). These options raise a UI service user interfaces for prompt its data ...
0
votes
1answer
15 views

else if string match loop google script (spreadsheet)

I am working on a project where I designed a checkout button that automatically fill cells in a shared spreadsheet. I am having issues with the logic in a "else if" loop. I would like to have a UI ...
0
votes
1answer
19 views

How can I access functions defined in Google Script Editor outside of it?

If I have a function written in Google Spreadsheets script editor that retrieves the data in the spreadsheet in JSON format, how can I access that function outside of the script editor in my own code? ...
0
votes
1answer
11 views

setNumberFormats not working properly for percentages

I have a Google spreadsheet in which I want to copy values from one range into another range using a script. Copying the values isn't hard; I just use range.setValues(valuesToCopy). I also want to ...
0
votes
1answer
20 views

Google Spreadsheet: Wrap all text onEdit

I have a Google Spreadsheet with a sheet called Wrapped Sheet for the responses collected from a Google Form. On every new added response (thus the onEdit function), I want to call the Wrap Text ...
1
vote
1answer
38 views

Google apps script: Create a new document and send it using Gmail

I would like to create a document and then send it using Gmail. Here is my code: function myFunction() { var doc = DocumentApp.create('My document'); doc.getBody().appendParagraph('This is the file ...
0
votes
1answer
40 views

How can I clear a specific cell when another cell has been cleared?

I have a script for Google Docs spreadsheet where, when any cell in a specific column is populated it automatically places a timestamp in a different column on that row: function onEdit() { var s = ...
0
votes
0answers
14 views

Exception in Google Apps Script with Library

I have a script in my spreadsheet function runMe(){ var app = UiApp.createApplication() var hidden=app.createHidden('info','info') app.add(hidden) var buttonOk = app.createButton('Ok'); ...
-1
votes
0answers
28 views

Value of date cell in Google Spreadsheet fails

I would like to call functions in Google Script on a cell containing a date, but it doesn't work. When I input "5/19/2014" into a Google Spreadsheet cell I guess this is interpreted as a Date (when ...
2
votes
1answer
35 views

Email from spreadsheet Javascript: How to make message equal more than one column?

A colleague and I are using Google Forms to collect short essays from students. The Data is written to a spreadsheet. We want to type the feedback into the spreadsheet and have a script email each ...
0
votes
0answers
19 views

google app script : Upload error using urlfetchapp

I am trying to upload 2 pdfs from google drive to an external site using google app script but unfortunately i get an upload error at the external site when i run the script. I am not sure if i am ...
0
votes
0answers
10 views

How to create a custom calculator by sourcing from Google Sheets and still allowing the user to change specific values

This is my first attempt at enhancing custom functions, so please bear with me on this one. I have no programming or code writing/editing background. I created a site in Google Sites and I wrote a ...
0
votes
0answers
17 views

Apps Script to open of a Google Document “open in my browser” with function

Just trying to use a simple script that "open in my browser" a doc not spredsheet with a specified file ID and then opens that document . function onOpen() { // Add a menu with some items, ...

1 2 3 4 5 … 132