# LinkSelectRollupFormula

# Airtable app builder, powered by AI.

Your Airtable bases are brilliant — the schema, the relations, the automations. Now imagine a real app on top of all of it. Dashboards, portals, trackers — describe what you want and ship it.

---

## Projects

### Project Tracker

| Name               | Status      | Owner     | Due    | Priority |
|--------------------|-------------|-----------|--------|----------|
| Brand Redesign     | In Progress | Sarah K.  | Mar 28 | High     |
| API Integration     | Done       | Miguel S. | Mar 14 | Medium   |
| User Research       | Not Started | Emily R.  | Apr 05 | High     |
| Launch Campaign     | In Progress | Jake T.   | Apr 12 | Low      |

### Project Stats

12 Active  
7 Done  
3 At Risk

### Status Breakdown

- Done  
- In Progress  
- Not Started

### Airtable views have a ceiling

Grid, Kanban, Gallery — they're great for quick overviews. But when you need a real application, you hit the wall.

#### Grid View
- No custom layouts or grouping logic  
- Can't embed charts or metrics  
- No row-level permissions

#### Kanban View
- Single group-by field only  
- No swimlanes or nested boards  
- Limited card customization

#### Gallery View
- Fixed card layout — can't rearrange  
- No click-through detail pages  
- Can't add actions or forms

### What you actually want

A custom app — with real charts, row-level permissions, public sharing, multi-base joins, and scheduled automations — built in minutes from plain English. That's camelAI.

- Custom Charts  
- Public URLs  
- Cron Jobs  
- Multi-Base  
- AI Insights

## Your schema. Our canvas.

camelAI reads your base structure — tables, fields, linked records, rollups — and uses it as the blueprint for your app.

### Schema Overview

- **Projects** (6 fields)
  - Name (Text)
  - Status (Select)
  - Tasks (Link)
  - Client (Link)
  - Deadline (Date)
  - Budget (Currency)

- **Tasks** (5 fields)
  - Title (Text)
  - Project (Link)
  - Assignee (Link)
  - Priority (Select)
  - Hours (Number)

- **People** (4 fields)
  - Name (Text)
  - Email (Email)
  - Role (Select)
  - Tasks (Link)

- **Clients** (4 fields)
  - Company (Text)
  - Projects (Link)
  - Revenue (Rollup)
  - Status (Select)

### camelAI auto-discovers your schema. Just connect and describe what you want.

## Interface Designer vs camelAI

Airtable's Interface Designer is fine for simple views. But when you need a real application — with custom logic, charts, and public access — you need something more.

### Interface Comparison

| Feature                        | Interface Designer               | camelAI                  |
|--------------------------------|----------------------------------|--------------------------|
| Pre-built elements only        | Yes                              | No                       |
| Custom charts or visualizations | No                               | Yes                      |
| Single-base data only          | Yes                              | No                       |
| Public sharing                 | Paid plan only                   | Free custom URL          |
| Scheduled automations          | Limited                          | Full cron scheduling     |

## Built from bases like yours

These are real apps you can build in a single conversation — all powered by your existing Airtable data.

1. **Inventory Tracker**  
   Real-time stock levels with reorder alerts, barcode lookup, and supplier management.

2. **Event Planning Hub**  
   Timeline views, task dependencies, and team assignments.

3. **Content Calendar**  
   Editorial workflows with status tracking, approval routing, and publishing schedules.

4. **Client Portal**  
   Give clients a polished view of their projects without sharing your base.

## Every field type. First-class.

camelAI understands every Airtable field type — from simple text to linked records and rollups. Your data model stays intact.

- Single Line Text
- Long Text
- Link to Record
- Single Select
- Multiple Select
- Checkbox
- Date
- Number
- Currency
- Percent
- Email
- URL
- Phone
- Attachment
- Rating
- Duration
- Lookup
- Rollup
- Formula
- Count
- Barcode
- Button
- Auto Number
- Created Time

Attachments render as images. Selects become filter dropdowns. Linked records become clickable relationships. Everything just works.

## Questions from Airtable power users

### Does camelAI modify my Airtable data?

### How does it handle linked records and rollups?

### Can I combine data from multiple bases?

### Do I need to know the Airtable API?

### Can I share the app with people who don't use Airtable?

---

## Your bases deserve a real frontend.

Connect Airtable. Describe what you want. Ship it.