Overview
IT asset audits relied on Excel; assets were frequently unaccounted for or misplaced during handoffs.
Back to Projects
Airtable Asset Management
Designed an Airtable-based hardware tracker integrated with Confluence, reducing asset loss by 40%.
Solution
Created an Airtable base with tables for Users, Locations, and Equipment. Custom views for checkout, maintenance, and disposal statuses.
Integration
Automated updates via Airtable Scripts: when equipment status changes, send a webhook to Confluence to update the embedded table view.
Dashboard
Built a Grafana data source plugin for Airtable to visualise asset age, location distribution, and audit outcomes.
Results
Reduced lost-asset incidents by 40%. Real-time visibility cut the monthly audit process from 3 days to 4 hours.
Technologies
Airtable API • JavaScript (Scripts) • Confluence REST API • Grafana
Interested in Similar Solutions?
Let's discuss how I can help optimize your infrastructure