Stream

Join this community to post or comment

Bruce Mcpherson
moderator

Case studies  - 
 
+Oleg Moskalensky created this useful Google Form & script to easily set up and save complex gmail queries that you might find useful.
4
1
Oleg Moskalensky's profile photo
 
Thanks very much, +Bruce Mcpherson​! 
Add a comment...

Peter Driessen

Case studies  - 
 
Hi All, 

I have some questions about security and reliability of Google Script. I made a form which calls a googlescript. The script adds data to a spreadsheet and send a mail. The script is implemented as a web-app, runs under my account and is publicly accessible. So no risks there I assume. 

But the competition is high and competitors are eager to disturb the functionality of the form / google script in any possible way. Which precautions can I take more?

Can I block ip adresses from accessing the script? Can I track abuse and block access? Can I prevent the script from going down due to usage restrictions? Any ideas or advice is welcome. 
1
Mark Schuurman's profile photoPeter Driessen's profile photo
6 comments
 
+Mark Schuurman do you have an example of collecting a batch?
Add a comment...

Niklas Ternvall

Case studies  - 
 
Today when I wanted to access the script behind a Spreadsheet, I found only an empty unsaved one. I retried a few times from different users; all with same result.
Luckily I had the script-url saved and could access it directly. The first thing I did was logging the spreadsheet-id which returned the very same spreadsheet.
Now when I open the script-editor from that spreadsheet, I get to pick what project to open.
I see no reason for there being an unsaved project hiding my script and for those who doesn't save their script-urls (I'd guess most people) this could be a real problem.
3
Alan Wells's profile photoNiklas Ternvall's profile photo
2 comments
 
The very same. I'd recommend saving script-urls until this issue is resolved. 
Add a comment...

Riël Notermans
moderator

Case studies  - 
 
Interesting read.
Lots of cloud services use URL shorteners to allow their users to share access to networked folders, but with only six characters to brute force, it’s possible to scan all the URLs associated…
7
Faustino Rodriguez's profile photoJoe Marino's profile photo
2 comments
 
Yeah I'm pretty sure all Google short url's become public, so I've tended to shy away, even though don't urls can look ugly ☺
Add a comment...

Anees Hameed

Case studies  - 
 
Logger.log('Current project has ' + ScriptApp.getProjectTriggers().length + ' triggers.');
Documentations says that this will return all installable triggers associated with the current project.
So, if a project is shared between person A and B. And if Person A creates a trigger, person B should be able to see info abt that trigger. But it is not.
Code is returning only triggers associated with current project current user.
How can we share information about triggers between user so that no two users create same trigger.
2
Andrew Roberts's profile photoAlan Wells's profile photo
2 comments
 
The only other possible path I see is to use "getUserTriggers()" and then have some central location that is accessible to everyone, and record the trigger type and document name. But, I'm just making a wild guess. So, hopefully someone else knows the answer.
Add a comment...

Edouard Brasier

Case studies  - 
 
This is my updated website using google sites and showing some Google Apps Script projects. I welcome any advice before I invest a little bit in communication. Cheers : )

www.digital-consolidation.co.uk
5
JP Alpano's profile photoEdouard Brasier's profile photo
4 comments
 
Thanks for your feedback. Not sure it is awesome as it was my first apps script and first try of HTML. I don't think I used any objects. I used loops, indexes in field and array. When I append a row the htlm as some dynamic index but when I delete a row I have to change all indexes. I think I found some code on jsfiddle to help me.

$('<p><label for="p_scnts"><input class="DatePicker" type="text" id="p_date_' + i + '" style="width: 80px"name="p_date[]" value="" placeholder="Click date" /><input type="text" id="p_reason_' + i  '" style="width: 305px"name="p_destination[]" value="" placeholder="Enter destination"  /></label for="remScnt"> <label style="padding-left:2px;"><br/><a href="#" class="remScnt" type = button" id="remScnt">DELETE</a></label> </p> <div>').appendTo(scntDiv);
Add a comment...

Hans van der Leeuw

Case studies  - 
 
Hello there; I'm from The Netherlands, Nijmegen and working for Syrian refugees.
My wife and a group of other people are collecting clothing, shoes, etc.
Inside the temporary refugee camp are people speaking Arabic/English and they interview refugees about there primary needs concerning (winter-)clothing.
I need a quick and dirty sheet-app to match the collected clothing with the needs of the refugees.
It should be accessable for the people collecting to register the clothing: item; M/F/B/G; size, location refugee, and a note-field. You can call it an inventory.
From the list of needed clothing it should possible to match items in the inventory and make a pick-list.
Google can host the application for free as non-profit and nor can we pay the developer SORRY.
4
1
Andrew Roberts's profile photo
18 comments
 
I see +Riël Notermans has already added you.
Add a comment...

Aaron Burg (Work)

Case studies  - 
 
I'm revitalizing a data system we use in our school. I want to have a robust storage system but feel limited in my skill set so I think I must stay within sheets and not try to dabble into an actual database at this point.

That being said. I think I have a few options. If I want to keep running records for each student in the building (~1400) I could:
A. Create a spreadsheet for each class (Freshmen, sophomores etc) and then a tab for each student in that class
B. Create a spreadsheet for each student **I think this is how I'd like to go so I can create a dashboard tab and a new tab for each quarter.
C. Create one giant spreadsheet

If I need to stay within sheets, what's the best choice? Anyone have any history trying to do something like this?
2
2
iBO App Service's profile photoBenoit Flama's profile photo
7 comments
 
+Aaron Burg you can try a simple tool I developped that may answer your need : www.reportsforwork.com, it's full integrated with Google Apps (also edu).
Add a comment...

Ahmed Moheb

Case studies  - 
 
Hi every one .. how can i use google script with google classroom ... like "extract who active on classroom or how many teacher,student active right now ..thanks :)
1
Ahmed Moheb's profile photoSpencer Easton's profile photo
5 comments
 
No sorry. The Apps Script Classroom service is directly derived from the classroom api. There is no additional functionality.
Add a comment...

Jean Gorene

Case studies  - 
 
I turn for a while to find a solution (if any?) and still nothing yet !!
After copying a spreadsheet ... I move to another folder, no problem to do that...
But how could move the copy of the form linked to this spreadsheet copy ??
Itself automatically generated and therefore difficult to give it a destination ...

Looks like there's no method to do that ... but I hope I'm wrong;)
All ideas welcome...
1
Alan Wells's profile photoJean Gorene's profile photo
4 comments
 
+Alan Wells Thank you for your suggestion ;)
In fact, it was simply to move an existing file to another folder, but a priori and as far as I know, we can not do that with DriveApp finally!
This requires working with advanced services and Drive API
Here, I found a track that allowed me to solve my problem : http://stackoverflow.com/a/24226885/3974283

Thanks again ...
Add a comment...

Albin Severinson

Case studies  - 
 
Hey
I'm using Google Apps Script for a site that allows students at my university to buy and sell course books from each other. I made the site to make university studies easier and cheaper as the books are quite expensive. Apps Script has worked very well, however the site has grown so much that the 50 emails a day isn't enough anymore. As the site is free and as I don't run any ads I don't really have a budget for paying for the service. Anyone know if Google would you be interested in sponsoring the site by keeping my account free without limitations?

Everyone using my site are university students and many of them will go on to work in the industry. Having them like Google is definitely valuable.

It's awesome how much the site has grown though. Its popularity has certainly exceeded my expectations!

You'll find the site here: http://www.teknologbok.se/
1
Albin Severinson's profile photoMark Schuurman's profile photo
10 comments
 
The five accounts assumption is what I meant. While using it modestly, I see no trouble in fair policy restrictions.

Alternatively, ask a small amount for the service you provide and open up a business account.
Add a comment...

Bruce Mcpherson
moderator

Case studies  - 
 
+Richard Anderson shows how he automatically changed logos in his school's documents using this simple script.
 
I posted this inside another thread, but thought it deserved its own. +Bruce Mcpherson developed this apps script to bulk find and replace images that is incredibly useful. Definitely check his stuff out!
3
Add a comment...

Ivan Kutil
owner

Case studies  - 
 
Analyse city traffic by Apps Script and Cloud Vision API
http://www.kutil.org/2016/02/analyse-city-traffic-from-webcams.html

Thanks to +Riël Notermans for inspiration and +Bruce Mcpherson OAuth library

The Google has recently introduced Cloud Vision API, which allows you to analyse image data through API instead of creating custom algorithms. As Google Developer Expert I was involed in tester program of this API during alpha stage. My GDE's friend +Riël Notermans inspired me to connect Vision ...
17
5
Martin Hawksey's profile photoIvan Kutil's profile photo
5 comments
 
+Bruce Mcpherson haha, sorry :) Next time I will write something like Riel FEAT Bruce, it sound like music song :)

+Martin Hawksey Yes, as a +Martin Hawksey it availabel for public. I have written article during alpha stage




Add a comment...

Jean Gorene

Case studies  - 
 
I'm sure there is someone who could help me here, I hope;)
About Calendar API to use advanced service on a Google app script project  ... ok no problem to activate and to create an event such as this is explained on the documentation with the example, but ... is it possible to change an event already created from his id for example to modify the title, the description or anything other ...
How can I do that ?
I did not find anything method for that but I still have a lot to learn?
A track to offer me?
Thank you in advance ... it would save my day !
4
Bruce Mcpherson's profile photoJean Gorene's profile photo
5 comments
 
+Bruce Mcpherson Ok, alors merci encore:) à suivre... ?
 ·  Translate
Add a comment...

paul bertino

Case studies  - 
 
I've asked about related things before, but maybe a more direct question would be better:

Can a GAS/Chrome extension create an editing environment similar to Amazon Storywriter (https://storywriter.amazon.com) inside Google Docs? Of interest are its 'live'/instantaneous features:

1) recognizes when the user types 'int.' or 'ext.' at the beginning of a line and automatically capitalizes that line after the user hits enter.

2) recognizes 'cut to:' (or anything ending in 'to:', and auto capitalizes upon enter

3) recognizes all-caps at the start of a line as a character name, then indents that name upon enter (ie. a character is speaking)

and some other stuff, but those are my interests. BTW all of the formatting rules are from the fountain syntax specs (https://github.com/nyousefi/Fountain). Sorry for the long question.
1
Add a comment...

Suleman Shaikh

Case studies  - 
1
1
Alan Wells's profile photo
 
Good question. You can "hard code" a sample of the data that would be received by the trigger for purposes of testing the code. If it's something like an "on submit" trigger, you can submit the form. It depends on what kind of trigger it is. A simple "onEdit(e)" trigger can be tested by editing a cell in the spreadsheet. If it's for an Add-on, and you want to test whether it's actually working "live", like a form "on submit" trigger, you'd want to publish the Add-on to testers, and add yourself as a tester to the list of testers. It's good to test from different accounts and different browsers. So, it's good to have another Google account. If it's a time trigger, and you want it to only run once a year, obviously you don't want to wait a year in between tests. You'll need to test the code without the trigger, and then maybe set up a trigger that will run every minute.
Add a comment...