Intake & Qualification Engine
Categories
Business Continuity
Business Operations
Level
Beginner

The Intake & Qualification Engine is designed for professional services firms—such as agencies, consultancies, and SaaS providers—that need to move beyond static lead capture. In high-ticket environments, sales fatigue often sets in when teams must manually filter through low-quality inquiries. This template solves that by transforming a standard form into a real-time “Form-to-Action” system that scores and routes leads the moment they arrive.

Using Baserow’s relational logic and formulas, the template automatically calculates a Lead Score and Priority Level based on fit criteria like budget and company size. This ensures your sales team knows exactly who to call first. By linking submissions to a Service Catalog and a Team directory, the engine provides a transparent “Source to Closed” journey, tracking which campaigns are driving the most value.

The database acts as a Sales Command Center. Reps can manage their workload through a Capacity Kanban, while managers monitor Team Performance and Campaign ROI through automated rollups. With integrated Interaction Logs, every touchpoint—from the first demo to the final note—is documented, reducing data silos and accelerating follow-up times.

Database: Dynamic Intake & Qualification Engine

Submissions

Fields

  • Full Name (Text)

  • Submission ID (Formula)

  • Email (Email)

  • Company Size (Single select)

  • Budget Range (Single select)

  • Inquiry Details (Long text)

  • Status (Single select)

  • Service Interest (Link to table)

  • Assigned Rep (Link to table)

  • Campaign Source (Link to table)

  • Lead Score (Formula)

  • Priority Level (Formula)

  • Interaction Logs (Link to table)

  • Created On (Created on)

  • Budget Value (Number)

Views

  • Lead Intake Form (form)

  • All Submissions (grid)

  • High Priority Queue (grid)

  • Inbox: New Leads (grid)

  • Status Kanban (kanban)

  • Submissions by Date (calendar)

Service Catalog

Fields

  • Service Name (Text)

  • Base Price (Number)

  • Active (Boolean)

  • Leads Interested (Link to table)

  • Total Pipeline Value (Formula)

  • Last modified (Last modified)

Views

  • Service Catalog (grid)

  • Service Performance (grid)

  • Active Services (grid)

  • Service Archive (grid)

  • Add Service Form (form)

  • Pricing Gallery (gallery)

Team

Fields

  • Name (Text)

  • Role (Single select)

  • Workload Limit (Number)

  • My Leads (Link to table)

  • Interaction Logs (Link to table)

  • Load % (Formula)

  • Current Load (Count) (Formula)

  • Profile Photo (File)

  • Email (Email)

  • Phone number (Phone number)

  • Status (Single select)

  • Password (Password)

  • Campaigns (Link to table)

Views

  • Team Overview (grid)

  • Rep Performance (grid)

  • Assigner View (grid)

  • Create Your Team Profile (form)

  • Capacity Kanban (kanban)

  • Team Gallery (gallery)

Campaigns

Fields

  • Campaign Name (Text)

  • Channel (Single select)

  • Generated Leads (Link to table)

  • Start Date (Date)

  • End Date (Date)

  • Conversion Count (Count) (Formula)

  • Assets (File)

  • Led By (Link to table)

  • Last modified (Last modified)

Views

  • All Campaigns (grid)

  • Active Campaigns (grid)

  • Channel Performance (grid)

  • Campaign ROI (grid)

  • Archived Campaigns (grid)

  • Campaign Timeline (timeline)

  • New Campaign (form)

Interaction Logs

Fields

  • Date (Created on)

  • Type (Single select)

  • Summary (Long text)

  • Related Lead (Link to table)

  • Recorded By (Link to table)

  • Lead Name (Lookup)

  • Last modified (Last modified)

Views

  • All Interactions (grid)

  • Recent Activities (grid)

  • Interaction History (grid)

  • New Interaction (form)

  • Calls Today (calendar)

  • Demo Schedule (calendar)

Application: Intake & Team Portal

shared

Data sources

  • Get member detail

Actions (event)

  • logout (2031c436-9074-479f-ba0a-a8301be4a234_click)

Team Login

Data sources

Actions (event)

  • open_page (after_login)

  • notification (after_login)

  • refresh_data_source (after_login)

Dashboard

Data sources

  • My leads

  • My logs

  • All campaigns

  • All services

Actions (event)

  • open_page (37653b88-f1b7-42fd-b9ab-2a60a81925a1_click)

  • open_page (a42e5525-5557-48e8-bde7-cc6d7c4e2f7d_click)

  • open_page (eaa59978-33fa-4ceb-960e-b745aaa0e6c5_click)

Update Log

Data sources

  • My interactions

  • Get log

Actions (event)

  • open_page (submit)

  • notification (submit)

  • update_row (submit)

Update Campaign

Data sources

  • My campaigns

  • Get campaign

Actions (event)

  • open_page (submit)

  • notification (submit)

  • update_row (submit)

Update Service

Data sources

  • Services

  • Get Service

Actions (event)

  • open_page (submit)

  • notification (submit)

  • update_row (submit)