Google Apps Script is a JavaScript cloud scripting language for automating tasks across Google products and third party services.
0
votes
0answers
3 views
Removing Elements in a StackPanel
All,
I am trying to implement a StackPanel containing multiple sub-panels to collect user data. Each subpanel (I have named them SwapRecordPanels) represents a line in a Google spreadsheet ...
0
votes
0answers
16 views
How to combine Google Apps Script with JavaScript?
I want to use HTML to create form, use JavaScript to interact with users, and use Google Apps Script to create workflow. But I don't know who to combine Google Apps Script with JavaScript?
Thanks!
0
votes
0answers
18 views
How to parse name and email in GAS
the function GmailApp.getMessageById("1405...8").getFrom() will return name and email in two different cases, afaik:
"Full Name <[email protected]>"
"[email protected]"
I need to parse Name ...
1
vote
0answers
16 views
Have a listbox populate with every folder in myDrive
I am trying to define where my file is to be saved to. I am starting out at the end user and moving inwards, so that means the start of the UI. I have the Label and the listbox but I am having ...
0
votes
2answers
31 views
How do I add a function to the function selector in the spreadsheet script editor [on hold]
Can anyone point me to the documentation on the spreadsheet script editor? [The youtube video is next to useless wrt the spreadsheet environment.]
0
votes
1answer
32 views
JSON String to Array to Cache - Improve Efficiency
I have cried blood finally getting this script to work (new to the google apps scripting and json, relatively familiar with javascript). It works great with a small data set, but as soon as I jump to ...
0
votes
1answer
22 views
POST to Google Apps Script web app does use latest version
I have built a web app using Google Apps Script, and a lot of information from here, that writes data to a spreadsheet for me. All of the functionality is in the doPost() function and works fine in ...
0
votes
0answers
13 views
google app script fileupload on android webkit
I have google app script web app in which fileupload works fine on PC broswer but not in android webkit. The file choose button opens pc file choose dialog fine but on android it does not bring up ...
0
votes
2answers
33 views
Importing Google Font into HTML Service
Are you able to import Google Font into Google Apps Script's HTML Service?
I am trying to do:
<link href='http://fonts.googleapis.com/css?family=Roboto' rel='stylesheet' type='text/css'>
...
0
votes
1answer
32 views
Set the name of the document when it is created
I am trying to edit this "Generate from Template" script. What the script does is based on a template it inputs information from a Spreadsheet to a Document. I like how it works except that it just ...
0
votes
1answer
34 views
Google script : cannot access e.user on edit change
The following reproduces the problem :
make a form
in the script editor, create a script with this function:
function displayUser(e){
Logger.log(e.user);
Logger.log(e.user.getEmail());
}
create ...
0
votes
1answer
23 views
importRange not working in google docs
Am I doing something wrong here or is the importRange is a method of some other object I am not aware of?
var importData=importRange("key of the spreadsheet","required range");
When I do this a get ...
0
votes
2answers
38 views
SELECT or Filter from JSON(?) Array
I have a call to a large JSON data set. It has multiple items and each item has multiple pieces of information. I want to output only one item's single piece of information. So I need to filter down ...
0
votes
1answer
23 views
programmatically edit script in Google Drive document
I have a Google Drive document which writes values to a Google Drive spreadsheet using Google Apps Scripts.
The script associated with the document looks a lot like this:
// must change value to ...
0
votes
0answers
17 views
Through Google Apps Script get all user information on a spreadsheet of a google apps domain
I want to retrieve all the user data of my domain in a spreadsheet, so far i am able to retrieve first name email id last name ,storage quota and password change when next time i log in. But I am ...