Skip to main content

My Time With Google Apps Script: A Short Summary

JavaScript and Google Apps Script

Over the last year and a half, I've been teaching myself JavaScript quite obsessively. I've used the knowledge to build a few applications for use at work --to log phone calls and orders, generate Bills of Materials, and analyze costs. All of this has been done through the Google Apps Script application programming interface (API), which allows one to write custom automation for Google's Apps such as Docs, Sheets, and G-mail. Scripts run in a JavaScript environment on Google's servers, but one can also build HTML user-interfaces (UIs) that plug into the apps, or stand-alone scripts with their own URLs. Thus I've been able to build my own apps, without needing to worry about registering with a hosting company. The code structure for an HTML UI requires one to segregate 'server-side' and 'client-side' JavaScript, and use a simplified AJAX-like API to send data between the client and server (I use single quotes because i'm approximating the words client and server to refer to their more common meaning, but because the Google Apps Script environment abstracts away the need to deal with HTTP, 'server' and 'client' code looks much more tame that how it would appear in a more open web environment). The 'client-side' JS runs in an I-Frame sandbox, so one can use popular libraries like JQuery and ReactJS though a CDN, or including the library in the Script itself. I've gained quite a bit of experience working with JavaScript and JQuery in regards to processing data and building application structures. But despite all of this, the scope of working in this environment is highly limited. I could go into more detail, but suffice it to say that I'm looking forward to exploring a more open Web Stack.


One thing I've realized is that I would like to seek out opportunities to work in the field of Software Development. I feel that I have a knack for problem-solving, as well as the creativity and imagination required for building applications.
This fall, Jessica and I will be moving to Russellville Arkansas, where she will be a visiting professor for Visual Arts at Arkansas Tech University. This presents me with the opportunity for lowered tuition costs, so I will be attending ATU to pursue a BS in computer science, in order to create a fresh start as a professional programmer. With a degree I will be better suited to explore more areas of Computer Science than simply web-development, which I'm beginning to feel may be an over-saturated field.

Labels:

Comments

Post a Comment

Popular posts from this blog

About Joel Jonientz

A few days ago, one of my most influential professors died of a heart attack. His name was Joel Jonientz ( blog ), and he was 46. Joel was my teacher for a few projects, starting with an attempt at making a video game. His role was keep a bunch of misfit digital punks inline, and keep them on task with their delegated duties. I was a part of the music team, together with Bernie Thomas. Our job was to compose music for each level. This was pretty important since the game was based around the music, kind of like Dance Dance Revolution or Guitaru Man , where the player had to hit a button or something in-time with the music. But our game was different: it would be like Mario Bro's, a "platformer", where hitting a button in time with the music would give the player a boost to get up to a difficult platform, or some other super awesome power that would help them complete each level. Composing the music meant figuring out how to encode the required series of 'power...
2 comments
Read more

Tech Archaeology: Unearthing the Artifacts of a False Prediction

Greetings. This is going to be a shorter rant. New year, new me! Anyway, I was inspired to write this after I caught myself falling into a usual habit: investigating the validity of a prediction which claims that a technology (it could be anything) will take over in the future. I'll start from the beginning. It all started when I was dutifully studying for my Databases class. While reading the textbook, Database Processing  (13th edition) by Kroenke and Auer, I came across a passage that was summarizing the history of database processing. Being that this book first came out around 1977, it has probably witnessed very few shifts  in the popularity of database technology over its existence; namely, the rise of Relational Model and its subsequent dominance. Never-the-less, in a table that describes the emergence of database technology, there is a row for the "XML and Web Services" era (after "Open-Source DBMS" and right before the "Big Data and NoSQL"...
Post a Comment
Read more

Parallelism and Task-Decomposition: An Introduciton

Introduction Since I’m on holiday break from University, I’ve had time to begin investigating parallel processing. I’m going to try and share a little of what I’ve learned about the technology and how programming languages can leverage multi-core CPUs and GPUs. I’ll finish up and explain a bit about task-decomposition , which is an important aspect of writing algorithms intended for parallel processing. My investigation began one night as I was cooking dinner and watching a talk by Rich Hickey, the inventor of Clojure, titled “Are we there yet?” . At one point, while Mr Hickey was discussing parallel processes, the question of “how does a GPU process pixels?”popped into my head. Surely that must be parallel, right? Since my “Intro t...
Post a Comment
Read more