Example Table Structures for Common Use Cases
AI Tables are completely flexible — you can adapt them to almost any business process.
This article shows real examples of how different teams use tables across industries, so you can model your own structures easily.
Each example includes suggested fields, common relations, and screenshots for inspiration.
Leads and CRM
Track your potential customers and manage your sales process inside Frontline.
This is one of the most common use cases for AI Tables.
Suggested tables:
Leads – to store contact details and initial interactions.
Customers – to convert leads once they become active clients.
Deals – to manage negotiations or sales opportunities.
Key fields:
Name
Email
Phone
Company
Status (New, Contacted, Converted)
Source (Form, Chat, WhatsApp)
Sentiment (Auto-generated by AI)
📸 Screenshot of a Leads table showing contacts, status, and sentiment fields auto-filled by AI
You can use workflows to automatically assign leads or notify your team when a new contact is created.
Support Tickets
Manage internal or customer requests directly through AI Tables.
Each ticket can be tracked, prioritized, and resolved automatically through workflows or agents.
Suggested tables:
Tickets – for the issues themselves.
Users – for the customers or employees who report them.
Agents – for the support team members.
Key fields:
Title
Description
Priority (Low, Medium, High)
Status (Open, In Progress, Resolved)
Assigned To (Relation → Agents)
Date Created / Date Resolved
📸 Screenshot of a Support Tickets table with AI auto-classifying priority and assigning agents
Agents can update the table automatically when a ticket is resolved or needs escalation.
Real Estate Management
If you manage property listings, you can use AI Tables to centralize all data and feed your AI real estate assistant.
Suggested tables:
Properties – all real estate listings.
Clients – potential buyers or renters.
Visits – records of property showings.
Key fields (Properties table):
Title
Location (City, Country)
Type (Apartment, House, Office)
Price
Bedrooms / Bathrooms
Image URL
Status (Available, Sold, Reserved)
📸 Screenshot of a Real Estate Properties table with images, prices, and availability fields
Workflows can notify clients automatically when a property that matches their criteria becomes available.
HR and Recruitment
AI Tables can also be used to manage candidates, interviews, and hiring processes.
You can create a mini Applicant Tracking System (ATS) inside Frontline.
Suggested tables:
Candidates – people applying for roles.
Positions – open job listings.
Interviews – records of scheduled interviews.
Key fields (Candidates table):
Name
Email
Phone
Applied Position (Relation → Positions)
Stage (Screening, Interview, Hired)
Interview Date
Recruiter
Notes (AI-generated summaries)
📸 Screenshot of a Candidates table tracking recruitment stages and interview outcomes
Workflows can trigger interview reminders or send automated messages when a candidate moves to a new stage.
Orders and Invoices
If your team handles purchases or transactions, AI Tables can be used to track orders and billing automatically.
Suggested tables:
Orders – purchase details.
Customers – buyer information.
Invoices – billing and payment tracking.
Key fields (Orders table):
Order ID
Customer (Relation → Customers)
Date
Total Amount
Payment Status (Pending, Paid)
Delivery Date
📸 Screenshot of an Orders table connected to Customers and Invoices tables
When an order is marked as “Paid,” a workflow can automatically create or update an invoice.
Inventory and Product Catalogs
Keep product information updated and accessible for your AI agents or commerce workflows.
Suggested tables:
Products – your main catalog.
Stock – quantity and location.
Categories – types of products.
Key fields (Products table):
Name
SKU
Description
Category (Relation → Categories)
Price
Stock (Relation → Stock)
Image URL
📸 Screenshot of a Products table with name, price, category, and image fields
Agents can use this data to answer questions like “What’s the price of product X?” or “Is this item in stock?”
Projects and Work Orders
For teams that manage projects or internal tasks, AI Tables can act as a lightweight project management tool.
Suggested tables:
Projects – main initiatives.
Tasks – individual work items.
Team Members – people responsible for each task.
Key fields (Tasks table):
Title
Assigned To (Relation → Team Members)
Project (Relation → Projects)
Priority (Low, Medium, High)
Due Date
Status (To Do, In Progress, Completed)
📸 Screenshot of a Tasks table showing assignments and progress tracking
Combine this with workflows to automatically notify team members when new tasks are assigned or deadlines change.
Logistics and Operations
AI Tables can help you organize deliveries, vehicles, or logistics operations efficiently.
Suggested tables:
Vehicles – fleet management.
Deliveries – shipments or service routes.
Drivers – team members assigned to vehicles.
Key fields (Deliveries table):
Delivery ID
Vehicle (Relation → Vehicles)
Driver (Relation → Drivers)
Date
Route
Status (Scheduled, In Transit, Delivered)
📸 Screenshot of a Deliveries table with vehicle and driver relations
Workflows can automatically update delivery status and notify customers when a delivery is completed.
Summary
These examples show how AI Tables can fit into any workflow — from CRM and support to real estate or logistics.
Every table can be connected to workflows and agents, allowing you to automate data creation, enrichment, and communication seamlessly.
📸 Screenshot showing multiple tables from different use cases (Leads, Tickets, Properties, Orders) connected in one workspace
Tip:
Start simple. Create one or two tables for your key processes and expand gradually.
AI will help you fill, connect, and automate them — turning your workspace into a single, intelligent data hub.