How to Use the Onespot Staff Clock-In / Clock-Out System
How to Use the Onespot Staff Clock-In / Clock-Out System
The Onespot Staff Clock-In / Clock-Out feature allows employees to quickly record their work hours directly in your schoolโs app. It uses Onespot Forms + a Google Sheets template to help administrators automatically calculate hours worked for each pay period.
This system is simple, accurate, and eliminates the need for paper timesheets or manual entry.
๐ ๏ธ Step 1 โ Add the Staff Clock-In / Clock-Out Screen
-
Tap the โก Lightning Bolt (Administrative Superpowers).
Go to Content โ New Screen.
Select the โStaff Clock In / Clock Outโ template.
- You may rename it (e.g., โEmployee Time Trackingโ).
- Restrict access to Staff or Faculty only.
- Tap Create.
The form automatically includes:
- Employee name (pre-filled)
- Date
- Time
- Clock-in / Clock-out selector
- Optional notes
๐งโ๐ซ Step 2 โ Staff Clock In or Clock Out
Employees simply open the screen and:
1. Select โClock Inโ or โClock Outโ
2. Confirm the Date (auto-selected, but can be adjusted if they forgot to clock earlier)
3. Enter the Time (defaults to current time but can be adjusted)
4. Add an Optional Note
Examples:
- โRunning lateโ
- โLeft early for appointmentโ
- โLunch breakโ
Submit โ The entry is saved immediately.
๐ฅ Step 3 โ View Responses as an Admin
- Go to the โก Lightning Bolt
- Select Form Responses
- Open Staff Clock-In / Clock-Out
Youโll see all submissions including:
- Employee name
- Clock-in / clock-out
- Date
- Time
- Notes
You can also click a specific entry for more details.
๐ UPDATE: Automatic Sheet Sync (No Download Needed)
๐ค Step 4 โ Submissions Sync Automatically to Google Sheets
Once a staff member submits a clock-in or clock-out entry, the response is automatically sent to the linked Hours Calculation Template
Youโll see new entries appear automaticallyโno exporting or downloading needed.
Important: For correct hour calculations, each employee must have both a clock-in and a clock-out entry for the same date.
๐ Step 5 โ Use the Hours Calculation Template (Google Sheets)
We provide a Google Sheets template that automatically calculates total hours per pay period for each employee.
How to Use the Template
-
In the Hours per Period tab, enter your Pay Period Start Dates (e.g., every 7 or 14 days).
List your Employee Names.
The sheet automatically calculates:
- Hours per employee
- Hours per period
- Weekly totals
- Notes (pulled directly from submissions)
- (Optional) Add hourly rates to calculate total pay.
This template lets you quickly review:
- Work hours per staff member
- Any schedule irregularities
- Notes explaining late arrivals or early departures
๐ง Why Use This Feature?
The Onespot Clock-In / Clock-Out system provides a simple, app-based workflow for tracking employee hours. It eliminates paper logs, reduces payroll errors, and saves administrators significant time. Staff can clock in with one tap, and admins get organized, exportable records that integrate easily into payroll.