Demo: Atelier Lumen
A small agency, its clients, projects, tasks, invoices and reviews: every facet of basedb in a single base.
The demo base. Atelier Lumen is a fictional design agency. Its base shows relations between tables, lookups and rollups (revenue per client, average rating), formulas (amount including tax, delay), three AI-computed fields on customer reviews (sentiment, topic, suggested reply), every kind of view — grid, kanban, calendar, timeline with dependencies, gallery, list, form —, a dashboard and two automations.
5 tables
Clients 6 sample rows
The organizations the agency works with, prospects included. One row per client.
- Name Short text
- Industry Single select
- Status Single select
- City Short text
- Email Email
- Website URL
- Projects Count
- Revenue Rollup
- Average rating Rollup
- Send email Button
| Name | Industry | Status | City | |
|---|---|---|---|---|
| Martin's Bakery | Retail | Active | Portland | contact@martins-bakery.example |
| Linden Clinic | Healthcare | Active | Charleston | communication@lindenclinic.example |
| Lincoln High School | Education | Active | Denver | office@lincolnhigh.example |
Projects 6 sample rows
The agency's engagements, from idea to delivery. A project has a client and tasks.
- Name Short text
- Status Single select
- Start Date
- End Date
- Budget Number
- Duration (days) Formula
- Client's city Lookup
- Tasks Count
- Brief Rich text
- Client → Clients
| Name | Status | Start | End | Budget |
|---|---|---|---|---|
| Showcase website and online ordering | In progress | 9/19/2026 | 11/3/2026 | €12,500.00 |
| New brand identity | In progress | 9/29/2026 | 11/18/2026 | €18,000.00 |
| Open house campaign | Delivered | 7/11/2026 | 9/9/2026 | €6,400.00 |
Tasks 13 sample rows
The work to do, project by project. A task can depend on other tasks.
- Title Short text
- Status Single select
- Priority Single select
- Start Date
- Due date Date
- Assigned to Person
- Estimate (h) Number
- Notes Long text
- Completed on Date and time
- Project → Projects
- Depends on → Tasks
| Title | Status | Priority | Start | Due date |
|---|---|---|---|---|
| Kickoff workshop with the bakery | Done | High | 9/19/2026 | 9/21/2026 |
| Homepage mockups | In review | High | 9/24/2026 | 10/7/2026 |
| Checkout flow integration | In progress | High | 10/6/2026 | 10/17/2026 |
Invoices 7 sample rows
The invoices issued. An invoice targets a client, and often a project.
- Number Short text
- Issued on Date
- Amount excl. tax Number
- Tax rate Number
- Amount incl. tax Formula
- Due date Date
- Paid Checkbox
- Overdue Formula
- Client → Clients
- Project → Projects
| Number | Issued on | Amount excl. tax | Tax rate | Amount incl. tax |
|---|---|---|---|---|
| F-2026-001 | 4/2/2026 | €11,000.00 | 0.2 | |
| F-2026-002 | 6/11/2026 | €11,000.00 | 0.2 | |
| F-2026-003 | 7/16/2026 | €3,200.00 | 0.2 |
Customer reviews 5 sample rows
What clients say about the work delivered. AI reads each review: sentiment, topic and a suggested reply.
- Author Short text
- Review Long text
- Rating Number
- Received on Date
- ✦ Sentiment Single select
- ✦ Topic Single select
- ✦ Suggested reply Long text
- Client → Clients
| Author | Review | Rating | Received on | Sentiment |
|---|---|---|---|---|
| Claire, Lincoln High School | The campaign was delivered right on time, and the visuals were a real hit with families. We had 30% more visitors at the open house! | 5 | 9/11/2026 | Positive |
| Marketing team, Cascade Ironworks | Beautiful catalog, but printing was two weeks late and we had to follow up several times to get the final files. | 3 | 6/16/2026 | Neutral |
| Jordan, Community Bikes | Attentive team and a very fair price for a nonprofit. Can't wait to see the finished app. | 5 | 9/27/2026 | Positive |
What the AI computes
- Customer reviews › Sentiment
Here is a client's review of a design agency, rated {{Rating}}/5: "{{Review}}" What is the overall sentiment of this review?
- Customer reviews › Topic
What is this customer review mainly about? "{{Review}}"
- Customer reviews › Suggested reply
Write a warm and professional reply to this customer review, rated {{Rating}}/5, in three sentences at most. Thank the customer, address their comments precisely, and sign "The Lumen Studio team". Review from {{Author}}: "{{Review}}"