Stream

Join this community to post or comment

Sam Soo

Case studies  - 
 
Is it possible to use google wallet in app script ?
1
Jacob Edward's profile photo
 
Not sure, it seems like they've only got the android api, couldn't find a REST api for google wallet, but you could essentially use any third party payment system that offered a REST api if that would work?
Add a comment...

Carlos Silva

Case studies  - 
 
Can somebody explain the problem that google.script.history and google.script.url try to solve? When should I use these functions. Do you have a small example?
4
Bruce Mcpherson's profile photo
 
The history API in htmlservice 5 allows you to keep your browser history up to date when you use Ajax to render a page. Let's say you have a link in your page that leads to an anchor point in the same site. Clicking on that would typically cause a refresh from the server, but you could instead programmatically render that client side. The problem then though is that your browser history wouldn't reflect that, so back wouldn't work for example. This can be used to patch that. Avoiding server refreshes can lead to more responsive web apps since it avoids having to restart it to click around it. Whether the history API is supported is a matter for the browser version, but I imagine that it's something that's blocked in the Google sandbox, hence the need for a google version of the api.. I've not tried it but that would be my assumption and the reason that it's been implemented.
Add a comment...

youssef be

Case studies  - 
 
Controlling humidity and temperature using Arduino and Google Script
6
youssef be's profile photo
7 comments
 
This is a code Google Script

function data() {
var url = "http://www.domaine.com/arduino.json";
var data = UrlFetchApp.fetch(url);
var json = data.getContentText();
var data = JSON.parse(json);
var lum=data.l;
var ven=data.v;
var chauf=data.c;
var temp=data.t;
var hum=data.hu;
var mou=data.m;
var heure=data.h;
var stat = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
var last3 = stat.getLastRow()+1;
var range = stat.getRange("A1:G" + last3);
var d = new Date();
var h = d.getHours();
var n = d.getMinutes();
var heurp=h+":"+n;
var dif = heure.split(":");
if((h-dif[0]<2 && n-dif[1]<30) || (temp>range.getCell(last3-1, 5).getValue() || hum > range.getCell(last3-1, 6).getValue())){
range.getCell(last3, 1).setValue(d);
range.getCell(last3, 2).setValue(lum);
range.getCell(last3, 3).setValue(ven);
range.getCell(last3, 4).setValue(chauf);
range.getCell(last3, 5).setValue(temp);
range.getCell(last3, 6).setValue(hum);
range.getCell(last3, 7).setValue(mou);
}

if (temp>30){ ////send command to Arduino when temperature is high than 30 c. In this case, arduino turn motor to the left
var html = "http://www.domaine.com/arduinophp.php?select=mch,";
UrlFetchApp.fetch(html+20);
}else if (temp<30){ /////send command to Arduino when temperature is less than 30 c, In this case, arduino turn motor to the rigth
var html = "http://www.domaine.com/arduinophp.php?select=mch,";
UrlFetchApp.fetch(html+32);
}
}
Add a 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
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...

Priya Sree

Case studies  - 
 
Why Apps Script isn’t the Best Solution for Workflow Management in Google Apps - http://bit.ly/2bfF7vT
This article continues a series highlighting workflow management options for Google Apps customers.In our last article, we focused on how using Google Forms
1
Add a comment...

Jean Gorene

Case studies  - 
 
Does anyone has a solution to just disable sending automatic messages via email in programmed script when adding an editor or change the owner of files or folders by lot on Google Drive. . as we can do it from the interface by unchecking the appropriate checkbox.
I have not found a method to it ... if any ...
Thank you in advance !
1
Jean Gorene's profile photo
4 comments
 
Ok, {'sendNotificationEmails': 'false'} It's not possible for change owner ... just unfortunate !!
https://developers.google.com/drive/v2/reference/permissions/insert
Add a comment...

Carrie Marsh

Case studies  - 
 
My company is currently receiving orders via fax, phone, and email.
These are time sesitive orders where we provide a service at a specific time and day.
We have to communicate this information to the guys prepping the needed items, and then to the person who will be taking the items at the specific day and time.
It is imperative that we confirm the services with those who ordered them, which we have been doing by manually inputing the information we receive into a physical ticket with carbon copy. The physical ticket then gets put onto a scheduling board in two locations (thus carbon copy). The information from the physical ticket is inputed ont each clients schedule for the week, which are in individual word documents for each client and then those documents are faxed or emailed to the client.
There has to be a better way.
I already have created a google form, but there are things I would like to do from here, but don't know how.

-Can I have a notification of when a new response from the form is recorded? Right now I have to remember to check the spreadsheet for new lines indicating a new order.

-What is the best way for getting responses off of the spreadsheet and to all of the places/people they need to go? (Back to the client in a schedule form, for each different client, to my people prepping orders, to my people delivering orders, to my manager who assigns all of those people to each order, and to the office manager so he can see where everything/one is going).

-How do I deal with a paper battle where many of my delivery people want a physical paper to take with them? Printing seems inefficient as we currently use quarter sized sheets for our orders.

I have tried a couple of scripts and zapier, but couldn't get them to work quite right. What am I missing? Any that you suggest?
4
Andrew Roberts's profile photoAlan Wells's profile photo
5 comments
 
People are constantly trying to create their own systems, not realizing how much work it could be.  There have been studies done showing that even professionals have an extremely high rate of projects that never get completed, and some that are even so bad that it threatens the very existence of the company.  So, make sure that whatever you implement is tested, and worth whatever time and money you put into it.  I would not replace your paper system until another system has been used in tandem at least for a day or two.  Google products are basically web based, so if you are going to use Google Forms on something like smart phones, make sure it works.  You could use tablets with wireless connections to give people access to the system.  It's not just an issue of the input form or some programing in Apps Script, people need access to the system.  If this does need to be a custom system, you can either hire someone, or you'll need to work with someone willing to do the work for free, but probably they will own the rights to whatever gets created.  There are lots of free resources that you might be able to find and make work, so that's a possibility.
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
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...