Control Asistencia Laboral con GPS y Google Sheets como Base de Datos

Introduction to the Attendance Tracking Web Application

Overview of Features

• The web application connects to a Google spreadsheet for labor attendance tracking, featuring GPS location capture and email notifications when an employee marks their attendance.

• It includes two user profiles: Employee (user profile) for marking entry/exit and Administrator for configurations and user management.

User Experience

• Demonstration begins with screen projection of the mobile app; emphasizes the need for GPS activation and permission granting for accurate location capture.

• Users must enter credentials, select their role as 'user', and grant permissions to successfully register attendance.

Practical Demonstration of Attendance Registration

Marking Entry

• After entering credentials, users receive a prompt to allow location access; upon approval, entry is registered successfully.

Marking Exit

• The demonstration continues with an employee marking their exit after previously registering entry; system auto-fills previous data like date and time.

Handling Permission Issues

Consequences of Denied Permissions

• If an employee denies permission, they cannot register their entry. A practical example shows what happens when permissions are blocked.

Restoring Permissions

• To restore permissions, users must navigate settings on their device to reset them before attempting registration again.

Device Compatibility and Information Storage

Device Requirements

• The application functions on various devices (mobile phones, tablets, laptops), provided they have integrated GPS capabilities.

Data Management

• All attendance information is stored in the system and notifications are sent via email whenever an employee registers their attendance.

Email Notifications System

Notification Configuration

• Emails can be configured within the system to notify supervisors or administrators about employees' entries/exits in real-time.

Example Notifications

• An example notification details that Pedro Martínez marked his entry along with timestamp and location data accessible through Google Maps.

Attendance Management System Overview

User Functionality and Notifications

• Employees must check in at a designated location, marking their attendance to ensure supervisors can confirm their arrival.

• The application allows employees to log their entry and exit times, which are stored for supervisor review.

Administrator Profile Features

• The administrator profile offers more options and is user-friendly on both desktop and mobile devices.

• Administrators can access reports, user management, and notifications through the main menu.

Attendance Reporting

• Administrators can filter attendance records by date to view employee check-ins, including names, areas, positions, entry/exit times, and total hours worked.

• The system captures GPS data for each check-in location; this feature enhances accountability by allowing verification of where employees clocked in.

Data Management Capabilities

• Attendance data can be filtered by various criteria (employee name, date range), making it easy to manage records over time.

• Exporting attendance data to Excel is straightforward; administrators can download comprehensive reports for further analysis.

User Creation and Notification Settings

• New users can be created with specific credentials that determine their access level (administrator or employee).

• Username patterns may vary; examples include initials or email addresses. Password security is also emphasized during setup.

Notification System for Real-Time Updates

• Administrators can set up email notifications to receive alerts when employees mark their attendance. This feature ensures real-time awareness of staff presence.

Implementation of Attendance Control System

Overview of the Application

• The local store operates based on the specified time, emphasizing that the utility of this application will depend on specific use cases.

• The system is user-friendly with two profiles: employee and administrator. It captures location via GPS, which is recommended for mobile devices as they typically have this feature.

• Users can register attendance from laptops equipped with GPS, demonstrating flexibility in device usage.

Implementation Steps

• To implement the system, a Google account (Gmail) is required. Files necessary for implementation are downloaded to the desktop.

• The first file contains default user credentials for system access and user creation. This facilitates initial interaction with the application.

Setting Up Google Drive

• A new folder named "Control de Asistencia Laboral" is created in Google Drive to organize project files.

• A Google Sheet titled "Control de Asistencia Laboral" must be created to support the application structure by importing necessary sheets.

Importing Data and Code

• Excel sheets required by the application are uploaded into the newly created Google Sheet using the import function.

• Two programming code files need to be created; one is a script file where existing code will be copied.

Finalizing Code Setup

• The existing code from a separate GS file is copied into the project’s script section after removing default content.

• An HTML file named "Index" is added to structure web elements, followed by copying relevant HTML content into it.

Configuring Unique Identifiers

• Each Google Sheet has a unique ID that needs to be integrated into the code. This ID can be found in the URL of the sheet.

• After locating and copying this unique ID, it should be pasted within designated areas in your project’s code.

Completing Implementation Process

Implementation of Attendance Application

Setting Up User Access and Permissions

• The process begins by granting access to any user, followed by implementing necessary permissions for the application.

• Users must navigate to the advanced settings in their Google Sheets to manage permissions effectively, ensuring the application functions correctly.

• It is crucial not to share the Google Sheet link with anyone except the system implementer for security reasons.

Application Functionality and User Creation

• Upon successful implementation, users can log into the system using a default administrator account.

• The first task involves creating new users; an example provided is "Renzo Tarazona," with specific details like area, position, and profile being customizable based on company structure.

Notification System Integration

• Users can set up notifications via email when attendance is marked; this ensures supervisors are informed about employee check-ins.

• After configuring notifications, a test entry is made for Renzo Tarazona to validate if notifications are sent correctly.

Validating Attendance Records

• The application allows checking if notifications were received upon marking attendance; confirmation was found in Gmail showing that Renzo successfully checked in.

• Users can also consult reports within the application to view attendance records, including check-in times.