How Faraday Bicycles manages their business inventory on Airtable.
As the operations manager at Faraday Bicycles, a small San Francisco-based company that makes beautiful electric bikes, Victor Lane handles a lot: with responsibilities ranging from invoicing and customer service to inventory and logistics management, he needs to have a clear picture of the business at all times.
Before finding Airtable, Lane managed all the (literally) moving pieces of the company using spreadsheets. It wasn't an ideal solution: "It's not what spreadsheets are designed for. As soon as I shared a spreadsheet with someone in the company, we had two versions and reconciling them was terrible." With Airtable, Lane is able to add his coworkers as collaborators who can see and make changes in realtime.
Right now, Lane uses Airtable to keep track of issues and replacement bike part inventory. "Any time we have a failed component in the field, I record the information in here," says Lane. For quick entry of the necessary information, he uses a form that he automatically generated from his existing table.
Although the issue tracker started out simply, with just the date, the name of the part, and what went wrong, "as more info came up or as people asked for more, or we came up with more to track, I could add it," he says.
Check out the Faraday Bicycle Issue and Inventory Tracker below.
How nonprofit She's the First manages events and student leadership programs using Airtable.
How artist Kim Holleman uses Airtable to reimagine school interiors.