A Office add-in for Excel.
One day a few of my peers on the creative team came to me with a request/challenge – could I build a Sketch plugin that streamlines keeping image assets up-to-date in their comps? After a few iterations, I believe I settled on a solution for them, see the [narrated] video below for details.
- assign local/remote URLs to image layers
- data is saved at the document level and persists (see sketch file format for more info about this)
- upon menu item click, or document open, grab layer object via saved layer ids and update image data with associated URL
- no need to iterate through layer hierarchies (slow/wasteful), no need to rename layers, no need to keep directories in a specific structure
- Document Settings – for saving data
- Actions – for listening for document open, etc.
- From Native – for getting document from action context
If you have any further questions about this, please reach out!
More info – https://developer.sketch.com
Key Technologies: HTML, CSS, JSON, AR, Web Services, OWL Carousel
I really wanted a quick and secure way to get a breakdown of my spending without having to give up my banking details to a third-party. For the longest time I was using an excel spreadsheets and doing a lot of work manually to categorize transactions and compute totals. One day I decided to just build my own tool!
- Chase’s developer API is invite only, so used their csv data dump option
- Lots of pre-work happens before rendering the charts, data from csv is converted to objects, grouped by months, computed for totals/averages/etc., and then categorized by user inputted data
- The transaction list allows me to flag what category a transaction should fall under – under similar transaction will automatically be assigned that category unless explicitly overwritten.
- Using chart.js to render the charts – this framework is incredible and really easy to use
Below is a video of what I settled on for a v1. It does everything I need it to quickly, and makes understanding where I’m spending my money clear. Some future enhancements will include:
- Monitor Chase’s API to see if it opens up for normal developers
- Flag transactions that fall outside a specific variance (unexpected transactions)
- Show top 5-10 places I’m spending money, e.g. how much money am I spending at Chipotle!
- Add pagination for transactions list
- Show YOY information and trends
- Add ability to layer in a second account
- Refactor code to reduce redundancies in calculations
To make a better guest experience I was asked create some new html templates to be used in our app’s message center (powered by Urban Airship). Although this used technologies I already knew, there was a ton of specialized learning to understand how all the pieces fit together.
Some key callouts were: understanding how the html entities needed to be prepared/attributed in the template creation process so that the UA CMS sees them as editable fields, exploring how the UA webview creates a JS bridge and passes a UA object to be used by template at run-time, and how the template itself reaches out to UA for user specific data with the help of data passed in the CMS process.
- Informative walk-by video
- Browse products by featured category, add products to a collection and then text yourself that list
- Scan products and get information/reviews quickly with the built in UPC scanner
- Learn about our rewards program and text yourself a link to sign-up
- Play around with the build in lights and lighting presets
- Watch how-to tutorials videos
- Try on virtual lipstick
- When all else fails, use it as a mirror!
PTS Explorer is a quick way to find instagram photos of a given PTS (paint to sample) color. A few months ago I noticed there were many Instagram accounts centered around PTS colors – this worked well to see many examples of different colors, but what if you didn’t know all the colors, or wanted to see many examples of a certain color?
These questions prompted me to create PTS Explorer.