Stream

Join this community to post or comment
Pinned by moderator
 
Dont forget (04/2015)

■ Migrating from OAuthConfig to the OAuth1 library by April 20th, 2015
https://developers.google.com/apps-script/migration/oauth-config

■  Migrate from DocsList --> Drive App by April 20, 2015. 
http://googleappsdeveloper.blogspot.cz/2014/12/speeding-up-htmlservice.html

■  UiApp will be removed from documentation and autocompleteon June 30, 2015. If you have built any UIs using UiApp, they will continue to work. http://googleappsdeveloper.blogspot.cz/2014/12/speeding-up-htmlservice.html

(short recapitulation created on April 5, 2015)
#gde  #post #googleappscript 
12
1
Eric Koleda's profile photoDavid Prekul's profile photo
 
Excellent reminder, thanks a ton!
Add a comment...

Web Apps R&D

Problem/Coding Help  - 
 
Developers Console Project
What is the concept behind this Script Editor Option?

We are looking for a way to replace an entire script project without having to instruct users to stop running triggers. Is it possible to do so using this option? Or is it part of the Add-On publication procedure?
1
Add a comment...

George Bittmann

Problem/Coding Help  - 
 
I've got an Add-on under review and I was dinged for not using the default styling enough. In an effort to let as much as possible be styled by their default styles I decided to switch my home grown progress bar to use the <progress> tags, but it seems to get a forced width of 0px and it's definitely not me doing it. This is in my sidebar, anyone know if this is intended or a bug?
1
Add a comment...

ingrith natalie

Tips & tricks  - 
 
I want to create a feed from +google, how?
1
Edouard Brasier's profile photoingrith natalie's profile photo
3 comments
 
I want to build an RSS FEED on a my profile on Google plus, but I do not understand his code
Add a comment...

Eric L.

Problem/Coding Help  - 
 
For an add-on for google sheets, what's the best way to load icons using HTML service?
Should I make the user download an icon pack? Or is there a way to host icons from a separate google drive account for them to access?
1
Otari Arutiunian's profile photo
 
You could address an icon pack in <IMG> hosted on your side. Basically images will be loaded as in usual html
Add a comment...
 
I would like to either embed a youtube video in a Google Sheet or alternatively have a frame in google sheet that can access youtube.

Any ideas?
1
Otari Arutiunian's profile photoAlan Ossher's profile photo
7 comments
 
The HtmlService may work, but I do not have the knowledge to do it.
I tried, hopefully, to do this is Excel, and then upload and convert it to Google Sheets, but the script was dropped.

I see you can insert an image, and then attach a script to the image, but once again, I can't get it to work.
Add a comment...
 
Just about to go through the Add-on publishing process on this Sheets Add-on. Any testing  volunteers?

#gde   #googleappscript   #blogpost  
8
2
Holger Hubbs's profile photoBruce Mcpherson's profile photoGoogle Developer Experts's profile photo
5 comments
 
I tested it with only 100 rows, 2 columns.
Works well.  Merge is great.

I love "Help" links/texts: a short very simple description of what it does, some  screenshots, some tips, evtl. developer's email. 

Thank you for sharing.
Add a comment...

Steve Webster

Tips & tricks  - 
 
Good news ..
"var picker = new google.picker.PickerBuilder()"
Some have struggled using the Picker. The GAS online documentation and code example has been updated recently. Check it out:
https://developers.google.com/apps-script/guides/dialogs#file-open_dialogs 
3
Add a comment...

Jimmy McClure

Problem/Coding Help  - 
 
docslist is deprecated. So I am trying to use DriveApp.
I want to add a file to a folder. 
I am receiving an error when trying the following (any help is appreciated):

var sharedFolder = DriveApp.getFolderById(e.parameter.attachments_target);
  var file = DriveApp.getFileById(docID);
    
  //file.addToFolder(sharedFolder);
  file.addFile(sharedFolder);
1
Spencer Easton's profile photoJimmy McClure's profile photo
2 comments
 
+Spencer Easton - thank you for your help and your quick response!
Thank you also for the remove file reminder.........I did have to revise my previous file removal script to the following:  
var root = DriveApp.getRootFolder().removeFile(file);
Add a comment...

Matt Coulter

Problem/Coding Help  - 
 
I am trying to create a tool to identify all conflicts of recurring events on Google Calendars.  Currently Calendar may let you know there are a number of conflicts but will not tell you where all of them are.  So I have a script to read the Calendar XML and convert to a Google Sheet but now I need a formula to highlight the overlapping dates.  Any good ideas for this?
1
Add a comment...

About this community

Google Apps Script is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications. Scripts are developed in Google Apps Script’s browser-based script editor, and they are stored in and run from Google’s servers. Community managed by - Ivan Kutil (GDE) - Martin Hawksey (GDE) - Romain Vialard (GDE) - Bruce Mcpherson (GDE) - Eric Koleda (Google)

James Porcella

Problem/Coding Help  - 
 
I am new to Google Apps Script and have created a project that takes information from a google form and places it in the user identified google spreadsheet.  

To "Identify" this spreadsheet's google ID I have another spreadsheet with the name and ID.  The script executed well for all spreadsheets identified originally.  The problem arises when I add to the list in the form and corresponding entry into the "ID spreadsheet".  It doesn't place the data from the form in the newly identified sheets.  

Thanks,

Jim

Thanks,

Jim

  // Open the name to id spreadsheet
  var spreadsheet = getSpreadsheetByName('2015 Google Spreadsheet ID');
  var nameSheet = spreadsheet.getSheets()[0];
  
  // Finds the spreadsheet id with the name
  var lastRow = nameSheet.getLastRow();
  var lastColumn = nameSheet.getLastColumn();
  var range = nameSheet.getRange(1, 1, lastRow, lastColumn);
  var sheetId = rowForValue(range, name);
  
  // Debugging
  if (debugging == true) sheetId = '1X-aH0lCtDVYXGgyUjjmx6KV5yk0iIi9Fr1F9YcQEmqM';
  
  // Open the indivdual's spreadsheet
  var individualSpreadSheet = SpreadsheetApp.openById(sheetId);
  var individualSheet = individualSpreadSheet.getSheets()[0];
  
1
Add a comment...
 
If you're fed up with writing client side JavaScript and Server side Apps Script in separate environments when using the HTMLService, here's how to use your Apps Script code in HTMLService templates.

#gde   #googleappsscript   #blogpost  
11
Bruce Mcpherson's profile photoRiël Notermans's profile photo
5 comments
 
True, thanks for that.

I never had these kind of calculations (at least not that they became too slow) so hard to imaging where it would benefit, but I see now.
Add a comment...

Gary Furash

Tips & tricks  - 
 
Is there an API yet for Keep?
3
Ryan Roth's profile photo
 
Not at this time, no.
Add a comment...

Nick Burke

Problem/Coding Help  - 
 
I'd like to create a dynamic form that basically pulls questions from spreadsheet where each row has a question, multiple choice answers, and a correct answer.  The respondents would then fill out there answers in the dynamic poll and the submitted responses would be compared to the correct answers for self-grading and then email the respondent a result.

Is there a way to set this up with a script and google forms?
2
Daniel Frost's profile photoHolger Hubbs's profile photo
4 comments
 
#DanielFrost  would you mind sharing your resources openly, here on Google+?
Add a comment...

Pat Wicks

Problem/Coding Help  - 
 
Looking for someone to write date/timestamp script for a 13 column google docs spreadsheet.
1
Pat Wicks's profile photoDaniel Frost's profile photo
3 comments
 
Send me a message at coolnamehuh@gmail.com
Add a comment...

Sergey Kozhin

Problem/Coding Help  - 
 
 
After adding in script .setSandboxMode(HtmlService.SandboxMode.IFRAME);  (код.gs str 11).  form does not send the file to the server. How to FIX?
https://script.google.com/d/16KFon67OLpqN772mBYuUoi0Vcf8bAG0bKqRtMh10OxzAqL_djXHY0djd/edit?usp=sharing
1
Sergey Kozhin's profile photo
 
i try add google map to this example http://ctrlq.org/code/19747-google-forms-upload-files
Add a comment...

Travis Elliott

Tips & tricks  - 
 
Come check out Travis's newest project, setting up automated logging to a google sheet from a temperature sensor using our RL15PL_Web-i board! Add the board to your cart and use the coupon code in the article at checkout for over 30% off this product for the first 100 people!
https://www.controlanything.com/project/Temperature-Logging-Google-Scripts
1
Add a comment...

Jasper Levink

Problem/Coding Help  - 
 
Dear all,
I am a newbie to Google Scripts. Tonight I started trying to automate a couple of things in Google Sheets. I am not entirely sure whether this is the right place to pose my question.

One thing I noticed immediately is that when trying to retrieve a value using sheet.getRange('C7').getValue(), this does not work if that cell is still being edited (i.e. I have entered a value, but not yet left the cell; so the cell is still active). Is there a workaround for this? Can I e.g. force finalisation of the editing?
Thanks, Jasper
2
Riël Notermans's profile photoJasper Levink's profile photo
2 comments
 
Ok thanks! 
Add a comment...

Darlow Marine

Problem/Coding Help  - 
 
I have google forms for which I've created custom scripts in the script editor section of the sreadsheet response form. Everytjing has been working fine up to a couple days ago when I began receiving the following script error "ReferenceError: "DocsList" is not defined. (line 33, file "Code")". Any help is much appreciated. 
1
Otari Arutiunian's profile photoDarlow Marine's profile photo
3 comments
 
Thank you
Add a comment...

Chris Upchurch

Problem/Coding Help  - 
 
(warning: not a coder or programmer) 

I am trying to write a dashboard script, but I have been unsuccessful following along youtube tutorials. Essentially, I would like to redirect to a "results" page following participants taking an online survey. I discovered the tool to redirect the page; however, I am stuck trying to create a charts dashboard. Specifically, I am not able to properly create tables and charts from the linked spreadsheet. I do not fully understand the process as described in the tutorials. Any help would be greatly appreciated!
1
Martin Hawksey's profile photo
 
Hi Chris - it looks like the tutorials you've been watching are now out of date as the UiApp calls are being fazed out. The alternative is something called HTMLService which as the name implies requires knowledge of HTML. An alternative approach to this that might be more suitable for you is generating graphs  in Sheets and embedding in Sites. This is actually an approach the UK Government use outlined in http://googleappsdeveloper.blogspot.co.uk/2012/12/analytics-reporting-with-google-apps.html (this is another old post and for getting data into a Sheet you might want to look at some of the existing Add-ons that can do this for you). If the charts in sheets aren't advanced enough you can directly use the Google Visualisation service, but unfortunately you are back in code land https://developers.google.com/chart/interactive/docs/gallery/controls
Add a comment...