Sports Roster Template

Register players across teams and age groups with guardian contacts, medical notes, signed waivers and fee payments per team.

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

Log Sheets

Tables

Teams, Players

Fields

25

Views

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

Teams

9 fields · 3 sample rows

  • Teams (Grid)
TeamTextSportSingle selectAge GroupSingle selectCoachTextCoach PhonePhonePractice DaysMultiple selectPlayersLink to another tableSquad SizeCountFees CollectedRollup
Strikers U14FootballU14Coach Alvarez+91 98860 10010Tue, Thu, SatAditya Rao, Leo Fernandes2₹12,000
Lions U16CricketU16Coach Iyer+91 98450 20020Mon, Wed, SatHarsh Vardhan, Zoya Khan2₹8,000
Hoopers OpenBasketballOpenCoach Daniels+91 99000 30030Fri, SunMarcus Lee, Pranav Menon2₹5,000
Field details
Team · Text
Sport · Single select
Football, Cricket, Basketball, Volleyball, Hockey, Kabaddi
Age Group · Single select
U10, U12, U14, U16, U18, Open
Coach · Text
Coach Phone · Phone
Practice Days · Multiple select
Mon, Tue, Wed, Thu, Fri, Sat, Sun
Players · Link to another table
Links to Players
Squad Size · Count
Fees Collected · Rollup
sum of Amount Paid via Players

Players

16 fields · 6 sample rows

  • Roster (Grid)
  • Player cards (Cards)
  • Availability (Kanban)
  • Player registration (Form)
PlayerTextTeamLink to another tableJersey #NumberPositionTextDate of BirthDateAgeFormulaGuardianTextGuardian PhonePhoneEmailEmailMedical NotesLong textStatusSingle selectRegistration FeeCurrencyFee PaidCheckboxAmount PaidFormulaWaiver SignatureSignaturePhotoAttachment
Aditya RaoStrikers U149Striker14 Mar 201214Shalini Rao+91 98450 11001Active₹6,000Yes₹6,000
Leo FernandesStrikers U141Goalkeeper2 Jul 201214Maria Fernandes+91 98450 11002Sprained wrist — cleared in 2 weeks.Injured₹6,000Yes₹6,000
Harsh VardhanLions U1618Opening batter20 Nov 201015Rajiv Vardhan+91 98450 11003Active₹8,000₹0
Zoya KhanLions U167Leg spinner9 May 201016Imran Khan+91 98450 11004[email protected]Active₹8,000Yes₹8,000
Marcus LeeHoopers Open23Guard30 Jan 200125+91 99000 11005[email protected]Trial₹5,000₹0
Pranav MenonHoopers Open11Centre12 Aug 199927[email protected]Asthma — inhaler in kit bag.Active₹5,000Yes₹5,000
Field details
Player · Text
Team · Link to another table
Links to Teams
Jersey # · Number
Position · Text
Date of Birth · Date
Age · Formula
IF({Date of Birth}, DATETIME_DIFF(TODAY(), {Date of Birth}, 'years'), BLANK())
Guardian · Text
Guardian Phone · Phone
Email · Email
Medical Notes · Long text
Status · Single select
Active, Trial, Injured, Inactive
Registration Fee · Currency
INR
Fee Paid · Checkbox
Amount Paid · Formula
IF({Fee Paid}, {Registration Fee}, 0)
Waiver Signature · Signature
Photo · Attachment

Form view “Player registration” asks for: Player, Team, Date of Birth, Position, Guardian, Guardian Phone, Email, Medical Notes, Waiver Signature, Photo.

Sports Roster 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