Recently I was tasked with building a new template for our Photo and Production teams to make it quicker and easier to view our templates for each of our product category and subcategories. Currently our team members use a version of smartsheet with nested categories and an overload of information.  My goal for the team is to build a web application that is image-centric and pertinent meta-data is displayed in a concise and out of the way format.  One of the big issues that we have is smartsheet displays primarily in text, is slow to load, and is difficult to wade through to get to the data that you need.

By replacing smartsheet with 3 drop downs that auto-populate options, we don’t need to spend time looking up text data when 95% of the time images only are the data that needs to be delivered.  On the backend, the data is stored using JSON, the front end powered by jQuery.

Live link

Another small project for work in which the department requests to take a weekly export of data in the form of a CSV, or more accurately a list of semi-colon separated values (ssv?) and append certain data depending on the year found within each row.

Another fun quick project written using javascript/jQuery that utilizes the FileReader() class in jQuery and the onchange event in javascript on the <input type=”file”> element to load that file into a new instance of FileReader object and begin an asynchronous process that loads the lines into an array. From there the array is copied over and the relevant keywords/data are appended to the end of each array element according to predefined criteria.

This code is executed and creates the new payload client-side.

Script Here