Client List Template

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

Construction

Tables

Clients

Fields

16

Views

grid, kanban, form

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Clients

16 fields · 5 sample rows

  • All clients (Grid)
  • By status (Kanban)
  • Client registration (Form)
ClientTextPhonePhoneEmailEmailAddressAddressTypeSingle selectStatusSingle selectPreferred contactSingle selectClient sinceDateBirthdayDateVisits / jobsNumberTotal spentCurrencyAverage spendFormulaLast visitDateDays since last visitFormulaReferred byTextNotesLong text
Sunita Kulkarni+91 98220 10101[email protected]IndividualVIPWhatsApp14 Jun 20219 Mar 198418₹1,42,000₹7,88910 Nov 20269
Horizon Offices LLP+91 20 6655 4400[email protected]BusinessActiveEmail20 Jan 20236₹4,86,000₹81,00015 Oct 202635
David Thompson+44 7700 900456[email protected]IndividualActiveEmail2 Sep 20243₹21,000₹7,00010 Sep 202670Sunita Kulkarni
Farhan Ali+91 99300 20202IndividualInactivePhone11 Nov 20204₹18,500₹4,62515 Oct 2025400
Green Basket Organics+91 80 4123 9900[email protected]BusinessActivePhone5 May 20252₹96,000₹48,0004 Nov 202615
Field details
Client · Text
Phone · Phone
Email · Email
Address · Address
Type · Single select
Individual, Business
Status · Single select
Active, VIP, Inactive
Preferred contact · Single select
Phone, WhatsApp, Email, SMS
Client since · Date
Birthday · Date
Visits / jobs · Number
Total spent · Currency
INR
Average spend · Formula
IF({Visits / jobs}, ROUND({Total spent} / {Visits / jobs}, 0), BLANK())
Last visit · Date
Days since last visit · Formula
IF({Last visit}, DATETIME_DIFF(TODAY(), {Last visit}, 'days'), BLANK())
Referred by · Text
Notes · Long text

Form view “New client registration” asks for: Client, Phone, Email, Address, Type, Preferred contact, Birthday, Referred by.

Client List Template: questions

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.

Related templates