Stream

 
Problem with a Gmail Trigger:

I tried writing a gmail script that would send an email to myself in a few hours, it worked but now it's deciding to send me on average 19 emails between 4:10 am and 4: 24 am everyday...  I've since deleted the script, but it's still executing... not sure what to do.  Any ideas?
3
Amit Agarwal's profile photoJacob Edward's profile photo
3 comments
 
+Amit Agarwal Thank you.
Add a comment...
 
Is a "grid" the same thing as a "range" for google apps script Spreadsheets?

https://developers.google.com/apps-script/reference/spreadsheet/range#setValues(Object)

This is the description for the setValues function:

"Sets a rectangular grid of values (must match dimensions of this range)."
1
Dominic Dodge's profile photoJacob Edward's profile photo
11 comments
 
+Dominic Dodge Thanks for clearing that up. :-)
Add a comment...
 
Nice to see one of my old projects being reused in this #openbadges generator which uses Google Forms, Sheets and Sites

#gafe  
Following on from our previous post on the Open Badges Generator we have updated our system to include both badge creation and badge issuing components. We have now written up a small guide to help anyone who would like to im...
2
1
Martin Hawksey's profile photoLionel Biennier Pers's profile photoMichael Ellis's profile photo
3 comments
 
I just bought a course from Career Academy for Project Management (a move toward certification).  That's a US company that appears to have some traction.  Might be someone to entice with the idea.
Add a comment...

Azam Afzal

Education  - 
 
Is there a script to put timestamp for each item/question in a test developed on Google forms?
1
Alexander A. Mandl's profile photoFederico Granata's profile photo
4 comments
 
If you submit after each question then yes. 
Add a comment...

Jaume Feliu

Education  - 
 
 
In a google apps script, is there any way to know if a user who answers a form is a GAFE account or not?
1
Jacob van den Berg's profile photoFaustino Rodriguez's profile photo
3 comments
 
+Faustino Rodriguez  Lucky that I mentioned "you have to redo everything" :-)

I go "outside" of Google Apps in a regular html site (hosted on app engine) and than with http request I get the response (or not) from Google Apps doPost or doGet functions/scripts. 

Take a look at this little example I used for testing http://dev.lagaroo.com.br/  
The alert shows a status that comes from a http request to Apps script. 
Your information on the screen come from the Oauth authentication in the javascript G+ API library. 

It basicly is a copy of  https://github.com/googleplus/gplus-quickstart-javascript.git 

BTW today is Kings Day remember to wear something orange!!  :-)) http://www.oranjewinkel.nl/uploads/koningsdag-amsterdam-2014.jpg
Add a comment...
 
The free Mo'olelo app will allow your students to brainstorm and create stories based on visual images. Students can save their work on the app then generate a Google Doc from their outline when they are ready to roll. There are a couple of lesson plan ideas complete with resources. The app works on desktops and is mobile/tablet friendly too! Tested on Chrome and Firefox...sorry ie! No personal information is collected by this app - ever. Enjoy! :)

Give it a go with your students and let me know what you think, or if you have a lesson idea, let me know and I can include it with the app.

Thanks - hope you find it useful in your class!
1
Add a comment...
 
So I have a teacher friend that is having an issue with her script, she is running the new spreadsheet so autocrat is in the add-on menu now. She has successfully run 50 merges at this point, on a one page document, but the script has now stopped. I can't seem to find an error in the spreadsheet and after I have run the merge again it is just spinning and not moving forward. Any ideas on how to help this teacher trouble shoot? She is using a school account so she should be able to make up to 1500 merges (she has only hit 50 at this point) so I can't figure out why it has stopped. 
1
Nichole Carter's profile photoTim Cargan's profile photo
4 comments
 
Oh my goodness I had no idea there was a separate community I am sharing it now! Thanks for the tip! 
Add a comment...

Andrew Quell

Education  - 
 
Hello All, I am looking for a google script that would be able to send an email to students with all the information that is placed in the same row as their email address along with header row information. 
Basically looking for students to submit a form with their grades on different sections, and then sum them in spreadsheets change any scores, add comments and then send it all off to them in an email 
1
Andre Guimaraes's profile photoJonathan Rothman's profile photo
4 comments
Add a comment...
 
I really like the use of Google Docs and Sheets add-ons.  As a user and not an author of these add-ons I would like to appeal to this community for a variety of different add-ons.

1.  The ability to insert a +GeoGebraChannel  graph directly within sheets that can modified within sheets and re-saved.

2. Integration of +CodeCogs fxRender  or other Equation editor within Docs.  So students could see what there math looks like and can easily edit.  I know there is already the Google Equation editor, but it is very limiting and has almost no Geometry.

3. The ability to insert a graphing utility similar to the type that +Khan Academy  uses for graphing linear equations.

4. Some sort of integration with +Desmos 

I am extremely impressed with what this group produces.  Any help in making it easier for students to demonstrate mathematical work and understanding online would be extremely helpful.
3
John McGowan's profile photoDang Ren 柏當仁 Bo's profile photo
4 comments
 
Add an add on to embed an image of a spreadsheet range in order to get around limitations on the tables in Docs.
Add a comment...
 
how does one get started with scripting? do you have a tutorial you would recomment?
1
Aaron Burg's profile photoEdie Barbour's profile photo
5 comments
 
Thanks Aaron! good advice :-)
Add a comment...
 
Does anybody have a link to an actual explanation as to why Google Finance was deprecated?  I saw the mention on the blog, but it doesn't really say much, that kind of functionality would be really useful for someone just wanting to mess around, for obvious reasons...

http://googleappsdeveloper.blogspot.com/2014/02/more-apps-script-apis-and-features.html
1
1
István Maczkó's profile photoChristopher Fortin's profile photoJacob Edward's profile photo
2 comments
Add a comment...
 
I am looking to partner up with someone who wants to learn Android.

Over the years I have had several looks at learning Java to programme Android.

Up till now it's always seemed to be difficult, too hard to stick with in the "painful" "slow" initial learning process; you may know it as the flat part of the learning curve that we all go through when learning something new.

I think it's even more painful when you have some programming experience (in a different language) because it's like going right back to kindergarten for no justifiable reason.

However things have recently changed for the better! There is a brilliant just released IDE called Android Studio.

Also Derek Banas has started a set of excellent instructional videos.

So in the new tradition of extreme programming where they say it's a good idea to have a partner, I thought someone might be interested in partnering up in this learning process.

Please contact me by e-mail, phone, this thread, google plus or any other way that is convenient to yourself if you are interested.
1
1
Patrick Merlot's profile photo
Add a comment...
 
Hot off the press!  Here's a spreadsheet script that you can use to transfer Google folders and files in mass from one user in your school to another. http://goo.gl/kPzQqZ Let me know what you think!
1
1
Paul Swanson's profile photoHolger Hubbs's profile photoLionel Biennier Pers's profile photo
3 comments
 
I will look into FlashPanel.
Add a comment...

Sarah Jordan

Education  - 
 
Hello. +Ryan Gilbert in the Google Apps for Education area suggested I try asking this question here - I am hoping that someone can help me. We have recently added a sub domain to our GAFE account. The idea is to shift all our students to the sub domain. Now, I have renamed one student with the new domain address and seamlessly she became our first new domain incumbent, complete with emails, docs and data. My question - Is there a way of bulk renaming all the students and having their docs and data shift with them as it does when you do it individually? Many thanks.
2
Jean-Pierre Verhulst's profile photoSarah Jordan's profile photo
5 comments
 
Did you check Flashpanel ?
http://www.flashpanel.com
Add a comment...

Faizan Rauf

Education  - 
 
How we can edit the Ui of Gmail. Like they did http://www.sndlatr.com/
1
Faizan Rauf's profile photoFaustino Rodriguez's profile photo
3 comments
 
Oh! stunning work by streak. I don't find documentation for that either.
Add a comment...
 
Hello all! I am wondering if there is a way to utilize a form to continuously fill a spreadsheet and add to existing data.  For example, have a spreadsheet of students, and as data is collected through the year use a single form to add the data when gathered and have it fill the appropriate student row.  On top of this I was wondering if there was a way to continuously add to an individualized report (by using autocrat or similar script) so when new data was entered via the form, it was automatically added to the existing individualized document.
1
Terry Chambers's profile photo
 
I am sure you can do that with AppScript.
Add a comment...

Tiffany Wilson

Education  - 
 
We have created a form using branch logic for summer school sign up.  Parents enter all vital information, then are led to a grade-specific set of course options.  Used FormEmailer to send auto confirmation email to parents.  Currently, ALL form options for EVERY grade is emailed to the parent.  Is there a way to ONLY include the specific grade level of their student in the confirmation email?  Form located below.
Drive
2014 Summer School RegistrationRegistration will be open at 8:00 am Monday, April 14, 2014 and will close at 10:00 pm Wednesday, May 21, 2014.
1
Mark Schuurman's profile photo
 
I think this could be done. Don't know FormEmailer, so I'm thinking of a solution in the sheet.

Based on the responses, you can have a cell populated by filtering or comparison:
"=ARRAYFORMULA (IF('Answersheet'!A2:A="[Critical Class Code]";"Send";""))"
This will make the relevant cells containing "Send", after which you can have it used to trigger the script.

I hope this helps, I'm curious!
Good luck! 
Add a comment...

Bethany Petty

Education  - 
 
Check out my experience with implementing gClassFolders!
The first time your students access Google Drive, it's probably going to be rough. Most of them have never accessed Google Drive before, and are used to Microsoft products. Am I right? Today, my students completed an assignme...
1
Add a comment...
 
+Justin Gale has a lovely script and setup instructions for a  'Login Activities Dashboard'. Lots of scope to extend this to selectively release slices of the data to school admins or incorporate in a wider #learninganalytics  solution

https://docs.google.com/document/d/1AIEy7QROttgYb3Vups3KW-zjYXPASGzes9Xs7i4-vCk/edit
5
1
GAS LibraryApp's profile photo
Add a comment...
17
7
Günter Zöchbauer's profile photoMichael Herkens's profile photoItai Sanders's profile photoGAS LibraryApp's profile photo
2 comments
 
i ask those questions because i have developed an add-on we needed for our own calloborative needs throughout our team's shared files, but up untill now the only way to do so was to copy the code manually into every Doc-bound script of every new Doc we create.
i was kinda hoping the new add-ons feature would either make our sidebar available to us without this process, or at least make it available to us to install into a doc with a few clicks (using the store).
thank you very much!
Add a comment...