(Companion to TalentQuote UX/UI Flow v2.6)
⸻
🏠 Base Overview
Each workspace represents one layer of the TalentQuote workflow:
1️⃣ Roles → client requests and open positions 2️⃣ Candidates → all talent profiles 3️⃣ Shortlists → role-to-candidate matches 4️⃣ Feedback → client feedback loop 5️⃣ Bench / Reuse Pool → reusable or ending-talent profiles 6️⃣ Reports & Analytics → KPIs and dashboards
All are synchronized via n8n with Supabase and Metabase.
⸻
1️⃣ Roles Table
🎯 Purpose: manage all open client roles with SLA tracking (48 h delivery).
Key Fields • 🆔 Role ID (auto) • 🏢 Client Name (linked) • 💼 Role Title (dropdown) • 🧩 Tech Stack (multi-select: React / QA / DevOps / etc.) • 💲 Budget Range (numeric or range: 8 000) • 📅 Created Date • ⏱️ SLA Countdown (formula: 48 h – elapsed) • 👤 Assigned Recruiter (single select) • 📊 Status (dropdown: Open / Shortlist Sent / Hired / Closed) • 🔗 Shortlist Link (auto-generated from n8n)
Views • 👀 “All Active Roles” → filters Open + SLA ≤ 48 h • ⚡ “Overdue SLA” → red flag if SLA expired • 📈 “Client Summary” → grouped by client
Automation • ⏰ Trigger: SLA < 6 h → Slack alert + email recruiter • 🔄 When Status = “Hired” → auto create Bench record for engineer
⸻
2️⃣ Candidates Table
🎯 Purpose: unified database for all engineers.
Key Fields • 🆔 Candidate ID • 👤 Full Name • 🌎 Location / Timezone • 📧 Email (hidden) • 🗣️ English Level (dropdown: A2 → C2) • 💻 Tech Stack (multi-select) • 💡 Seniority (dropdown: Mid / Senior / Lead) • 🎥 Video Link (HeyGen / Synthesia) • 🧠 Psychometric Scores (Empathy / Clarity / Reliability) • ⭐ TalentScore (numeric 0–100) • ⚙️ Availability (🟢 Now / 🕓 Ending Soon / ⏳ Notify Me) • 📅 Contract End Date (if active) • 📄 CV File (attachment) • 💬 Notes (long text)
Views • 🔍 “Available Now” • 🕓 “Ending Soon” • 🚀 “Top 10 % TalentScore” • ❌ “Rejected but Qualified” (for AIcodex feedback)
Automation • 📬 When Availability = “Now” → push to Supabase + client cards • 🔁 When contract ends → set to “Available Now” + Slack alert • 🧠 When feedback added → recalculates TalentScore (via n8n)
⸻
3️⃣ Shortlists Table
🎯 Purpose: track role-to-candidate pairings and feedback.
Key Fields • 🔗 Role (linked to Roles) • 👤 Candidate (linked to Candidates) • 📅 Shortlist Date • 🎥 Video Shown (checkbox) • 🧠 Match % (auto-calculated from GPT) • 👍 / 👎 Client Feedback (linked) • 💬 Feedback Reason (dropdown: Communication / Experience / Fit) • 🟢 Status (dropdown: Interview / Offer / Hired / Rejected)
Views • ⚡ “Pending Interviews” • 🎯 “Client Feedback Needed” • 💼 “Completed Shortlists”
Automation • 🔄 When client gives feedback → update Candidate TalentScore • 📬 When Status = “Hired” → auto-generate SOW in DocuSign
⸻
4️⃣ Feedback Table
🎯 Purpose: collect structured feedback from clients and internal QA.
Key Fields • 🏢 Client • 🔗 Role • 👤 Candidate • 🎯 Feedback Type (Interview / Post-Onboarding / Renewal) • 💬 Feedback Text • 👍 / 👎 Rating • 🧠 Cluster Tag (auto GPT: Communication / Skills / Culture)
Automation • 🧠 Feedback clusters → retrain AI match weights • 📬 Rejected but positive → send to AIcodex for skill training suggestion
⸻
5️⃣ Bench / Reuse Pool Table
🎯 Purpose: maintain “always available” talent for Instant Match.
Key Fields • 👤 Candidate (linked) • 📅 Availability Start • 💡 Priority (dropdown: ⭐ Top Performer / 🧩 Good Fit / 🕓 Update Soon) • 🔁 Last Updated (auto) • 🧠 Notes from Recruiter • 🔗 Visible in Client UI (checkbox for automation)
Views • 🟢 “Available Now” • 🕓 “Ending Soon” • 🧩 “To Update Skills”
Automation • ⏰ If “Last Updated” > 30 days → send notification to recruiter • 🔄 When Availability changes → push to Supabase (instant display in UI)
⸻
6️⃣ Reports & Analytics Table
🎯 Purpose: centralized KPI dashboard (feeds Metabase).
Key Metrics • ⏱️ Time-to-Hire (avg. days) • 📈 MSA-to-Hire Conversion % • 🔁 Reuse Rate % • 🧠 Avg TalentScore • 📊 Recruiter SLA Compliance % • 💰 ARR by Client
Automation • 🧮 n8n sync to Metabase every 6 h • 📬 Weekly summary to management via email or Slack
⸻
🧠 Automation Hooks (n8n + Airtable)
⚙️ Triggers • New role created → recruiter assigned → Slack ping • Candidate set to “Available” → update Supabase → notify Client UI • Client feedback added → GPT recalculates TalentScore → Supabase sync • Contract end → Bench record auto-created
⸻
🧩 Recruiter Dashboard (Interface Designer Layer)
For a polished internal UX, Airtable’s Interface Designer can include:
1️⃣ Home Page • “My Active Roles” table • “Candidates Pending Review” • SLA countdown widgets
2️⃣ Candidate Detail Page • Video player embed • Psychometric radar chart • “Mark as Available” button
3️⃣ Bench Overview • Kanban by Availability • One-click “Send to Client UI” toggle
4️⃣ Reports Page • Live graphs (reuse %, churn %, conversion %)
💡 Tip: even if internal, the recruiter experience should feel like a SaaS dashboard — clear hierarchy, real-time indicators, and minimal friction.