Skip to content
We Sort.

InJoinery data systems

NB: This write-up is a work-in-progress.

In Joinery is a specialist labour agency that provides fitting teams to joinery firms that need their work installing.

Since 2021 I've worked with Todd to refine the business direction, and to develop the operational processes and data infrastructure. We’ve built, evolved and maintained data systems that accommodate operations and workflows across the business.

More on that here: InJoinery Strategic work

Data tools

Airtable in practice

Ref: An overview of Airtable

In our context, we've created core tables for Clients, Projects, Fitters and Bookings (plus some others). We can see who's booked where, what status those bookings are at, what the rates are, how the profits sit and much more. We’re at tens of thousands of records across the tables and hundreds of changes are made throughout each day.

To ensure our data is following the guidelines we set for ourselves, we make extensive use of 'dirty' views. These views make heavy use of filtering to let us know if something isn't well aligned. Keeping these views empty is one of our critical daily goals. A few examples:

  • A booking for tomorrow that's Tentative (this should be confirmed by now)

  • A project with bookings that are 'Complete' that lack rates

  • A team member with a 'Confirmed' booking that lacks necessary contact details