Customer Info Sheet

Keep one clean record per customer — contact details, segment, preferences and consent — collected through a form.

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

Marketing

Tables

Customers

Fields

15

Views

grid, kanban, form, dashboard

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.

Customers

15 fields · 6 sample rows

  • All customers (Grid)
  • By segment (Kanban)
  • Customer information form (Form)
  • Customer overview (Dashboard)
Full NameTextCustomer IDAutonumberCompanyTextEmailEmailPhonePhoneAddressAddressSegmentSingle selectCustomer SinceDateBirthdayDatePreferred ContactSingle selectInterestsMultiple selectLifetime ValueCurrencyMarketing ConsentCheckboxYears as CustomerFormulaNotesLong text
Ananya SharmaCUST-0001Bloom Interiors[email protected]+91 98200 4551214 Carter Road, Mumbai, Maharashtra, 400050, IndiaVIP19 Jan 202312 Mar 1988WhatsAppNew arrivals, Events₹3,85,000Yes3.8
Robert FischerCUST-0002[email protected]+49 30 5550 1234Torstraße 88, Berlin, 10119, GermanyRegular29 Mar 2025EmailNewsletter₹92,000Yes1.6
Kiran PatelCUST-0003Patel Traders[email protected]+91 79 2655 9087CG Road, Ahmedabad, Gujarat, IndiaAt risk2 Jun 2024PhoneDiscounts₹61,0002.5No order in 5 months — call with loyalty offer.
Mei Lin TanCUST-0004[email protected]+65 8123 4567Singapore, SingaporeNew30 Oct 2026EmailNew arrivals, Loyalty programme₹8,500Yes0.1
Arvind KrishnanCUST-0005[email protected]+91 94440 11882Chennai, Tamil Nadu, IndiaRegular15 Nov 202330 Nov 1979SMSDiscounts, Events₹1,43,000Yes3
Sarah O’ConnorCUST-0006Greenleaf Café[email protected]+353 1 555 0199Dublin, IrelandLapsed15 Dec 2021Email₹47,0004.9
Field details
Full Name · Text
Customer ID · Autonumber
Company · Text
Email · Email
Phone · Phone
Address · Address
Segment · Single select
VIP, Regular, New, At risk, Lapsed
Customer Since · Date
Birthday · Date
Preferred Contact · Single select
Email, Phone, WhatsApp, SMS
Interests · Multiple select
New arrivals, Discounts, Events, Newsletter, Loyalty programme
Lifetime Value · Currency
INR
Marketing Consent · Checkbox
Years as Customer · Formula
IF({Customer Since}, ROUND(DATETIME_DIFF(TODAY(), {Customer Since}, 'days') / 365, 1), BLANK())
Notes · Long text

Form view “Customer information” asks for: Full Name, Company, Email, Phone, Address, Birthday, Preferred Contact, Interests, Marketing Consent.

Customer Info Sheet: 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