Leave Request Tracker

Take leave requests through a form, approve them, and keep each employee’s remaining balance up to date automatically.

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

Human Resources

Tables

Employees, Leave requests

Fields

21

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.

Employees

8 fields · 4 sample rows

  • Balances (Grid)
EmployeeTextDepartmentSingle selectManagerTextAnnual allowanceNumberLeave requestsLink to another tableDays takenRollupPending daysRollupBalanceFormula
Ananya IyerEngineeringVikram Rao24.0Diwali trip home5019
Marcus JohnsonSalesNeha Kapoor20.0Fever, Long weekend1019
Kavya ReddySupportRachel Thomas24.0Bank errand, Sister’s wedding30.521
Oliver SmithFinanceArjun Mehta25.0Christmas in Manchester0825
Field details
Employee · Text
Department · Single select
Engineering, Sales, Marketing, Operations, Finance, People, Support
Manager · Text
Annual allowance · Number
Leave requests · Link to another table
Links to Leave requests
Days taken · Rollup
sum of Approved days via Leave requests
Pending days · Rollup
sum of Pending days via Leave requests
Balance · Formula
{Annual allowance} - {Days taken}

Leave requests

13 fields · 6 sample rows

  • All requests (Grid)
  • Approvals (Kanban)
  • Who’s out (Calendar)
  • Request leave (Form)
  • Leave insights (Dashboard)
RequestTextEmployeeLink to another tableLeave typeSingle selectStart dateDateEnd dateDateHalf dayCheckboxWorking daysFormulaStatusSingle selectApproved daysFormulaPending daysFormulaApproverTextReasonLong textSupporting documentAttachment
Diwali trip homeAnanya IyerAnnual30 Oct 20265 Nov 20265Approved50Vikram Rao
FeverMarcus JohnsonSick13 Nov 202614 Nov 20261Approved10Neha Kapoor
Christmas in ManchesterOliver SmithAnnual24 Dec 20264 Jan 20278Pending08
Bank errandKavya ReddyCasual21 Nov 202621 Nov 2026Yes0.5Pending00.5
Sister’s weddingKavya ReddyAnnual3 Dec 20267 Dec 20263Approved30Rachel Thomas
Long weekendMarcus JohnsonAnnual27 Nov 202628 Nov 20261Rejected00Neha KapoorQuarter-end close — please pick another date.
Field details
Request · Text
Employee · Link to another table
Links to Employees
Leave type · Single select
Annual, Sick, Casual, Parental, Bereavement, Unpaid
Start date · Date
End date · Date
Half day · Checkbox
Working days · Formula
IF(AND({Start date}, {End date}), IF({Half day}, 0.5, WORKDAY_DIFF({Start date}, {End date})), 0)
Status · Single select
Pending, Approved, Rejected, Cancelled
Approved days · Formula
IF(AND({Status} = 'Approved', {Leave type} != 'Unpaid'), {Working days}, 0)
Pending days · Formula
IF({Status} = 'Pending', {Working days}, 0)
Approver · Text
Reason · Long text
Supporting document · Attachment

Form view “Request time off” asks for: Request, Employee, Leave type, Start date, End date, Half day, Reason, Supporting document.

Leave Request Tracker: 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