← All templates
A
Demo

Demo: Atelier Lumen

A small agency, its clients, projects, tasks, invoices and reviews: every facet of basedb in a single base.

AIRelationsAll viewsDashboard

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
NameIndustryStatusCityEmail
Martin's BakeryRetailActivePortlandcontact@martins-bakery.example
Linden ClinicHealthcareActiveCharlestoncommunication@lindenclinic.example
Lincoln High SchoolEducationActiveDenveroffice@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
NameStatusStartEndBudget
Showcase website and online orderingIn progress9/19/202611/3/2026€12,500.00
New brand identityIn progress9/29/202611/18/2026€18,000.00
Open house campaignDelivered7/11/20269/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
TitleStatusPriorityStartDue date
Kickoff workshop with the bakeryDoneHigh9/19/20269/21/2026
Homepage mockupsIn reviewHigh9/24/202610/7/2026
Checkout flow integrationIn progressHigh10/6/202610/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
NumberIssued onAmount excl. taxTax rateAmount incl. tax
F-2026-0014/2/2026€11,000.000.2
F-2026-0026/11/2026€11,000.000.2
F-2026-0037/16/2026€3,200.000.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
AuthorReviewRatingReceived onSentiment
Claire, Lincoln High SchoolThe campaign was delivered right on time, and the visuals were a real hit with families. We had 30% more visitors at the open house!59/11/2026Positive
Marketing team, Cascade IronworksBeautiful catalog, but printing was two weeks late and we had to follow up several times to get the final files.36/16/2026Neutral
Jordan, Community BikesAttentive team and a very fair price for a nonprofit. Can't wait to see the finished app.59/27/2026Positive

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}}"