Email Subscription List

Run several newsletters from one place: subscribers opt into lists, and each list shows its live subscriber count.

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

Lists

Tables

Newsletters, Subscribers

Fields

16

Views

grid, form, kanban, dashboard

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.

Newsletters

6 fields · 3 sample rows

  • Newsletters (Grid)
NewsletterTextDescriptionLong textFrequencySingle selectOwnerTextSubscribersLink to another tableSubscriber CountCount
Weekly DigestTop stories and product news every Friday.WeeklyMeeraAditi Sharma, Rahul Verma, Deepak Joshi3
Deals & OffersDiscounts and early-bird offers.OccasionalArjunAditi Sharma, Sophie Martin2
Developer NotesAPI changes and release notes.MonthlySamMichael Chen, Deepak Joshi2
Field details
Newsletter · Text
Description · Long text
Frequency · Single select
Daily, Weekly, Monthly, Occasional
Owner · Text
Subscribers · Link to another table
Links to Subscribers
Subscriber Count · Count

Subscribers

10 fields · 5 sample rows

  • All subscribers (Grid)
  • Subscribe (Form)
  • By status (Kanban)
  • Growth (Dashboard)
NameTextEmailEmailNewslettersLink to another tablePlanSingle selectStatusSingle selectConfirmed (double opt-in)CheckboxSubscribed OnDateUnsubscribed OnDateUnsubscribe ReasonSingle selectDays SubscribedFormula
Aditi Sharma[email protected]Weekly Digest, Deals & OffersPaidActiveYes23 Apr 2026210
Michael Chen[email protected]Developer NotesFreeActiveYes21 Aug 202690
Rahul Verma[email protected]Weekly DigestFreeAwaiting confirmation18 Nov 20261
Sophie Martin[email protected]Deals & OffersFreeUnsubscribedYes22 Jun 202630 Oct 2026Too many emails130
Deepak Joshi[email protected]Weekly Digest, Developer NotesPaidActiveYes15 Oct 2025400
Field details
Name · Text
Email · Email
Newsletters · Link to another table
Links to Newsletters
Plan · Single select
Free, Paid
Status · Single select
Active, Awaiting confirmation, Unsubscribed, Bounced
Confirmed (double opt-in) · Checkbox
Subscribed On · Date
Unsubscribed On · Date
Unsubscribe Reason · Single select
Too many emails, Not relevant, Never signed up, Other
Days Subscribed · Formula
IF({Subscribed On}, DATETIME_DIFF(IF({Unsubscribed On}, {Unsubscribed On}, TODAY()), {Subscribed On}, 'days'), BLANK())

Form view “Subscribe” asks for: Name, Email, Newsletters.

Email Subscription List: 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