Attendance System: Streamlining Employee Check-Ins with Power Apps

The Attendance System I built using Power Apps is designed to simplify and enhance the tracking of employee attendance for both office staff and site engineers. This app features three distinct pages, each serving a critical function in the workflow:

1. Login Screen

The system automatically logs in users through their Microsoft Office account, eliminating the need for manual credential input. This seamless integration ensures ease of access and links attendance records directly to the respective user, maintaining accuracy and accountability.

2. Adding Records

The second page is the core of the app, where employees can log their attendance. Users can select from three status options:

  • Arrive
  • Exit
  • On the Way
  • Work from Home

Additionally, they can specify their location by choosing Office or Site. For those selecting "Site," a Site ID field is required for precise tracking.

To enhance functionality, the app automatically detects the user’s current latitude and longitude, enabling the management team to verify whether site engineers are physically present at the site. Employees can also add a Note to provide further details about their attendance before submitting the record using the Save button.

3. Viewing Records

After submission, users are redirected to the third page, which displays the past 30 days of records. This page provides a clear overview of attendance history, promoting transparency and accountability.

Data Storage and Access

All attendance records are securely stored in both OneDrive and a SharePoint list. This dual storage system ensures easy access and backup for the management team. Records are readily available for review, helping management monitor and manage attendance for office staff and site engineers effectively.

Why This Matters

This Attendance System optimizes the tracking process, reduces manual errors, and introduces a level of accountability for employees. The integration of geolocation tracking and centralized data storage empowers management with the tools they need to oversee operations smoothly, whether at the office or on-site.




Popular posts from this blog

Comparing VLOOKUP and INDEX-MATCH

Image
When working with Excel, especially with large datasets, the ability to efficiently find and retrieve data is crucial. Two common lookup tools are VLOOKUP and INDEX-MATCH . While both can achieve similar results, they differ significantly in terms of functionality, flexibility, and performance. Let's break down the key differences to help you choose the right one for your tasks. Feature VLOOKUP INDEX-MATCH Basic Function Searches for a value in the first column and returns a value in the same row from another column. Uses the combination of INDEX (returns a value from a specific row and column) and MATCH (finds the position of a value in a range). Syntax =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) =INDEX(range, MATCH(lookup_value, lookup_range, [match_type])) Direction of Lookup Left to right only. Flexible: left to right, right to left, or vertical. Column Inde...
Read more

Create Multiple Folders Using Excel and a Batch File

Image
This guide explains how to create multiple folders using Excel and the CONCAT function to automate the process with a batch file. By following these steps, the ' md '  (make directory) command can be combined with folder names from Excel for efficient folder creation. 1) Prepare Folder Names in Excel Enter the folder names in Column A . In Column B , use the CONCAT function to combine the ' md ' command with the folder names from Column A.         2) Copy and Save as a Batch File After the ' md ' commands are generated in Column B , copy the entire Column B . Open Notepad or any text editor and paste the copied commands. Save the file as CreateFolders.bat . Ensure the file is saved with the .bat extension by selecting All Files in the "Save as type" dropdown.              3)  Run the Batch File Navigate to the folder where the batch file ( CreateFolders.bat ) was saved. Double-click the batch fil...
Read more

Manage Outlook Data File Size in Windows

Image
The default data file size in Outlook for Windows depends on the version of Outlook you're using: Outlook 2010 and Later (Unicode format): The default maximum size is 50 GB Outlook 2007 and 2003 (Unicode format - if applicable): The default maximum size is 20 GB These are the default limits, but it's possible to configure a larger or smaller maximum size by editing the Windows registry. Steps to Increase Outlook Data File Size: 1) Open the Registry Editor: ·        Press Windows + R, type regedit, and press Enter.  2) Navigate to the Registry Path: ·        For Outlook 2016, 2019, and Office 365: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\PST ·        For Outlook 2013: HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\PST ·        For Outlook 2010: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\PST   3) Cr...
Read more