TOOLS
Need & Problem
The company was already using Airtable for time tracking and HR processes, but:
• The system had grown complex over time
• Bugs and structural inconsistencies existed
• Documentation was limited
• Time tracking, overtime, holiday tracking and sick leave logic required maintenance
• Approval flows and automated emails needed stability
They needed someone to:
• Take technical ownership
• Understand the existing architecture
• Maintain and stabilize the system
• Improve reliability and transparency
The Solution
Took over an existing Airtable time tracking & HR system
• Reverse-engineered the database architecture
• Identified and resolved structural and logical issues
Maintained and optimized:
• Time tracking per project (for client invoicing)
• Overtime logic and conversion into holiday time
• Holiday request approval workflows
• Sick leave tracking and yearly calculations
• Carry-over holiday balance logic
• Stabilized automated email notifications
• Improved formulas and system clarity
• Ensured long-term maintainability
• Provided ongoing support and technical ownership