Stream

Join this community to post or comment

Romain Vialard
moderator

Case studies  - 
 
 
We recently released the 800th version of Yet Another Mail Merge and I was wondering if other add-ons were updated with the same frequency. So I started to collect data about every add-ons available and here are some metrics.
We recently released the 800th version of Yet Another Mail Merge and I was wondering if other add-ons were updated with the same frequency. So I started to collect data about every add-ons available and here are some metrics.
5
1
Add a comment...

Luân Đỗ

Case studies  - 
 
I want to get time and email (or full name) of users that log in to my spreadsheet and show the results in another spreadsheet. or current spreadsheet.

Can anyone help me the script?

Thank in advanced.
Luan.
1
Alan Wells's profile photo
Add a 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...

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
1
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...

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...

Daniel Florey

Case studies  - 
 
Hi developers!
We are working on the next Ultradox release which will go live in November.
The new version will allow you to create enterprise-ready apps that play nicely on mobile and desktop by simply assembling a number of building blocks!
This is demo that I've created to show some of the upcoming features:
http://www.ultradox.com/app/Demo
Ultradox has been designed from scratch for Google Apps and can be extended using Google Apps Script.
We are have just started our trusted testers program and I'd like to invite all of you to join!
If you are interested, please fill out this form:
https://docs.google.com/forms/d/e/1FAIpQLSdzXoCX55-N2bGhaqUHbmB7UhvxMEkMcRJOvyKILXb8t8lYuA/viewform

If you have any questions or comments, please let me know.

Thanks all,
Daniel
Ultradox Demo. Ultradox Demo. Anmelden. Über. Diese App wurde von daniel.florey@gmail.com erstellt. Powered by Ultradox. Ultradox · Help · Privacy & Terms.
6
Add a comment...

Adam Lusk

Case studies  - 
 
Regarding toggling a form for accepting responses by script.

function test() {
var form = FormApp.create("Test form");
form.setAcceptingResponses(false);
var item = form.addTextItem();
var itemResponse = item.createResponse("Hello world");
var formResponse = form.createResponse().withItemResponse(itemResponse);
form.setAcceptingResponses(true);
formResponse.submit();
}

The script will throw an error on the bold line, but from what I can see, it is the creation of the form response while the form is not accepting responses, that generates the error. If the setAcceptingResponses(true) is moved one line up, it works - so creating item responses does not require the form to be accepting responses.

This may be working as intended (after all, one can't actually view a form when it is not accepting responses), but I would expect the script to throw an exception on the createResponse() line.

My use case is to shut out potential responses for as close as possible to submitting a constructed response by script. I suppose the best you can do is generate all the item responses, and after accepting responses, construct the form response then.
1
Alan Wells's profile photoAdam Lusk's profile photo
2 comments
 
Hi +Alan Wells; not really, just working on a tool that needs to determine which form questions land in which columns of a spreadsheet, in case the order has been changed around. But that's by the by; I guess the point of my post is simply that form.createResponse(...) will actually create an "unsubmittable" response, if it is created while the form is not accepting responses.
Add a comment...

Joan Gomez

Case studies  - 
 
Hello,

Anyone know how to export the chronology of maps to Spreadsheet.

Export would google my own account.

Thank you very much.

Translated with google translator


1
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...

youssef a

Case studies  - 
 
Controlling humidity and temperature using Arduino and Google Script
6
1
youssef a'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...

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...