Menu

Hack Week Project

“Hey, what do you want to do for a hack week project?

My friend Lukas came to me with an idea for making a tool to organize 3D Robotics‘s software department during our Hack Week. We are growing fast, and it’d be super helpful to have something that displayed everything that was going on while also having a cute UI.

ENTER: WALDO

Our team was called “Cat Paws”, which included:

  • Ed: Icon design.
  • Lukas: Project manager spreadsheet overload + Apps script guru.
  • me: UI design + rails app master + front end development + staging/production server czar.
  • Pancho: My pair programming partner + “rubber duck” substitute. Specialized in quality control. 

PROBLEMS TO ATTACK

  1. Need an easy way to know who new people are and what team they are on.
  2. Need an easy way to see who is working on what projects.
  3. Super hate company wide emails that tell where a person is going if they are Out of the Office, so we wanted to show everyone's OOO status.
  4. Want to know who has what skill so that they may be a resource for said skill.
  5. Want to know who is Technical lead on teams. 

WORKFLOW

Because we didn’t want to have our Project Managers learn a new tool’s UI for inputing data, Lukas used google APIs to take a google spreadsheet and turn it into a hash that I could use in a rails app via Https request. This way, there is literally no difference in their workflow, and we just pretty up the data they already have.

The data flow is as follows:

  1. Google Spreadsheets –>
  2. Apps Script –>
  3. Google Calendar integration –>
  4. Rails App

Names and projects have been changed on the portfolio site for security reasons.


RESULTS

We were the first (and only, to my knowledge) hack week project to make it to production!

check it out


New UI

Because we require oauth 2.0 sign in on the actual app (not the portfolio one you can see), I made a cute sign in page for the “welcome” page. I also made a little logo to go along with the title in the top nav.






Next up:

Because I'm always onto the next step, I'm in the process of making this app a stand alone app with it's own UI for inputting people's profile data. We took the google API script as far as it could go for this level of complexity, as the fetch time for the profile data is getting pretty high. React js is a great fit, and I'll report back soon : )