3 Platforms Connected: Airtable, Outlook, and Everhour

The Situation

A marketing and advertising agency came to us with an Airtable workspace that the team was already using, but not getting much out of. Tasks lived there, deadlines lived there, assignments lived there, but pulling up Airtable didn't tell anyone what to actually work on next. The team had to scan through long lists, figure out what was urgent, and remember which tasks were theirs across multiple projects.

Time tracking happened in Everhour. Calendars lived in Outlook. Neither connected back to the work itself, so seeing what was due, what was being worked on, and what was scheduled meant checking three different places.

The brief was direct. Make Airtable the place the team actually opens in the morning, with what's urgent visible at a glance, calendars connected, and time tracking tied to the work.

Our Approach

We built a color-coded task system inside Airtable, where urgency is visible the moment the team logs in. Red means overdue, green means due today, yellow means coming up. No reading required. The team sees the colors and knows where to start.

Each team member got their own dashboard view, showing only their tasks, sorted by deadline, with quick numbers at the top: how many active projects they're on, how many tasks are due now or in the next two weeks, how many are due later. Click into any team member and the same structure shows up for them. Managers can scan the team in seconds; team members can focus on their own work without distraction.

Automation handles the handoffs. When a task gets reassigned through the agency's "tag you're it" workflow, the assignee updates automatically in the background. No one has to remember to update two fields when work changes hands.

Outlook calendars connect directly into the system, so tasks with deadlines show up in each team member's calendar without anyone copying anything across. Everhour syncs with Airtable too, so the hours tracked on a task tie back to the project and the person who did the work.

Closed work moves out of the way. A dedicated archive view filters out completed tasks from active dashboards, but keeps them accessible for reference. Reopening a task takes one click if a client comes back with new requests.

Before

• Tasks lived in Airtable, but urgency wasn't visible without scanning long lists

• Time tracking happened in Everhour, calendars lived in Outlook, neither connected back to the work

• Reassigning a task meant updating multiple fields manually, with room for things to get missed

• The team had no single view that showed them what to work on today

• Managers had no quick way to see what was past due across the team

• Completed work cluttered active views until someone manually cleaned up

After

• Color-coded task urgency: red for overdue, green for due today, yellow for upcoming, visible at a glance

• Per-team-member dashboards showing only their tasks, sorted by deadline, with active project counts up top

• Automated assignee handoff through the "tag you're it" workflow, with no manual double-entry

• Outlook calendar integration so tasks with deadlines appear in each team member's calendar automatically

• Everhour integration tying tracked hours back to the tasks and projects that drove them

• Dedicated archive view that filters out closed work from active dashboards while keeping it accessible for reference

• One-click reopen for archived tasks when clients come back with new requests

The Outcome

The agency now has an Airtable workspace the team actually opens first thing in the morning. The colors tell them what's urgent without them having to read anything. Their dashboards show them their work, their calendars show them their deadlines, and their tracked hours flow back to the projects they came from. Managers can see the whole team's status in seconds.

What used to be a workspace the team scrolled through is now a workspace they work from. The system saves coordination time every day, and as new work comes in, the same structure keeps it organized without anyone having to redesign the setup.