Class List Template

Register students into classes, see enrolment against capacity per class, and keep guardian details and comments together.

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

Classes, Students

Fields

18

Views

grid, form

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.

Classes

9 fields · 4 sample rows

  • Classes (Grid)
ClassTextSubjectSingle selectTeacherTextRoomTextScheduleTextCapacityNumberStudentsLink to another tableEnrolledCountSeats leftFormula
Algebra I – Section AMathematicsMr. KrishnanB-204Mon/Wed/Fri 9:0030Aanya Saxena, Ethan Clarke, Vihaan Patel327
Biology – Section AScienceDr. AllenLab 2Tue/Thu 10:3024Aanya Saxena, Mohammed Faizal, Vihaan Patel321
Creative WritingEnglishMs. D'SouzaA-110Wed 14:0018Aanya Saxena, Isabella Rossi216
Intro to PythonComputer ScienceMr. AhmedComputer labFri 13:0020Ethan Clarke, Mohammed Faizal, Vihaan Patel317
Field details
Class · Text
Subject · Single select
Mathematics, Science, English, Music, Computer Science
Teacher · Text
Room · Text
Schedule · Text
Capacity · Number
Students · Link to another table
Links to Students
Enrolled · Count
Seats left · Formula
IF({Capacity}, {Capacity} - {Enrolled}, BLANK())

Students

9 fields · 5 sample rows

  • Roster (Grid)
  • Register for classes (Form)
StudentTextStudent noAutonumberGradeSingle selectClassesLink to another tableClasses takenCountGuardianTextGuardian phonePhoneEmailEmailCommentsLong text
Aanya SaxenaSTU-0001Grade 9Algebra I – Section A, Biology – Section A, Creative Writing3Neeraj Saxena+91 98111 22334[email protected]
Ethan ClarkeSTU-0002Grade 9Algebra I – Section A, Intro to Python2Sarah Clarke+44 7700 900456[email protected]
Mohammed FaizalSTU-0003Grade 10Biology – Section A, Intro to Python2Faizal Rahman+971 50 123 4567[email protected]Needs front-row seating (vision).
Isabella RossiSTU-0004Grade 10Creative Writing1Marco Rossi+39 333 123 4567[email protected]
Vihaan PatelSTU-0005Grade 11Algebra I – Section A, Intro to Python, Biology – Section A3Kiran Patel+91 99099 88776[email protected]
Field details
Student · Text
Student no · Autonumber
Grade · Single select
Grade 9, Grade 10, Grade 11
Classes · Link to another table
Links to Classes
Classes taken · Count
Guardian · Text
Guardian phone · Phone
Email · Email
Comments · Long text

Form view “Class registration” asks for: Student, Grade, Classes, Guardian, Guardian phone, Email, Comments.

Class 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