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
Tables
Employees, Leave requests
Fields
21
Views
grid, kanban, calendar, form, dashboard
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.
8 fields · 4 sample rows
| EmployeeText | DepartmentSingle select | ManagerText | Annual allowanceNumber | Leave requestsLink to another table | Days takenRollup | Pending daysRollup | BalanceFormula |
|---|---|---|---|---|---|---|---|
| Ananya Iyer | Engineering | Vikram Rao | 24.0 | Diwali trip home | 5 | 0 | 19 |
| Marcus Johnson | Sales | Neha Kapoor | 20.0 | Fever, Long weekend | 1 | 0 | 19 |
| Kavya Reddy | Support | Rachel Thomas | 24.0 | Bank errand, Sister’s wedding | 3 | 0.5 | 21 |
| Oliver Smith | Finance | Arjun Mehta | 25.0 | Christmas in Manchester | 0 | 8 | 25 |
13 fields · 6 sample rows
| RequestText | EmployeeLink to another table | Leave typeSingle select | Start dateDate | End dateDate | Half dayCheckbox | Working daysFormula | StatusSingle select | Approved daysFormula | Pending daysFormula | ApproverText | ReasonLong text | Supporting documentAttachment |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Diwali trip home | Ananya Iyer | Annual | 30 Oct 2026 | 5 Nov 2026 | 5 | Approved | 5 | 0 | Vikram Rao | |||
| Fever | Marcus Johnson | Sick | 13 Nov 2026 | 14 Nov 2026 | 1 | Approved | 1 | 0 | Neha Kapoor | |||
| Christmas in Manchester | Oliver Smith | Annual | 24 Dec 2026 | 4 Jan 2027 | 8 | Pending | 0 | 8 | ||||
| Bank errand | Kavya Reddy | Casual | 21 Nov 2026 | 21 Nov 2026 | Yes | 0.5 | Pending | 0 | 0.5 | |||
| Sister’s wedding | Kavya Reddy | Annual | 3 Dec 2026 | 7 Dec 2026 | 3 | Approved | 3 | 0 | Rachel Thomas | |||
| Long weekend | Marcus Johnson | Annual | 27 Nov 2026 | 28 Nov 2026 | 1 | Rejected | 0 | 0 | Neha Kapoor | Quarter-end close — please pick another date. |
Form view “Request time off” asks for: Request, Employee, Leave type, Start date, End date, Half day, Reason, Supporting document.
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.
Record daily check-ins per employee and get each person’s attendance rate and hours worked automatically.
2 tables · 17 fieldsEmployee Info SheetOne clean record per employee — role, contact, emergency details, documents and tenure — in a searchable staff directory.
1 table · 17 fieldsRecruitment TrackerManage open roles and every applicant against them — source, stage, interviews, ratings and expected pay — with a live hiring funnel.
2 tables · 30 fieldsCOVID-19 Quarantine TrackerLog each employee who is isolating, their test results and symptoms, and see exactly when they are cleared to return.
1 table · 14 fieldsEmployee Onboarding TemplateRun every new hire through a shared plan — before day one to the 90-day mark — with owners, due dates and live progress per person.
2 tables · 23 fieldsEmployee Referral TrackingCollect referrals from staff, move candidates through the hiring stages and keep referral bonuses straight per employee.
2 tables · 24 fields