A tidy list of every client for any service business — contact details, visits, spend and how long since you last saw them.
Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.
Category
Tables
Clients
Fields
16
Views
grid, kanban, form
The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.
16 fields · 5 sample rows
| ClientText | PhonePhone | EmailEmail | AddressAddress | TypeSingle select | StatusSingle select | Preferred contactSingle select | Client sinceDate | BirthdayDate | Visits / jobsNumber | Total spentCurrency | Average spendFormula | Last visitDate | Days since last visitFormula | Referred byText | NotesLong text |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sunita Kulkarni | +91 98220 10101 | [email protected] | Individual | VIP | 14 Jun 2021 | 9 Mar 1984 | 18 | ₹1,42,000 | ₹7,889 | 10 Nov 2026 | 9 | ||||
| Horizon Offices LLP | +91 20 6655 4400 | [email protected] | Business | Active | 20 Jan 2023 | 6 | ₹4,86,000 | ₹81,000 | 15 Oct 2026 | 35 | |||||
| David Thompson | +44 7700 900456 | [email protected] | Individual | Active | 2 Sep 2024 | 3 | ₹21,000 | ₹7,000 | 10 Sep 2026 | 70 | Sunita Kulkarni | ||||
| Farhan Ali | +91 99300 20202 | Individual | Inactive | Phone | 11 Nov 2020 | 4 | ₹18,500 | ₹4,625 | 15 Oct 2025 | 400 | |||||
| Green Basket Organics | +91 80 4123 9900 | [email protected] | Business | Active | Phone | 5 May 2025 | 2 | ₹96,000 | ₹48,000 | 4 Nov 2026 | 15 |
Form view “New client registration” asks for: Client, Phone, Email, Address, Type, Preferred contact, Birthday, Referred by.
Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.
Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.
Line up subcontractor bids for each work package side by side — price with tax, duration, warranty and score — and award the best one.
2 tables · 24 fieldsBid Tabulation TemplateA classic bid tab: each BOQ line priced by three bidders against the engineer’s estimate, with extended totals and the lowest bidder per line.
1 table · 15 fieldsBill of Materials TemplateEvery component needed for a build with quantity, unit cost, extended cost and order status, tied to suppliers and their lead times.
2 tables · 23 fieldsConstruction Budget TemplateCost-code budget for a build: original budget plus change orders, committed and actual cost from invoices, and overrun warnings per line.
2 tables · 21 fieldsConstruction ChecklistPhase-by-phase site checklist from pre-construction to handover, with owners, due dates, required inspections and photo proof.
1 table · 10 fieldsConstruction CRMTrack clients from first site visit to signed contract, keep a vetted contractor roster with insurance expiry, and schedule every job.
3 tables · 33 fields