Profile

Cover photo
Lenny Cunningham
Attended Patterson High School
Lives in Lafayette, La
155 followers|231,646 views
AboutPostsPhotosYouTubeReviews

Stream

 
Anyone else have to constantly delete and re-install this for it show Office Apps, when trying to open their respective documents?
Open Drive files directly from your browser in compatible applications installed on your computer.
3
Add a comment...
 
#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's profile photoVitali Neumann's profile photoJose Alzueta Mancoeduca's profile photoAGUSTIN GARCIA'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...
 
Is it possible to create 3 vlans. Where 1 & 2 can communicate with 3 but 1 & 2 can't with each other?
1
Team One Solutions's profile photoLenny Cunningham's profile photoFabio Cellini's profile photo3anetwork com's profile photo
8 comments
 
yes, using pvlan technology or VACL. pvlan is more safe.
Add a comment...

Lenny Cunningham

Problem/Coding Help  - 
 
Almost posted this the other day, but then thought I had it. Now I'm back to having "code block".  When the need arises to build a standlone script as a webapp and include it as a library in others. You have to copy all the individual functions that the HtmlService calls with google.script.run (or at least i do). 

google.script.run only calls the local script functions, you can’t call library functions either.
So I’m having to copy the worker bee functions into multiple spreadsheets.

So how can one go about basically creating an importable namespace with only one function from a library..

So if I have multiple spreadsheets and they serve the same purpose for different locations (ie inventories at bases), and they all share a library of common functions. I want to write the web app with something like:

Library - 
var masterFunctions = {
  function1() {},
  function2() {}
}

ChildSpreadsheet - using Libray

function masterFunctions(e) {
 return Library.masterFunctions[needed function(e)]
}

This way when creating new stations or updating existing ones with features, that you only need to add the libraries and this one function.
1
Lenny Cunningham's profile photoDavid Bingham's profile photo
8 comments
 
+Lenny Cunningham Glad it helped!
Add a comment...

Lenny Cunningham

Problem/Coding Help  - 
 
I've created a solution to this question on SO.  But I think there is a better way and looking for some more input.  Generating the label with HtmlService is just creating havoc for trying to print it on a label printer. I can't seem to make the labels smaller and still maintain the quality of the barcode, for the readers to be able to scan it.

Trying to get to label size 62mmX29mm
1
Bruce Mcpherson's profile photoFaustino Rodriguez's profile photo
2 comments
 
have you tried the barcode font approach?
http://www.barcoderesource.com/barcodewebfont.shtml
Add a comment...
 
Here is a GCP Apps Script Connector.  We're using this to auto print reconciles of a specific inventory, and also using it on a shipping dashboard, and printing UPS labels on a Zebra ZP450.
1
Add a comment...
 
Alright who broke the HtmlService?
Anyone else having issues?
Keeps switching Sandbox to Emulated and not pulling in the Add-On CSS package.
1
Frédéric Morel's profile photoJonathon Broughton's profile photoLenny Cunningham's profile photoTrevor Iampen's profile photo
12 comments
 
I just talked to +Eric Koleda and they have pushed a fix through for my issue. Thanks guys!
Add a comment...
In his circles
164 people
Have him in circles
155 people
Amy Domingue's profile photo
Dustin Skarra's profile photo
Nathan F's profile photo
Andrew Landry's profile photo
Bob Watson's profile photo
Greg Rumph's profile photo
Ronnie Pitcock's profile photo
Thomas Falterman's profile photo
Jonathan Shipps's profile photo
 
Noticed two new things so far today in Apps Script GDE.  Under Publish there is now "Test add on".  And under Resources Libraries is no longer tagged with experimental. 
6
1
Frédéric Morel's profile photoWeb Apps R&D's profile photoFaustino Rodriguez's profile photoBruce Mcpherson's profile photo
4 comments
 
the "Test as add-on..." is promising
not sure if it would allow for other users (users group) to access for testing
Add a comment...
 
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...
 
Finally some daytime shots for yall.
6
Will Griffin's profile photo
 
nice pics from the best...i mean westbank
Add a comment...

Lenny Cunningham

◯ Night Photography  - 
 
The darkness of the river, snaking through the city. Something so majestic about it.
8
Add a comment...
 
Huey P and the Gulf of Mexico. Rare to see the GOM look smooth.
8
Sassy Dana Zeller's profile photo
 
Gorgeous! :)
Add a comment...
People
In his circles
164 people
Have him in circles
155 people
Amy Domingue's profile photo
Dustin Skarra's profile photo
Nathan F's profile photo
Andrew Landry's profile photo
Bob Watson's profile photo
Greg Rumph's profile photo
Ronnie Pitcock's profile photo
Thomas Falterman's profile photo
Jonathan Shipps's profile photo
Education
  • Patterson High School
    1996 - 2000
Basic Information
Gender
Male
Work
Occupation
Flight Paramedic/Rescue Specialist
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Lafayette, La
This particular location is the main office, not an actual restaurant.
Public - 4 months ago
reviewed 4 months ago
By far the best customer service I've had at any Popeyes restaurant.
Public - 5 months ago
reviewed 5 months ago
Public - 7 months ago
reviewed 7 months ago
8 reviews
Map
Map
Map
Called, they advised they had a screen in stock for my iPhone5. Dropped it off at lunch and they had it ready by 3. Even took the the time to clean up my camera lens, that appeared blurry at first. Thanks for the quick and fantastic work.
Public - 5 months ago
reviewed 5 months ago
Public - 7 months ago
reviewed 7 months ago