Client Database Template

A clean client register with every call, email and meeting logged against it, so you always know who is due a follow-up.

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

CRM

Tables

Clients, Interactions

Fields

23

Views

grid, kanban, form, calendar

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Clients

16 fields · 5 sample rows

  • All clients (Grid)
  • By status (Kanban)
  • New client intake (Form)
ClientTextCompanyTextEmailEmailPhonePhoneAddressAddressIndustrySingle selectStatusSingle selectSourceSingle selectClient sinceDateLifetime valueCurrencyAccount managerTextInteractionsLink to another tableTouchpointsCountLast contactRollupDays since contactFormulaTagsMultiple select
Meera NairLotus Wellness Clinics[email protected]+91 98450 12121HealthcareActiveReferral10 Apr 2023₹8,40,000ArjunQuarterly review113 Nov 20266VIP
James WhitfieldWhitfield & Co. Accountants[email protected]+44 20 7946 0321Professional servicesActiveLinkedIn2 Aug 2024₹3,20,000SaraRenewal reminder17 Nov 202612Upsell
Rakesh GuptaGupta Textiles[email protected]+91 98110 45454ManufacturingDormantTrade show20 Nov 2021₹12,50,000ArjunCheck-in call12 Oct 202648At risk
Aisha RahmanBrightPath Academy[email protected]+971 50 555 0187EducationLeadWebsiteSaraDemo request117 Nov 20262
Kunal ShahUrban Brew Cafés[email protected]+91 99876 54321HospitalityActiveInstagram14 Feb 2025₹2,10,000ArjunMenu launch support130 Oct 202620Referral partner
Field details
Client · Text
Company · Text
Email · Email
Phone · Phone
Address · Address
Industry · Single select
Retail, Healthcare, Education, Manufacturing, Technology, Hospitality, Professional services
Status · Single select
Lead, Active, Dormant, Churned
Source · Single select
Website, Referral, Instagram, LinkedIn, Google Ads, Walk-in, Trade show, Cold outreach
Client since · Date
Lifetime value · Currency
INR
Account manager · Text
Interactions · Link to another table
Links to Interactions
Touchpoints · Count
Last contact · Rollup
latest of Date via Interactions
Days since contact · Formula
IF({Last contact}, DATETIME_DIFF(TODAY(), {Last contact}, 'days'), BLANK())
Tags · Multiple select
VIP, Upsell, At risk, Referral partner

Form view “New client intake” asks for: Client, Company, Email, Phone, Address, Industry, Source.

Interactions

7 fields · 5 sample rows

  • Activity log (Grid)
  • Follow-ups (Calendar)
SummaryTextClientLink to another tableTypeSingle selectDateDateOutcomeSingle selectNext stepTextFollow-up onDate
Quarterly reviewMeera NairMeeting13 Nov 2026PositiveSend proposal for two new branches22 Nov 2026
Renewal reminderJames WhitfieldEmail7 Nov 2026NeutralCall to discuss premium tier20 Nov 2026
Check-in callRakesh GuptaCall2 Oct 2026Needs attentionOffer loyalty discount
Demo requestAisha RahmanWhatsApp17 Nov 2026PositiveBook demo21 Nov 2026
Menu launch supportKunal ShahSite visit30 Oct 2026Positive
Field details
Summary · Text
Client · Link to another table
Links to Clients
Type · Single select
Call, Email, Meeting, WhatsApp, Site visit
Date · Date
Outcome · Single select
Positive, Neutral, Needs attention
Next step · Text
Follow-up on · Date

Client Database 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