THP-Ghana Attendance

A world without hunger

Smart
Attendance

Attendance & leave management for The Hunger Project Ghana — powered by Google Sheets.

☁️Live Google Sheets sync

🏖Leave management

🔔Gmail notifications

Welcome back

Enter your credentials to sign in

Staff ID

👤

Password

🔒

Forgot password?

Clock In / Out

00:00:00

Signed Out

Hours Today

0.00

hours worked

Days This Month

0

days present

Avg Hours/Day

0.00

average

Early Exits

0

this month

My Attendance Logs

Your complete attendance history

Records

All Active Done Early

Showing 0 records

Date	Unit	In	Out	Hours	Status

Leave Management

Apply for leave and track your requests

Apply for Leave

Your request goes to your supervisor first. Once approved, it goes to the Country Leader (Agatha Quayson) for final sign-off.

🌴

Annual Leave

24 days/yr

🏥

Sick Leave

Medical certificate required

👶

Maternity

~3 months

👨‍👶

Paternity

5 days

🕊

Compassionate

5 days

⏰

Compensatory

For extra days worked

Start Date

End Date

Reason / Notes

Handover Note (optional — your supervisor can download this)

Supervisor *

Final approval by: Agatha Quayson — Country Leader

My Leave History

Type	Start	End	Days	Supervisor	Final Approver	Status	Note

My QR Code

Display or share for quick clock-in

Your Personal QR

When scanned, opens the attendance portal with your profile pre-loaded.

Generating…

My Profile

Update your contact information

👤 Staff

— · Staff

Email Address

Phone Number

Emergency Contact (Name & Phone)

Change Password

Update your account password

🔑 Set New Password

🔐

First time signing in?

You are using a default password. Please change it now to secure your account.

Current Password

New Password

Confirm New Password

⚠ If you use multiple devices, your new password will apply on all devices after the next sync.

My Leave

Apply for leave and track your requests

Apply for Leave

Your request goes directly to Supervisors & CL for approval. All leave days exclude weekends and public holidays.

🌴

Annual Leave

24 days/yr

🏥

Sick Leave

Medical certificate required

👶

Maternity

~3 months

👨‍👶

Paternity

5 days

🕊

Compassionate

5 days

⏰

Compensatory

For extra days worked

Start Date

End Date

Reason / Notes

Handover Note (optional — your supervisor can download this)

My Leave History

Type	Start	End	Days	Final Approver	Note

Clock In / Out

00:00:00

Signed Out

Hours Today

0.00

hours worked

Days This Month

0

days present

Avg Hours/Day

0.00

average

Early Exits

0

this month

Team Dashboard

Team Attendance Today

Name	Unit	In	Out	Hours	Status

Team Records

Attendance records for your unit

Records

All Active Done Early

Showing 0 records

Date	Name	In	Out	Hours	Status

My Attendance Logs

Your personal attendance history

Records

Showing 0 records

Date	Unit	In	Out	Hours	Status

Leave Review

Review leave requests from your team — your decision forwards them to the Country Leader for final sign-off

Pending My Review

Staff	Type	Dates	Days	Reason	Doc	Action

Attendance Report

Present staff attendance summary

Records

From To

🔍

📄 Staff Contracts

Track contract expiry dates and get early reminders before renewal is due

Contract Status

🔍

Staff	Unit	Contract Start	Contract End	Status	Actions

💡 Note: 🔴 = expired or expiring within 30 days, 🟠 = within 60 days, 🟢 = beyond 60 days. Click "Edit" to set or update a staff member's contract dates.

📒 Leave History

Record of all leave decisions you've made

Decision Log

0 records

Staff	Unit	Type	Dates	Days	Decision	Your Note	Date Decided

My Profile

Update your contact information

👤 Manager

— · Manager

Email Address

Phone Number

Emergency Contact (Name & Phone)

Leave Approval Delegation

Allow someone to approve leave on your behalf when you are out of office

🔄 Delegation Settings

Delegate To

Delegation Start

Delegation End

Change Password

Update your account password

Set New Password

🔐

First time signing in?

You are using a default password. Please change it now to secure your account.

Current Password

New Password

Confirm New Password

⚠ If you use multiple devices, your new password will apply on all devices after the next sync.

Control Panel

Attendance by Unit

Status Breakdown

All Records

Company-wide attendance data

All Records

All Active Done Early

Showing 0 records

Date	Name	Unit	In	Out	Hours	Status	Action

Staff Management

Add, edit or remove staff accounts

Add New Staff Member

Staff ID

Full Name

Unit

Role

Gender

Supervisor

Password

Email (for notifications)

Leave Management

All leave requests across the organisation

All Leave Requests

Staff	Unit	Type	Dates	Days	Reason	Supervisor	Final Approver	Action

📒 Leave Register

Official HR record of all finalized leave decisions

Finalized Leave Records

0 records

Staff	Unit	Type	Start	End	Days	Supervisor	Final Approver	Status	Notes	Date

Staff Reports

Per-staff attendance summary

Summary Report

ID	Name	Unit	Role	Days	Hrs	Avg	Early	Rate

Entrance QR Code

Print and place at the office entrance

🌐 Hosted URL

THP-Ghana Staff Attendance

Scan with your phone camera to clock in or out

Enter your hosted URL above

Country Leader Delegation

Allow someone to approve leave on the Country Leader's behalf when she is out of office

🔄 Delegation Settings

Delegate To

Delegation Start

Delegation End

Google Sheets Mirror

Backup sync & email notification settings

GAS Connection (Email & Backup)

⚠ Not Connected

📊 Primary database: Supabase (fast, 100-300ms responses)
📋 Google Sheets: Auto-backup mirror every 6 hours
📧 Apps Script: Handles email notifications (leave decisions, password changes)

Apps Script Web App URL (for emails & mirror)

📋 Setup Guide

1

Create a Google Sheet — Go to sheets.google.com, create a new spreadsheet named THP Attendance.

2

Open Apps Script — Click Extensions → Apps Script. Delete existing code.

3

Paste Code.gs — Copy the full contents of Code.gs and paste it. Save.

4

Deploy as Web App — Deploy → New Deployment. Type: Web App. Execute as: Me. Access: Anyone. Authorise.

5

Paste URL above — Copy the Web App URL and paste it in the field above. Save & Connect.

6

Email notifications — Add staff email addresses in Staff Management. The system will email clock-in/out confirmations and leave decisions automatically via Gmail.

📅 Public Holidays

Manage Ghana public holidays and custom office closures

Holidays for

0 holidays

Add Holiday

Holiday Name

Date

Type

Recurring yearly

Date	Holiday	Type	Scope	Actions

💡 Tips: Click "Seed Ghana Holidays" to auto-populate all 15 standard holidays for the selected year (incl. Eid estimates & Farmer's Day). Eid dates are estimated — update them when the government announces official dates. You can also add government-declared holiday extensions or custom office closures.

📄 Staff Contracts

Track contract expiry dates and get early reminders before renewal is due

Contract Status

🔍

Staff	Unit	Contract Start	Contract End	Status	Actions

💡 Note: 🔴 = expired or expiring within 30 days, 🟠 = within 60 days, 🟢 = beyond 60 days. Click "Edit" to set or update a staff member's contract dates.

Change Admin Password

Update the administrator account password

🔑 Admin Password

Current Password

New Password

Confirm New Password

Clock In / Out

✈️ Register Work Trip

⚠ Early Departure

My Attendance Logs

Records

Leave Management

Apply for Leave

My Leave History

My QR Code

Your Personal QR

My Profile

👤 Staff

Change Password

🔑 Set New Password

My Leave

Apply for Leave

My Leave History

Clock In / Out

✈️ Register Work Trip

⚠ Early Departure

Team Dashboard

Team Attendance Today

Team Records

Records

My Attendance Logs

Records

Leave Review

Pending My Review

Attendance Report

Records

📄 Staff Contracts

Contract Status

📒 Leave History

Decision Log

My Profile

👤 Manager

Leave Approval Delegation

🔄 Delegation Settings

Change Password

Set New Password

Control Panel

Attendance by Unit

Status Breakdown

All Records

All Records

Staff Management

Add New Staff Member

Leave Management

All Leave Requests

📒 Leave Register

Finalized Leave Records

Staff Reports

Summary Report

Entrance QR Code

THP-Ghana Staff Attendance

Country Leader Delegation

🔄 Delegation Settings

Google Sheets Mirror

GAS Connection (Email & Backup)

📋 Setup Guide

📅 Public Holidays

Holidays for

Add Holiday

📄 Staff Contracts

Contract Status

Change Admin Password

🔑 Admin Password

Edit Staff Member

📄 Edit Contract Dates

Review Leave Request