School CRM

Run admissions like a sales pipeline: capture inquiries, move families from tour to enrolment, and log every 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

Education

Tables

Applicants, Interactions

Fields

25

Views

grid, kanban, calendar, form, 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.

Applicants

18 fields · 6 sample rows

  • All applicants (Grid)
  • Admissions pipeline (Kanban)
  • Follow-ups (Calendar)
  • Admissions inquiry (Form)
  • Admissions dashboard (Dashboard)
ApplicantTextApplying forSingle selectStageSingle selectParent nameTextEmailEmailPhonePhoneAddressAddressLead sourceSingle selectCounsellorTextInquiry dateDateNext follow-upDateAnnual feeCurrencySibling in schoolCheckboxDocumentsAttachmentInteractionsLink to another tableTouchpointsCountLast contactRollupDays in pipelineFormula
Reyansh KapoorGrade 1Campus tourPallavi Kapoor[email protected]+91 98100 12345WebsiteAnjali9 Nov 202621 Nov 2026₹1,85,000Booked Saturday campus tour, Campus tour with both parents216 Nov 202610
Sofia HernándezGrade 6AssessmentLuis Hernández[email protected]+34 612 345 678ReferralRahul25 Oct 202620 Nov 2026₹2,20,000Sent assessment syllabus114 Nov 202625
Myra ChaudharyNurseryInquiryVivek Chaudhary[email protected]+91 99580 67890Social mediaAnjali17 Nov 202619 Nov 2026₹1,45,000First inquiry via Instagram117 Nov 20262
Arnav IyerGrade 9EnrolledLakshmi Iyer[email protected]+91 98840 11223Education fairRahul20 Sep 2026₹2,40,000Yes060
Hannah LeeGrade 11Offer madeGrace Lee[email protected]+65 9123 4567WebsiteAnjali10 Oct 202623 Nov 2026₹2,60,000Offer letter discussed118 Nov 202640
Kunal ThakurGrade 6DeclinedRitu Thakur[email protected]+91 97170 33445Walk-inRahul15 Oct 2026₹2,20,000Chose a school closer to home130 Oct 202635
Field details
Applicant · Text
Applying for · Single select
Nursery, Grade 1, Grade 6, Grade 9, Grade 11
Stage · Single select
Inquiry, Campus tour, Applied, Assessment, Offer made, Enrolled, Declined
Parent name · Text
Email · Email
Phone · Phone
Address · Address
Lead source · Single select
Website, Walk-in, Referral, Social media, Education fair, Newspaper ad
Counsellor · Text
Inquiry date · Date
Next follow-up · Date
Annual fee · Currency
INR
Sibling in school · Checkbox
Documents · Attachment
Interactions · Link to another table
Links to Interactions
Touchpoints · Count
Last contact · Rollup
latest of Date via Interactions
Days in pipeline · Formula
IF({Inquiry date}, DATETIME_DIFF(TODAY(), {Inquiry date}, 'days'), BLANK())

Form view “Admissions inquiry” asks for: Applicant, Applying for, Parent name, Email, Phone, Address, Lead source, Sibling in school, Documents.

Interactions

7 fields · 6 sample rows

  • Activity (Grid)
  • Calendar (Calendar)
SummaryTextApplicantLink to another tableDateDateTypeSingle selectOutcomeSingle selectByTextNotesLong text
Booked Saturday campus tourReyansh Kapoor11 Nov 2026CallPositiveAnjali
Campus tour with both parentsReyansh Kapoor16 Nov 2026Campus tourPositiveAnjaliAsked about bus routes from Indiranagar.
Sent assessment syllabusSofia Hernández14 Nov 2026EmailNeutralRahul
First inquiry via InstagramMyra Chaudhary17 Nov 2026WhatsAppNeeds infoAnjali
Offer letter discussedHannah Lee18 Nov 2026InterviewPositiveAnjali
Chose a school closer to homeKunal Thakur30 Oct 2026CallNot interestedRahul
Field details
Summary · Text
Applicant · Link to another table
Links to Applicants
Date · Date
Type · Single select
Call, Email, WhatsApp, Campus tour, Interview
Outcome · Single select
Positive, Neutral, Needs info, Not interested
By · Text
Notes · Long text

School CRM: 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