Stream

Join this community to post or comment

Truck Suvidha

Case studies  - 
 
how to get response success after share on google + using javascript
1
Add a comment...

Anees Hameed

Case studies  - 
 
Will it be possible to transfer ownership of script/webapps created inside a container (Sites, Spreadsheet, Docs) or does it has any technical difficulty...
1
Anees Hameed's profile photo
3 comments
 
Recently I completed a Google site project for a client. I have transferred site ownership to client, but scripts are still under my ownership... 
Add a comment...

Marcos Gomes

Case studies  - 
 
I did not succeed with Script. Use commands to increment numerical and alphabetical order.
http://goo.gl/HhrZPE
1
Add a comment...

Bruce Mcpherson
moderator

Case studies  - 
 
Following on from the release of the ScriptDB reproduction library yesterday , I applied it to the first of my project backlogs today. Blister is a library of lookups and validations that can be accessed from a webapp, a script or as a function in a spreadsheet. Now all the shared lists are hosted on MongoDB, but the interface is the same as before. See http://ramblings.mcpher.com/Home/excelquirks/listsandvalidation for more info.

Directory of public lists is here.
https://script.google.com/macros/s/AKfycbzBskBK17poScDU9yHnfgmgPHyvgNejM3zxV7niGdhLeXPjw7Y4/exec?library=blister&func=blisterDirectory

#gde   #googleappsscript   #blogpost  
4
Add a comment...

Bruce Mcpherson
moderator

Case studies  - 
 
This is about 6 months too late, but it's been a lot of fun creating. If you still have some old small projects written for ScriptDB that you didn't get round to converting yet, then here's a library that's a complete recreation of the ScriptDB syntax, except that it uses dbAbstraction back end - so you pick whatever platform you prefer and your old ScriptDB code should work with not a lot of modification. 

#gde   #googleappsscript   #tutorial   #opensourcecode  
4
1
김진달's profile photo
Add a comment...

Spencer Easton

Case studies  - 
 
I've come across the error:
Created too many projects in a short time

   This appears to be a quota for the Google Developer Console. Though I can't find any listed limits it appears to be about 200 in 24 hours .  I'm not certain about the time period but that is how all the other quotas work.  
   
While in this limit you can still create and edit a script, but can't execute any code in the new script.  All scripts created previously  still work as expected.

Drive Web API will return error code 500.  Drive advanced service will throw the error "Internal Error"
1
Bryan Patterson's profile photoSpencer Easton's profile photo
2 comments
 
Buggy code.  It was supposed to combine lots of files into one script, but ended up making a new script per file.  Didn't break the quotas and limits on the drive api side but got me locked out of the dev console.
Add a comment...

Bruce Mcpherson
moderator

Case studies  - 
 
You can get all your apps scripts, libraries and dependencies up to git hub and documented automatically with this apps script project. No need for local files as everything happens on drive, and no need for local git software or any particular OS as it all happens with the github API.

With the collaboration of +Riël Notermans and +Spencer Easton I finally got this working and written up. 

Of course the project put itself of github when I was done. 
https://github.com/brucemcpherson/gasGit Feel free to help improve.

#gde   #googleappsscript   #tutorial   #opensourcesoftware  
28
7
김진달's profile photoMats Nilson's profile photo
Add a comment...

Kishore Kandru

Case studies  - 
 
Just wanted to share and get thoughts on a google sheet app (with apps script) that I put together to manage project plan execution during the go live time.

The intent is to use this only for execution and not for planning purposes (at least for now)
--------------------
Key Requirements:

For a central team(like PMO):

Give visibility to entire team on where the project plan stands at any given point in time

Ability to search by a task id (for quick status) right at the top of the spreadsheet

Ability to send trigger emails to task owner(s) from the spreadsheet 

Ability to receive emails based on the task status updates (for example, when it is marked complete)  

For Task Owners:
Ability to update task status (with the help of dropdown values for data integrity)
-------------

Would love to hear your thoughts on something similar you built or thought of.

thanks
6
3
Kishore Kandru's profile photoSkevin Wu's profile photoKanakorn Horsiritham's profile photoMathieu Hardy's profile photo
5 comments
 
Would love to get some feedback on this, please take few mins to share
Add a comment...

Lenny Cunningham

Case studies  - 
 
#Barcode  scanning with #appsscript  and #Chromebook

Sorry for delay but finally getting around to making copies of our medical inventory system, and redacting what I needed to.

Attached is link to a folder that includes 3 spreadsheets that are copies of the ones in the video.
https://drive.google.com/drive/#folders/0B_mOEVr803HMbEZpd09kb3JoVlE/0B_mOEVr803HMTFBBandvdmtXZEU

Disclaimer this was specifically built for handling medical inventories and doing that with #googlesheets .  Purpose was to be able to make changes on a "Master Inventory" and then with the use of apps script push changes out to separate identical spreadsheets, one per station.

This becomes very difficult with out the use of apps script because you can't simply importRange() a column into multiple sheets, then go and add or remove a row item.  By doing this all the associated data for that row is now offset.  Using the master sheet there is a menu for performing this action with the use of scripts.

Second is keeping the same look.  The master has templates of the separate areas that are inventoried, and you can create your look and formulas you need in there, and push that formatting out to all the separate spreadsheets, with the "Push Formatting"

The scanner:
Almost any wired, wireless, or bluetooth scanners seem to work.
All they do is act like a keyboard, when you scan a barcode it transfers it into key strokes just as if you typed it on the keyboard, then follows it with an enter key command.  So using HtmlService all you need to process a scan is a text box and some jQuery.

$('#barcode').keyup(function(event) {
        if (event.keyCode == 13) {
          var barcode = $(this).val();
       //do something with barcode data/////////
}


Setup
1. Each location spreadsheet has a "setup" sheet.  The Master sheet ID and the name of that location need to be set, that's it.  It will import the rest of the info it needs from the master.

2. The master has a "setup" sheet also, that needs the keys from each locations spreadsheet, and their respective names.

Enjoy picking it apart, feel free to ask questions, and send recommendations.
31
18
Bas Moed (ESP)'s profile photoVitali Neumann's profile photoJose Alzueta Mancoeduca's profile photoAGUSTIN GARCIA (Freelancer Excel)'s profile photo
12 comments
 
Thank you Lenny,
I really appreciate how you've tidied up the code (no more ScriptsLib!), and added a generous portion of comments. I've learned a lot just by going through your work line by line, so I look forward to chewing through this version. I don't mean to be punny but you certainly are a life saver!
Add a comment...

Jonathon Broughton

Case studies  - 
 
Working on something fun to get up and running in 2015

#Library #PushBullet
9
Spencer Easton's profile photoJonathon Broughton's profile photo

A. Luca B

Case studies  - 
 
Guys,
i'm starting to look to the use of GAS for Sites deployment and administration.
I know very well the API but i was asking to myself if someone developed some real life examples of scripting Sites deployment and GAS Applications integration ? 
1
A. Luca B's profile photoWeb Apps R&D's profile photo
5 comments
 
May be, that depends on your use case. We use Spreadsheets, Documents and Sites and try to make the most out of it. The problem is, to educate people in the use of collaboration feartures of the Apps. PC is not as easy as Google Apps, but conditioned the habits.
Add a comment...

Niklas Ternvall

Case studies  - 
 
It would be a nice feature to add Cloud Print as a Advanced Google Service, or even a Method to DokumentApp. 
2
Niklas Ternvall's profile photoLenny Cunningham's profile photo
3 comments
 
I built this connector for Cloud Print
http://ramblings.mcpher.com/Home/excelquirks/guests/cloudprint

We use it to automatically print inventory reconciles and shipping labels, from an internal shipping dashboard.
Add a comment...

S.Jibreel Hussain

Case studies  - 
 
Is it possible to have a table in sheets that keeps records of sales with the salesperson name?  When I share the sheet with the different sales people, I only want them to be able to see the rows on which they're listed as the saleperson.

Actually, are there any GAS developers here that would give me a quote for building a simple GAS based solution for what I'm trying to do?
1
1
A. Luca B's profile photoS.Jibreel Hussain's profile photo
11 comments
 
Thank you everyone for all the suggestions.
Add a comment...

Shwetabh Kumar

Case studies  - 
 
Sharing my recent experiment with Google Apps Script. 

I use Google Tasks and Google Calendar for managing all my reminders. Official Google Tasks app is pretty limited (especially the recurring reminder and shared appointments) but the Android Client I use on my mobile is amazing (in short I am sticking with Google Tasks App for managing my reminders).

Problem: I find it very easy to dismiss/cancel Google Calendar reminders on my mobile  (Android) whereas Google Tasks app I use keeps nagging me until I don't complete it. Love that feature.

Solution: Merge the two :-)

A little script I wrote that syncs Google Calendar Appointments to Google Tasks app.

Checkout the detailed post here: http://goo.gl/FJrIiJ
and the video.

Let me know your thoughts. The code is opensource for anybody to extend/improve it.

#googletasks   #googlecalendar     #googleappsscript  
    #diy   #funprojects   #todo   #lifehack   #gettingthingsdone  
6
2
François Humbert's profile photoChristoph Schöni's profile photo
 
My next test
Add a comment...

Edouard Brasier

Case studies  - 
 
This is a case study illustrating the use of Google Apps Script to drive Finance Change. The application allows businesses to efficiently manage their expenses saving on processing time and reducing mileage fraud. 
This is my first IFRAME script developed with some help from the community.
IBM Cognos TM1 Consultancy in London. Forecasting Planning Budgeting Spreadsheet Control and Audit. Digital Consolidation. Google Apps for Work. Google Apps Expenses Manager.
10
3
Edouard Brasier's profile photoEd Brasier's profile photoJurrie Hobers's profile photo
4 comments
 
Now You can worry less about the possibility of losing  your expenses receipts. Just take a photo of your receipts and upload them directly to google drive. The receipt URL is saved in the google sheets database with the related claim ID and description. 
Add a comment...

Andrew Roberts

Case studies  - 
 
(Fairly) high-res terrain generator in Google Sheet! Further to yesterday's release of Color Scale I've done a little mash-up with a terrain generator to create some pretty pictures in a Google Sheet. Anyone got a 257x257 range of data that would actually benefit from this?? #googlesheetcolorscale  
Having just released the Color Scale Add-on I was having a play around with a terrain generator and created this (fairly) high-res terrain in a Google Sheet! The terrain generation script is based on Hunter Loftis’ “Realistic terrain in 130 lines”, and just took a little tweaking to file the spreadsheet with a set of terrain height …
11
2
Bruce Mcpherson's profile photoJonathon Broughton's profile photoAndrew Hyland's profile photoRolando Hugo Garcia Villarreal's profile photo
2 comments
Add a comment...

Filipe G L F W

Case studies  - 
 
So +Scott McAllister posted about a method to get number of pages of a Google Doc by converting it to PDF.
Post: https://plus.google.com/u/0/113728042813412048026/posts/Wc6x7iWNMdj Method:  http://stackoverflow.com/questions/11774217/how-do-i-find-the-page-number-number-of-pages-in-a-document

This method can only grab the number of pages of a file, however once we have the PDF's blob there should be a way to find the number of the page a given text/paragraph is at.
I started to search and found a method that uses Mozilla's PDFJS to iterate through the PDF pages and grab the text.

Method: http://stackoverflow.com/questions/1554280/extract-text-from-pdf-in-javascript/20522307#20522307

The first issue I found is that PDFJS grabs the PDF from a URL, I've read that it is possible to pass a blob (that is what we have) to it, but it is well beyond my javascript knowledge.

So, is anyone willing and could come up with a solution? I've been trying to understand better how it would work but for now is too advanced for me ;)

Maybe a library could be created from it, to overcome the lack if this feature on GAS, which I think won't come soon, since request for it is open in the issue tracker since 2012.
1
Riël Notermans's profile photo
4 comments
 
Just feed the URL of the Google Doc to PDFJS, instead of /edit put /export?format=pdf in the URL.
Add a comment...

Lenny Cunningham

Case studies  - 
 
Import +ForeFlight flight logs into  #googlesheets  

I might be the only one in this community with a need for this, but I'm not too selfish to share. I had a need to get flight logs generated in Foreflight from our pilots into our system.  So wrote this #appscript  to extract the data from a Foreflight generated email.

Step1: Make a copy of this spreadsheet. Open the script editor and run getFlightPlanEmails() to authorize.  Then set it on a trigger for how ever often you want it check your email.

Step2: Email a flight plan from Foreflight to your gmail address except add "+flights" before the @. example "maverick+flights@gmail.com"

It currently just returns some info, and then a JSON object containing each leg, but you could split() that data how ever you please in the sheet or in another script.
3
Lenny Cunningham's profile photoAsh Clarke's profile photo
3 comments
 
Great, thanks for sharing
Add a comment...

Bill French

Case studies  - 
 
Database Not Required

A client recently asked -

"What database are we using and what ties the data relationships together?"

My answer:

"Your application is built without bias to any database technology; it relies on no database in particular and seamlessly interfaces with every database. At its core, it is a cloud-based association of documents, communiques, and data tables that are integrated through lightweight scripts."
Note - This is Part Seven in a [seemingly] endless story about the New Frontier of application services made possible by Google Apps.A client recently asked -"What database are we using and what ties the data relationships together?"When this client's project began, it was very much about process automation (of data), but not specifically about data management itself. To be clear, data management was not the challenge. Other hurdles involving wor...
3
Add a comment...

Jacob Jan Tuinstra

Case studies  - 
4
4
Jan Merta's profile photoKena Clark's profile photoRon Carroll's profile photoWeb Apps R&D's profile photo
5 comments
 
Thx for the hint.
Add a comment...