My Clothes Tracking System

Melissa McEwen Feb 22, 2019

A couple of years ago I decided to do a spreadsheet inventory of my clothing because my closet had become totally unmanagable. I used Google Sheets originally. Once I made that inventory I decided to start using it to track wears. This helped me get rid of clothing I didn't like. I wrote a post on Reddit and then a Billfold article about it.

I was using Google Sheet's charting and then later Excel for data visualizations but when my coworker Lyzi Diamond created a helpful Chart.js starter/challenge I decided to try it out. I plan to add more charts in the future. In the meantime feel free to click the 🎏Glitch fish up in the top right corner and then click "remix" to make your own. The instructions for making your own and info on how I use Airtable to track clothing to it are in the The project uses a few different methods for getting and processing data, which hopefully will help you learn some ways to do this.

  • Express endpoint that formats data directly from the API- see server.js
  • Implementation of Fetch to grab that data on the front end- see public/script.js
  • Other charts are just built by objects in script.js

Wardobe by Color

A client-side Chart.js bar & pie chart showing clothing from my clothing Airtable.

Top 10 Items (by wears)

How to make your own

  • "remix" this project if you want to make charts with Airtable API/Chart.js
  • make a copy of this AirTable base
  • put your data in it see How I Log Clothing Wears
  • you can enter our Chart.js challenge if you make something you want to share!

How I Log Wears

Bear with me because this is a bit complicated but I like it haha. Basically my system is I generate a list of all possible clothing I could wear (filtered by weather, whether it needs to be work appropriate, etc.) then each day I start from the top of that list. the list

Initially when I used Google Sheets I sorted randomly (using a column with a random number). But with Airtable's linked records feature I just sort by how recently it was last worn. So something I haven't worn in a long time is at the top of that list.

The first item in the list I either decide to wear or skip. If I skip it I go to the next item. I keep skipping until I find something I want to wear. When I find something that I'll wear, I compose an outfit with it. Would be cool to have an app for that, but I just do that based on what I'm feeling and what's easy to find. If skipped, it also gets filtered out for now.

filters on list

This is where I go to the 'outfits' table. There I log what I wear for the day. And what I skipped.

outfit logging

Before I used Airtable I would manually increment the wear and skip values. You can see the relics of that in the "old worn" and "old skipped" fields. But now if I log them as an outfit, it automatically calculates that it was worn and updates the field- I use a Rollup Airtable field to do that. Same for skipped. I haven't been using Airtable that long so those aren't so valuable yet but in the future if I notice something gets skipped a lot maybe it's time to put it up for sale or donate it.


I can see a lot of cool uses for this data like seeing what items I wear together often.

I have a "defunct" table with stuff I've gotten rid of, might just keep that data in the main inthe future. So far I've gotten rid of 128 items. The table shows the reasons andwhat I did with each.

Either way, I'm grateful that my clothing is a lot more managable and I love many more of my items than I did when I started.