I am pulling data down from a webservice and it is formated as JSON. I am writing a google apps script for google spreadsheet that will populate the data form me. my problem is, I can't seem to get it to parse out. doing: var dataset = myJSONtext; Browser.msgbox(dataset.item[0].key); errors out, saying item[0] is not defined. Is th...
I have built an object in Javascript on the Google Apps Script engine and every time I run my script I get a reference error saying uName is not defined. Here is the relivant code: function DataSet() { this.uName = ""; this.dField = ""; this.qUrl = "http://api.bfbcs.com/api/pc?players="+uName+"&fields="+dFeilds; this.data =...
The Browser.msgBox("hello") method lets me display the text "hello" to the user in a message box, but if I put any HTML in there, for example "Hi there", the user just sees the HTML tags. Is there a way to display a popup with simple HTML to the user from withing google apps script? ...
Can someone tell me if there is a webpage that lists the official Google limit on emails sent from a Google Apps Script? In testing my little script I got a Service invoked too many times: email (# 59) and now I can't send any more emails. The obvious place for this information would be in the MailApp.sendEmail documentation. But, tha...
Hi I have created a Google Spreadsheet form in which for one of the fields I get the time (hh:mm:ss) in 24-hour format. I am using Google Apps Scripts to read values from this spreadsheet and put it into another file. But the other file gets the entire date (don't know from where) and shows a date from 1899. Also the time is shown in P...
Does anyone know if it's possible to use Google Apps Scripts to run without needed a manual event? Meaning - I would like to set up a spreadsheet to send a form every day at a specified time. I have figured out how to manually send the form by executing a script, but has Google implemented to ability to set a script to run in the future ...
Part of my spreadsheet's script runs the following piece of code: temp.getRange(1, 1).setValue("=QUERY(data!A1:H125, \"Select A\")"); As you might expect, this puts =QUERY(data!A1:H125, "Select A") into the A1 cell BUT the formula gives an error (#NAME, error: Unknown range name data!A1). I know the formula is correct because if I c...
I have a simple script that will send out a bunch of emails but these take time to send and I want to show the user a scrolling window with the emails addresses as they are sent (or, a progress bar would be good too). I believe this is possible with the new User Interface Classes, but I can't get it to work. The documentation is kinda sp...
http://code.google.com/googleapps/appsscript/class_range.html#getFormula Is there a script I can install or do I need to write my own? After that? ...
I'm using the built-in api for scripting against Google Spreadsheets to send some booking confirmations, and currently my script breaks if someone has filled in an invalid email. I'd like it to just save some data to a list of guests that haven't been notified, and then proceed with looping through the bookings. This is my current code ...
I've a Date column in 'dd/mm/yyyy' format and Time column in 'HH:MM AM/PM' format in Google App spreadsheet. In app script, I want to join these 2 values as a datetime. How can I do this? Example- date : 13/12/2010, time : 4:30 PM Then I want to get a combined value like '13/12/2010 4:30 PM' as a datetime object. I tried to parse date ...