ApplicationCase studyBusiness ToolOperations

2DQY OA · Attendance and Leave Management

Connect leave schedules, overtime and leave balances, from calendar review and record checks to automatic leave allocation and exports for everyday team administration.

Audience
Teams & operators

No public application link is provided. Explore the case study and screenshots.

Screenshots & demos

Open image

Project overview

For administrators and team leads who maintain leave and overtime records, this workspace brings together three practical questions: who is away, how much leave remains and whether the records agree. Start with employees and their joining dates, maintain balance adjustments, then record leave and overtime. Calendar and employee views support both work planning and enquiries about individual balances.

From the monthly calendar to employee records

  • Team calendar: The monthly calendar shows leave, overtime and public holidays together. Select a date to review its events, move between months or expand the calendar.
  • Holidays and company arrangements: Mainland China and Hong Kong holidays can be viewed separately as calendar references, while special company holidays and working days can be maintained manually.
  • Employee record filters: Employee records can be filtered by name, joining date and leave type, helping users move from the team schedule to particular people and dates.

Connecting leave deductions and time off in lieu

  • Leave entries and balance checks: Leave can cover full days or a half-day on a single date. The tool calculates the duration using the maintained working days and holidays, and flags reversed dates, periods with no deductible working days or insufficient balances for the selected annual leave or time off in lieu. Automatic allocation can split one leave period across leave types according to available balances, leaving records that can be reviewed afterwards.
  • Overtime conversion: Overtime is recorded separately by date and hours, converted to time off in lieu under the team's rules and shown on the calendar.
  • Corrections and supporting notes: Deleting an incorrect overtime record recalculates the related balance. Annual leave and time-off-in-lieu adjustments help carry forward existing records, while dated employee notes capture supporting information for monthly review.

Exports and scope

Export leave, overtime durations and current balances for further reconciliation and discussion. Connecting schedules, detailed records and balance calculations reduces the need to search across separate spreadsheets for an explanation. Calculations follow the team's current rules; the product covers record keeping and reporting, rather than a full HR or approval workflow.

Ownership & delivery

I independently designed and delivered the attendance and leave application, covering requirements, interaction design, full-stack development and deployment. Implemented employee records, working-day rules, leave deductions, overtime credit and exports so calendar plans, transaction details and balances can be reconciled.

Explore more work with similar capabilities or uses.

ApplicationAccount required

Vehicle Storage & Daily Fee Management

Connect intake inspections, inventory checks and release charges in a vehicle record, with location-based responsibilities, photos, history and exports for handovers and reconciliation.

Business ToolOperations
View case study
ApplicationOpen application

i2 Health · Care Insights and Management

Connect conversation summaries, blood pressure and glucose trends, and items needing attention across a care circle, supporting individual review, follow-up status tracking and handover preparation.

HealthcareAIBusiness Tool
View case study
ApplicationOpen application

AI Mock Interview

Prepare questions from a target role and personal experience, then practise with spoken questions, typed or dictated answers, follow-ups and detailed feedback on what to work on next.

AIEducationBusiness Tool
View case study