Developer Jess

 Greetings! Has been yet another long period since my last post, but hopefully the type of content makes up for it.  Today I'm writing about a need that I had to document my entire movie collection in Google Sheets, because some that were on my local network, some on DVD, some on my Playstation Video account and as well as my small collection in Google TV.  All in all there is currently over 500 movies, and growing. So the spreadsheet is fine on its own, but something nice and "pretty" was needed to list, search and filter by the movie's attributes.  I first got an API key to be used with  OMDB API .  This allows me to get a JSON of the movie's IMDB attributes with a search from the title.  I then added two functions in the "Apps Script" component of the sheet: From here, I could call the function to search (from a cell) with: =API(CONCAT("http://www.omdbapi.com/?apikey=*******&t=",ENCODEURL(A1))) That would return the JSON (assuming A1 is...

I recently published an entry where I had gotten back in to understanding how awesome the Google Script was.  I was doing a routine check to see if the script was running in good health and as it turns out, I discovered that the methods used in the ContactsApp were being deprecated - advising to switch to the People API . So, this is just a short journal entry to say I have now updated the repository using this service.  Works much the same, just links the contact to the group slightly differently.  Comments and suggestions always welcome!

I'm pretty excited to share today's post, because I have found inspiration on something I've wanted to do for quite a while.  I'm one of those users whose life is completely on Google.  A few years ago I had emptied my filing cabinet, scanned everything in and put them to easy to navigate folders in the Google Drive.  This is just amazing because I continue to photograph and scan everything including receipts - and if I need to return a product, I scan the barcode and the drive's image recognition can find it within either PDF's or images -- bang! And then there is Google Photos, where I have tagged almost everyone I have ever known, and have migrated all of my albums to one easy to search location.  Finally after a few hours procrastinating, I even put a label next to each and every one of my contacts, and now never miss a beat. But then there are my emails; while everything was up to date and marked as read, my labeling history here is less than to be desired...